NocoDB MCP Server
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@NocoDB MCP Serverlist all tables in the CRM base"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
NocoDB MCP Server
A standalone Model Context Protocol (MCP) server that provides full integration with a self-hosted NocoDB instance. This server exposes NocoDB's Meta API and Data API as MCP tools, enabling LLMs like Claude to create, update, and delete bases, tables, connections, fields, views, and records.
Features
25 MCP tools covering the full NocoDB API surface:
Category | Tools |
Bases | list, get, create, update, delete |
Sources | list, create, update, delete |
Tables | list, get, create, update, delete |
Fields | list, create, update, delete |
Views | list, create, update, delete |
Records | list (with filtering/sorting), create, update, delete |
Related MCP server: MCP Server NocoBase Remote
Prerequisites
Node.js 18+ (for native
fetch)A running NocoDB instance
A NocoDB API token (generate from Team & Settings > Tokens)
Setup
# Install dependencies
npm install
# Build
npm run build
# Run (for testing)
NOCODB_URL=http://localhost:8080 NOCODB_API_TOKEN=your-token npm startClaude Desktop Configuration
Add this to your claude_desktop_config.json:
{
"mcpServers": {
"nocodb": {
"command": "node",
"args": ["/Users/youruser/Local Apps/nocodb-mcp-server/dist/index.js"],
"env": {
"NOCODB_URL": "http://localhost:8080",
"NOCODB_API_TOKEN": "your-api-token-here"
}
}
}
}Development
# Run in dev mode (no build step needed)
NOCODB_URL=http://localhost:8080 NOCODB_API_TOKEN=your-token npm run devArchitecture
Zero NocoDB forking — communicates entirely via REST API
Safe for NocoDB updates — upgrade NocoDB independently
stdio transport — compatible with Claude Desktop and other MCP clients
Related MCP Connectors
Nifty's MCP server — exposes tasks, projects, messages, and files as tools for AI agents.
Zero-setup MCP gateway securely connecting AI to your tools with authentication and workflows
The OpenRouter for tools. One MCP connection gives any AI agent 254 hosted tools, pay per call.
Self-hosted AI prompt library: prompts, collections, tags, teams, chains. 29 MCP tools for agents.
Related MCP Servers
- AlicenseBqualityDmaintenanceEnables AI agents to interact with NocoDB databases for managing tables, records, views, and file attachments. Supports advanced queries, bulk operations, and full CRUD functionality for storing operational data.2522 npm5MIT
- FlicenseNot gradedqualityDmaintenanceRemote MCP server that auto-generates tools from NocoBase OpenAPI specs to enable full CRUD operations on collections across multiple instances. Supports streamable HTTP transport and API key authentication for secure, natural language interaction with NocoBase deployments.-
- AlicenseAqualityCmaintenanceAn MCP server that enables AI assistants to interact with NocoBase instances for managing collections, UI schemas, flow models, and running API operations. It provides both hand-crafted tools and dynamically generated tools from NocoBase's OpenAPI specification.236 npmMIT
- AlicenseNot gradedqualityFmaintenanceEnables CRUD operations on NocoDB tables via natural language commands, supporting table manipulation, file upload, and bulk actions.72 npm76MIT