{"_id":"@addai/tables-mcp","_rev":"2-9784df083abfd325292ee2d92a9e2949","name":"@addai/tables-mcp","dist-tags":{"latest":"0.8.0"},"versions":{"0.7.0":{"name":"@addai/tables-mcp","version":"0.7.0","keywords":["mcp","claude","aitables","airtable","database","model-context-protocol"],"license":"MIT","_id":"@addai/tables-mcp@0.7.0","maintainers":[{"name":"addai","email":"npm@add.ai"}],"bin":{"tables-mcp":"dist/index.js"},"dist":{"shasum":"cc2920177901ce6a2a1bc075ea58d86ec605dc63","tarball":"https://registry.npmjs.org/@addai/tables-mcp/-/tables-mcp-0.7.0.tgz","fileCount":90,"integrity":"sha512-U68119dRVLGLPThRQZpWDqAOyt9aVgjhaX6BVnmNTNKGpsaKKLCeB4wBJ1Oj4c+SKTQVkWQXiWK/jvwlMIstRw==","signatures":[{"sig":"MEQCIAm19p4iqdzvFar0UBpBLn+vhtxDgtJ54cFDv19DdQZPAiAF3EuOn5kiUwrNPBLKkW42OoZwU5GU365zuqygq/QAgA==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":252171},"main":"./dist/index.js","type":"module","types":"./dist/index.d.ts","gitHead":"0cab034b09ae6d803e232df3977e68872680f1e5","scripts":{"dev":"tsc --watch","build":"tsc","start":"node dist/index.js"},"_npmUser":{"name":"addai","email":"npm@add.ai"},"_npmVersion":"10.9.2","description":"MCP server for AiTables — lets Claude Code read and manage your AiTables databases","directories":{},"_nodeVersion":"22.17.1","dependencies":{"zod":"^3.24.4","@modelcontextprotocol/sdk":"^1.12.1"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.8.3","@types/node":"^22.15.3"},"_npmOperationalInternal":{"tmp":"tmp/tables-mcp_0.7.0_1783436438723_0.3675658721413573","host":"s3://npm-registry-packages-npm-production"}},"0.8.0":{"name":"@addai/tables-mcp","version":"0.8.0","description":"MCP server for AiTables — lets Claude Code read and manage your AiTables databases","type":"module","bin":{"aitables-mcp":"dist/index.js"},"main":"./dist/index.js","scripts":{"build":"tsc","dev":"tsc --watch","start":"node dist/index.js"},"keywords":["mcp","claude","aitables","airtable","database","model-context-protocol"],"license":"MIT","dependencies":{"@modelcontextprotocol/sdk":"^1.12.1","zod":"^3.24.4"},"devDependencies":{"@types/node":"^22.15.3","typescript":"^5.8.3"},"_id":"@addai/tables-mcp@0.8.0","gitHead":"a34508402f5aa7a510e6d6fdc94e5bd050d49ff2","types":"./dist/index.d.ts","_nodeVersion":"22.17.1","_npmVersion":"10.9.2","dist":{"integrity":"sha512-GYdS9BwfHU5Oy7hMqW9MEuqJjVpjeNJzg7ixM5rpIBPcXxN9L5DoWTKzcdJtbfwfddG5lNIClZ+8Qtgby8uOvQ==","shasum":"5e36c98f90e503c0f95a94a8a49ebf4c3511f9fb","tarball":"https://registry.npmjs.org/@addai/tables-mcp/-/tables-mcp-0.8.0.tgz","fileCount":90,"unpackedSize":259074,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQDN9EnUwonAyfMo6aV455uCkHZDwM2eTEP2M7yK3MWLFgIhAL1YAFlxtQ/IW3wx5PI/dCBj8TX408NDNQPNHxcvjmqk"}]},"_npmUser":{"name":"addai","email":"npm@add.ai"},"directories":{},"maintainers":[{"name":"addai","email":"npm@add.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/tables-mcp_0.8.0_1785497749083_0.33357457069832486"},"_hasShrinkwrap":false}},"time":{"created":"2026-07-07T15:00:38.487Z","modified":"2026-07-31T11:35:49.468Z","0.7.0":"2026-07-07T15:00:38.868Z","0.8.0":"2026-07-31T11:35:49.292Z"},"license":"MIT","keywords":["mcp","claude","aitables","airtable","database","model-context-protocol"],"description":"MCP server for AiTables — lets Claude Code read and manage your AiTables databases","maintainers":[{"name":"addai","email":"npm@add.ai"}],"readme":"# aitables-mcp\r\n\r\nMCP server for [AiTables](https://tables.add.ai) — lets Claude Code (and Claude Desktop) read and manage your AiTables databases, tables, and rows.\r\n\r\n## Quick Start\r\n\r\n### 1. Get your API key\r\n\r\nIn AiTables, go to any database → click the dropdown menu → **API Keys** → create a new key with the permissions you need.\r\n\r\n### 2. Configure Claude Code\r\n\r\nAdd to your project's `.mcp.json` (or `~/.claude.json` for global access):\r\n\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"aitables\": {\r\n      \"command\": \"npx\",\r\n      \"args\": [\"-y\", \"aitables-mcp\"],\r\n      \"env\": {\r\n        \"AITABLES_API_KEY\": \"ait_user_xxxxxxxxxxxx\"\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n\r\n### 3. Use it\r\n\r\nJust talk to Claude naturally:\r\n\r\n- *\"What databases do I have?\"*\r\n- *\"Show me the columns in my Projects table\"*\r\n- *\"Create a task tracker with Status, Priority, and Due Date columns\"*\r\n- *\"Add a row: Status = Todo, Priority = High, Due Date = 2026-04-01\"*\r\n- *\"Find all rows mentioning 'urgent'\"*\r\n\r\n## Tools\r\n\r\n| Tool | Description |\r\n|------|-------------|\r\n| `list_workspaces` | List accessible workspaces |\r\n| `list_databases` | List databases (optionally by workspace) |\r\n| `create_database` | Create a database in a workspace |\r\n| `get_database` | Get a single database |\r\n| `update_database` | Rename / re-describe / re-icon a database |\r\n| `delete_database` | Delete a database and all its contents |\r\n| `list_tables` | List tables in a database |\r\n| `get_table_schema` | Get column names, types, and settings |\r\n| `create_table` | Create a table with columns |\r\n| `update_table` | Rename / re-describe / re-icon a table |\r\n| `delete_table` | Delete a table and all its rows |\r\n| `add_columns` | Add columns to a table |\r\n| `update_column` | Update column name/options/settings |\r\n| `delete_column` | Delete a column and its data |\r\n| `get_row` | Fetch one record by ID — resolves its table automatically when `table_id` is omitted |\r\n| `list_rows` | Query rows with filters, sorting, pagination |\r\n| `create_rows` | Create one or more rows |\r\n| `update_rows` | Update specific cells in rows |\r\n| `delete_rows` | Delete rows |\r\n| `search_rows` | Cross-column text search |\r\n| `export_table` | Export all table data |\r\n| `list_table_folders` | List folders that group tables in a database |\r\n| `create_table_folder` | Create a folder for tables (nestable) |\r\n| `update_table_folder` | Rename / re-icon / re-color a table folder |\r\n| `delete_table_folder` | Remove a table folder (tables survive) |\r\n| `move_table_to_folder` | Move a table into a folder (or to root) |\r\n| `list_database_folders` | List folders that group databases in a workspace |\r\n| `create_database_folder` | Create a folder for databases |\r\n| `update_database_folder` | Rename / re-icon / re-color a database folder |\r\n| `delete_database_folder` | Remove a database folder (databases survive) |\r\n| `move_database_to_folder` | Move a database into a folder (or to root) |\r\n| `list_views` | List a table's saved views |\r\n| `get_view` | Get one view incl. full settings |\r\n| `create_view` | Create a view (table/kanban/calendar/…) |\r\n| `update_view` | Update view name/type/settings/public |\r\n| `delete_view` | Delete a view (not the last one) |\r\n| `reorder_views` | Reorder a table's views |\r\n| `list_view_shares` | List public share links for a view |\r\n| `create_view_share` | Create a public share link |\r\n| `deactivate_view_share` | Revoke a share link |\r\n| `get_row_history` | Edit history for a single row |\r\n| `get_table_history` | Paginated edit history for a table |\r\n| `upload_file` | Upload a real local file into a FILE column (any size) |\r\n\r\n## Smart Column Handling\r\n\r\nWhen you create select/multiselect columns, just provide the option values — colors are auto-assigned:\r\n\r\n```\r\n\"Create a Status column with options: Todo, In Progress, Done\"\r\n```\r\n\r\nThe server generates properly colored options that render correctly in the AiTables UI. This also applies to tags and label columns.\r\n\r\n## Environment Variables\r\n\r\n| Variable | Required | Description |\r\n|----------|----------|-------------|\r\n| `AITABLES_API_KEY` | Yes | Your AiTables API key (`ait_user_*` or `ait_live_*`) |\r\n| `AITABLES_API_URL` | No | Override the API base URL (for custom domains) |\r\n\r\n## Development\r\n\r\n```bash\r\ncd addai-tables/mcp\r\nnpm install\r\nnpm run build\r\nnpm run dev    # watch mode\r\n```\r\n\r\nFor local testing, point your `.mcp.json` to the built output:\r\n\r\n```json\r\n{\r\n  \"mcpServers\": {\r\n    \"aitables\": {\r\n      \"command\": \"node\",\r\n      \"args\": [\"path/to/addai-tables/mcp/dist/index.js\"],\r\n      \"env\": {\r\n        \"AITABLES_API_KEY\": \"ait_user_xxxxxxxxxxxx\"\r\n      }\r\n    }\r\n  }\r\n}\r\n```\r\n","readmeFilename":"README.md"}