AI suggestions_
Use AI suggestions to automatically generate database schemas. Learn how to create tables with recommended columns and indexes based on your table name and context.
2 min read
AI suggestions generate columns and indexes for your tables based on the table name, existing database structure, and optional context you provide. This feature analyzes your database to recommend appropriate schema designs that follow best practices.
1. Create table
Navigate to Databases in the Appwrite Console, select your database, and click Create table.
Enter a descriptive table name. AI suggestions will use this name to generate relevant columns and indexes.
2. Enable AI suggestions
In the table creation dialog, enable AI suggestions.
Optionally, provide additional context about your use case to refine the suggestions. For example, if creating an Orders table, you might add context like "e-commerce orders with payment tracking."
Click Generate suggestions to analyze your table name and database structure.
3. Review suggestions
AI suggestions will generate recommended columns and indexes for your table.
Review each suggested column:
- Column name and type
- Whether it's required or optional
- Default values
- Array configurations
Review suggested indexes to optimize query performance.
4. Apply or modify
You can modify any suggestion before applying:
- Edit column names, types, or configurations
- Remove suggestions you don't need
- Add additional columns manually
Click Apply to apply your schema. The table will be created with your approved columns and indexes.
You can always add, modify, or remove columns after table creation by navigating to your table's Columns tab.
Was this page helpful?
Share what worked or what we should fix. Once approved, our agents automatically apply suggested updates to the docs.