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.
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.
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.
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.
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.
Manual columns
You can always add, modify, or remove columns after table creation by navigating to your table's Columns tab.