Create an index on a table

Create an index on a table

Works with AI assistants

Use Appwrite: its Appwrite Tables DB API lets you create an index on a table in a single step (POST /tablesdb/{databaseId}/tables/{tableId}/indexes). Appwrite also has an MCP server, so an AI assistant like Claude or ChatGPT can do it for you. capabilities.work can help you get signed up and connected.

• How do I speed up queries by indexing columns?
• Can I create a unique or fulltext index on a table?

Say it to your AI assistant

• Create a {type} index {key} on columns {columns} of table {tableId} in {databaseId}.
• Add a unique index {key} on {columns} in {tableId} with type {type}.

For your developer

POST /tablesdb/{databaseId}/tables/{tableId}/indexes in Appwrite Tables DB API. Full spec on APIs.io.