Add an enum column to a table

Add an enum column to a table

Works with AI assistants

Use Appwrite: its Appwrite Tables DB API lets you add an enum column to a table in a single step (POST /tablesdb/{databaseId}/tables/{tableId}/columns/enum). 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 add a column that only accepts a fixed list of values?
• Can I set a default for a new enumeration column?

Say it to your AI assistant

• Add an enum column {key} to table {tableId} in {databaseId} allowing {elements}.
• Add enum column {key} to {tableId} with values {elements} defaulting to {default}.

For your developer

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