Skip to main content
The Database Assistant can build your entire database with a single prompt, or update your existing database with ease. We’ve built the assistant to follow best practices for database design, so you can focus on building your application and build with confidence.
Want to build it yourself? Learn how to use the Xano database in our Database Basics guide.
1

Click the Database Assistant button anywhere inside the database.

You’ll find the assistant in the top right corner and in the lower-right corner of the main database page.ai-database-assistant-20250926-081228You can also access the assistant from any table by clicking the button in the top-right corner.ai-database-assistant-20250926-081303
2

Ask a question or provide instructions to the AI assistant.

Here are some examples of things you can ask the AI assistant:
3

The suggestion(s) will be provided in a specific order. Step through each suggestion as you see fit and apply it by clicking Update Schema.

​
What else can I do with the Database Assistant?

1

Ask it to critique your database design

The Database Assistant is designed to ensure that best practices for database design are followed. If you’ve already built your database and just want to have it looked over, you can ask the assistant to check and make recommendations.
2

Modify existing schema faster

The database assistant has the ability to create and delete table columns, allowing you to modify your database tables even faster.
3

Create default Auto-generated APIs

When creating database tables, the Database Assistant can create default CRUD API endpoints for you. On the Create Table step, click the dropdown to select creating CRUD API endpoints with the table.

​
Note

We’re currently rolling out this feature to all users as part of our next release. If you don’t have it yet, you will soon! Hang tight.