aitables-mcp

MCP server for AiTables — lets Claude Code (and Claude Desktop) read and manage your AiTables databases, tables, and rows.

Quick Start

1. Get your API key

In AiTables, go to any database → click the dropdown menu → API Keys → create a new key with the permissions you need.

2. Configure Claude Code

Add to your project's .mcp.json (or ~/.claude.json for global access):

{
  "mcpServers": {
    "aitables": {
      "command": "npx",
      "args": ["-y", "aitables-mcp"],
      "env": {
        "AITABLES_API_KEY": "ait_user_xxxxxxxxxxxx"
      }
    }
  }
}

3. Use it

Just talk to Claude naturally:

• "What databases do I have?"
• "Show me the columns in my Projects table"
• "Create a task tracker with Status, Priority, and Due Date columns"
• "Add a row: Status = Todo, Priority = High, Due Date = 2026-04-01"
• "Find all rows mentioning 'urgent'"

Tools

| Tool | Description | |------|-------------| | list_workspaces | List accessible workspaces | | list_databases | List databases (optionally by workspace) | | create_database | Create a database in a workspace | | get_database | Get a single database | | update_database | Rename / re-describe / re-icon a database | | delete_database | Delete a database and all its contents | | list_tables | List tables in a database | | get_table_schema | Get column names, types, and settings | | create_table | Create a table with columns | | update_table | Rename / re-describe / re-icon a table | | delete_table | Delete a table and all its rows | | add_columns | Add columns to a table | | update_column | Update column name/options/settings | | delete_column | Delete a column and its data | | list_rows | Query rows with filters, sorting, pagination | | create_rows | Create one or more rows | | update_rows | Update specific cells in rows | | delete_rows | Delete rows | | search_rows | Cross-column text search | | export_table | Export all table data | | list_table_folders | List folders that group tables in a database | | create_table_folder | Create a folder for tables (nestable) | | update_table_folder | Rename / re-icon / re-color a table folder | | delete_table_folder | Remove a table folder (tables survive) | | move_table_to_folder | Move a table into a folder (or to root) | | list_database_folders | List folders that group databases in a workspace | | create_database_folder | Create a folder for databases | | update_database_folder | Rename / re-icon / re-color a database folder | | delete_database_folder | Remove a database folder (databases survive) | | move_database_to_folder | Move a database into a folder (or to root) | | list_views | List a table's saved views | | get_view | Get one view incl. full settings | | create_view | Create a view (table/kanban/calendar/…) | | update_view | Update view name/type/settings/public | | delete_view | Delete a view (not the last one) | | reorder_views | Reorder a table's views | | list_view_shares | List public share links for a view | | create_view_share | Create a public share link | | deactivate_view_share | Revoke a share link | | get_row_history | Edit history for a single row | | get_table_history | Paginated edit history for a table |

Smart Column Handling

When you create select/multiselect columns, just provide the option values — colors are auto-assigned:

"Create a Status column with options: Todo, In Progress, Done"

The server generates properly colored options that render correctly in the AiTables UI. This also applies to tags and label columns.

Environment Variables

| Variable | Required | Description | |----------|----------|-------------| | AITABLES_API_KEY | Yes | Your AiTables API key (ait_user_* or ait_live_*) | | AITABLES_API_URL | No | Override the API base URL (for custom domains) |

Development

cd addai-tables/mcp
npm install
npm run build
npm run dev    # watch mode

For local testing, point your .mcp.json to the built output:

{
  "mcpServers": {
    "aitables": {
      "command": "node",
      "args": ["path/to/addai-tables/mcp/dist/index.js"],
      "env": {
        "AITABLES_API_KEY": "ait_user_xxxxxxxxxxxx"
      }
    }
  }
}