NocoDB MCP Server

About

## NocoDB MCP Server: Open Source Airtable Alternative The **NocoDB MCP Server** integrates NocoDB into Google Antigravity, enabling spreadsheet-database operations with REST APIs, automations, and self-hosting directly from your development environment. ### Why NocoDB MCP? - **Open Source**: Self-hostable Airtable alternative - **Database Backend**: Works with MySQL, PostgreSQL, SQL Server - **REST API**: Auto-generated APIs for all tables - **No-Code**: Spreadsheet interface for data management - **Extensible**: Webhooks and automations ### Key Features #### 1. Record Operations ```python # List records records = await mcp.list_records( table="Projects", limit=50, offset=0, where="(Status,eq,Active)", sort="-CreatedAt" ) for record in records["list"]: print(f"Project: {record['Name']}") # Get single record record = await mcp.get_record(table="Projects", id=123) ``` #### 2. Record Management ```python # Create record record = await mcp.create_record( table="Projects", data={ "Name": "New Project", "Status": "Planning", "DueDate": "2024-03-15", "Owner": "user@example.com" } ) # Update record await mcp.update_record( table="Projects", id=record["Id"], data={"Status": "In Progress"} ) # Delete record await mcp.delete_record(table="Projects", id=record["Id"]) ``` #### 3. Bulk Operations ```python # Bulk create records = await mcp.bulk_create( table="Tasks", records=[ {"Name": "Task 1", "ProjectId": 123}, {"Name": "Task 2", "ProjectId": 123}, {"Name": "Task 3", "ProjectId": 123} ] ) # Bulk update await mcp.bulk_update( table="Tasks", records=[ {"Id": 1, "Status": "Done"}, {"Id": 2, "Status": "Done"} ] ) ``` #### 4. Schema Operations ```python # List tables tables = await mcp.list_tables(base="MyBase") for table in tables: print(f"Table: {table['title']}") # Get table schema schema = await mcp.get_table_schema(table="Projects") for column in schema["columns"]: print(f"Column: {column['title']} ({column['uidt']})") ``` ### Configuration ```json { "mcpServers": { "nocodb": { "command": "npx", "args": ["-y", "@anthropic/mcp-nocodb"], "env": { "NOCODB_URL": "https://your-nocodb-instance.com", "NOCODB_API_TOKEN": "your-api-token" } } } } ``` ### Use Cases **Project Tracking**: Manage projects with spreadsheet simplicity. **Data Collection**: Collect and organize data from forms. **Internal Tools**: Build simple internal applications. **Legacy Integration**: Add APIs to existing databases. The NocoDB MCP enables no-code database operations within your development environment.

Installation

{
  "mcpServers": {
    "nocodb": {
      "mcpServers": {
        "nocodb": {
          "env": {
            "NOCODB_URL": "https://your-nocodb.com",
            "NOCODB_API_KEY": "your-api-key"
          },
          "args": [
            "-y",
            "nocodb-mcp-server"
          ],
          "command": "npx"
        }
      }
    }
  }
}

How to Use

1. 1Deploy NocoDB instance
2. 2Get API token
3. 3Manage bases and tables