Baserow MCP Server

About

## Baserow MCP Server: Open Source No-Code Database The **Baserow MCP Server** integrates Baserow into Google Antigravity, enabling no-code database operations with spreadsheet-like interface, API access, and self-hosting directly from your development environment. ### Why Baserow MCP? - **Open Source**: Self-hostable Airtable alternative - **No-Code**: Spreadsheet interface for non-developers - **API-First**: Full REST API access - **Real-Time**: Live collaboration and updates - **Extensible**: Plugin system for customization ### Key Features #### 1. Row Operations ```python # List rows rows = await mcp.list_rows( table_id=123, size=50, search="project", order_by="field_456", filter={ "field_789": {"contains": "active"} } ) for row in rows["results"]: print(f"Row: {row['field_123']}") # Get single row row = await mcp.get_row(table_id=123, row_id=456) ``` #### 2. Row Management ```python # Create row row = await mcp.create_row( table_id=123, data={ "field_name": "New Project", "field_status": "Planning", "field_due_date": "2024-03-15", "field_assignee": [1, 2] # Link to other rows } ) # Update row await mcp.update_row( table_id=123, row_id=row["id"], data={"field_status": "In Progress"} ) # Delete row await mcp.delete_row(table_id=123, row_id=row["id"]) ``` #### 3. Batch Operations ```python # Batch create rows = await mcp.batch_create_rows( table_id=123, rows=[ {"field_name": "Task 1"}, {"field_name": "Task 2"}, {"field_name": "Task 3"} ] ) # Batch update await mcp.batch_update_rows( table_id=123, rows=[ {"id": 1, "field_status": "Done"}, {"id": 2, "field_status": "Done"} ] ) ``` #### 4. Schema Operations ```python # List tables tables = await mcp.list_tables(database_id=1) for table in tables: print(f"Table: {table['name']}") # Get fields fields = await mcp.list_fields(table_id=123) for field in fields: print(f"Field: {field['name']} ({field['type']})") # Create field await mcp.create_field( table_id=123, name="Priority", field_type="single_select", options=["High", "Medium", "Low"] ) ``` ### Configuration ```json { "mcpServers": { "baserow": { "command": "npx", "args": ["-y", "@anthropic/mcp-baserow"], "env": { "BASEROW_URL": "https://api.baserow.io", "BASEROW_TOKEN": "your-api-token" } } } } ``` ### Use Cases **Project Management**: Track projects without complex setup. **Data Collection**: Collect and organize data from various sources. **Internal Tools**: Build simple internal applications. **Prototyping**: Quickly prototype data-driven applications. The Baserow MCP enables no-code database operations within your development environment.

Installation

{
  "mcpServers": {
    "baserow": {
      "mcpServers": {
        "baserow": {
          "env": {
            "BASEROW_URL": "https://api.baserow.io",
            "BASEROW_API_KEY": "your-api-key"
          },
          "args": [
            "-y",
            "baserow-mcp-server"
          ],
          "command": "npx"
        }
      }
    }
  }
}

How to Use

1. 1Get Baserow API token
2. 2Configure database URL
3. 3Manage tables