MCP Server

The Model Context Protocol (MCP) Server lets you connect NocoDB with LLMs that support MCP, such as Claude, Cursor, or Windsurf. With this integration, LLMs can interact directly with your NocoDB workspace to create, query, update, and manage records.

Each MCP endpoint in NocoDB provides a secure URL that can be linked to an MCP-compatible client. Once configured, the LLM can execute database operations in your workspace through natural language prompts.

MCP server exposes standard CRUD operations. These can be triggered conversationally, without writing SQL or scripts.

Server Configuration (NocoDB)

1. Click on the Overview button in the left sidebar.
2. Select the Settings tab.
3. Select the Model Context Protocol
4. Click on the New MCP Endpoint to create a new MCP config JSON for your base.
5. Provide a name for the MCP endpoint
6. Click Create to generate the MCP Config JSON.
7. Copy the generated JSON configuration. This will be used in your LLM client configuration.

Client Configuration

Claude

1. Open Claude Desktop Preferences (⌘+,).
2. Under Develop, click Edit Config.
3. Insert the JSON block copied here as claude_desktop_config.json.
4. Save the file and restart Claude Desktop.

Cursor

1. Go to Cursor Settings (⇧+⌘+J).
2. Open the MCP tab and select Add Custom MCP.
3. Paste the JSON block copied here. Save.

Windsurf

1. Open Windsurf Settings (⌘+,).
2. In the Cascade section > Plugins (MCP Server) > Click Manage Plugins
3. Paste the JSON block copied here. Save.

JSON Example

{
  "mcpServers": {
    "NocoDB MCP": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://your-domain.com/mcp/<ncId>",
        "--header",
        "xc-mcp-token: <ncToken>"
      ]
    }
  }
}