NocoDB MCP Server

A Model Context Protocol (MCP) server that provides a comprehensive interface to NocoDB - the open source Airtable alternative. This server enables AI agents to interact with NocoDB databases, making it perfect for storing and managing operational data across multiple AI teams.

Features

• Database Operations: List and manage NocoDB bases/projects
• Table Management: Create, list, and delete tables with custom schemas
• Column Management: Add columns to existing tables with full type support
• Record CRUD: Full create, read, update, delete operations on records
• Advanced Queries: Filter, sort, search, and aggregate data
• View Management: Create and use different views (Grid, Gallery, Form, etc.)
• Bulk Operations: Insert multiple records at once
• File Attachments: Upload files locally or from URLs, attach to records

Installation

Via NPM (Global)

npm install -g @andrewlwn77/nocodb-mcp

Via NPX (No installation)

npx @andrewlwn77/nocodb-mcp

Configuration

Environment Variables

Create a .env file in your project root:

# Required
NOCODB_BASE_URL=http://localhost:8080
NOCODB_API_TOKEN=your_api_token_here

# Optional
NOCODB_DEFAULT_BASE=your_default_base_id

Getting Your API Token

1. Log into your NocoDB instance
2. Click on your profile icon
3. Select “API Tokens”
4. Create a new token with appropriate permissions

MCP Configuration

Add to your Claude Desktop configuration file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "nocodb": {
      "command": "npx",
      "args": ["@andrewlwn77/nocodb-mcp"],
      "env": {
        "NOCODB_BASE_URL": "http://localhost:8080",
        "NOCODB_API_TOKEN": "your_api_token_here"
      }
    }
  }
}

Or if installed globally:

{
  "mcpServers": {
    "nocodb": {
      "command": "nocodb-mcp",
      "env": {
        "NOCODB_BASE_URL": "http://localhost:8080",
        "NOCODB_API_TOKEN": "your_api_token_here"
      }
    }
  }
}

Available Tools

Database Operations

• list_bases - List all available databases/projects
• get_base_info - Get detailed information about a specific base

Table Management

• list_tables - List all tables in a base
• get_table_info - Get table schema and column information
• create_table - Create a new table with custom schema
• delete_table - Delete a table
• add_column - Add a new column to an existing table
• delete_column - Delete a column from a table

Record Operations

• insert_record - Insert a single record
• bulk_insert - Insert multiple records at once
• get_record - Retrieve a specific record by ID
• list_records - List records with filtering and pagination
• update_record - Update an existing record
• delete_record - Delete a record