NocoDB
📇 ☁️ - Nocodb database integration, read and write capabilities
What is NocoDB?
NocoDB is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to 📇 ☁️ - nocodb database integration, read and write capabilities
📇 ☁️ - Nocodb database integration, read and write capabilities
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- 📇 ☁️ - Nocodb database integration, read and write capabilit
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx nocodbConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use NocoDB
The NocoDB MCP server integrates Claude and other AI assistants with NocoDB — an open-source Airtable alternative that turns any database into a collaborative spreadsheet interface. Through this server, AI agents can perform full CRUD operations (create, read, update, delete) on NocoDB tables using natural language, including bulk operations and JSON file imports. It is useful for teams who manage structured data in NocoDB and want to automate data entry, reporting, or manipulation tasks directly through their AI assistant without writing API calls manually.
Prerequisites
- Node.js 16+ and npm for building the server from source
- A running NocoDB instance — either self-hosted or at app.nocodb.com
- A NocoDB API token from your account settings
- Your NocoDB Base ID, found in the URL of your NocoDB base
- An MCP-compatible client such as Claude Desktop
Clone the repository and build
Clone the nocodb-mcp-server repository and compile the TypeScript source. This generates the runnable dist/start.js file.
git clone https://github.com/edwinbernadus/nocodb-mcp-server.git
cd nocodb-mcp-server
npm install
npm run buildGather your NocoDB credentials
You need three values: your NocoDB instance URL, your Base ID, and your API token. The Base ID appears in your browser URL when viewing a base (the segment after your username). Generate a token in NocoDB under Team & Settings > API Tokens.
# Example NocoDB URL structure:
# https://app.nocodb.com/#/your-team/BASE_ID/TABLE_ID
# The BASE_ID is the segment between your team and table.Configure your MCP client
Add the NocoDB server to your Claude Desktop configuration using the three required environment variables. Adjust the path to dist/start.js to match your cloned directory.
{
"mcpServers": {
"nocodb": {
"command": "node",
"args": ["/path/to/nocodb-mcp-server/dist/start.js"],
"env": {
"NOCODB_URL": "https://app.nocodb.com",
"NOCODB_BASE_ID": "your_base_id_here",
"NOCODB_API_TOKEN": "your_api_token_here"
}
}
}
}Alternatively, run via npx with inline arguments
The server can also be invoked with arguments passed directly on the command line, avoiding the need to set environment variables in the config.
npx -y nocodb-mcp-server https://app.nocodb.com YOUR_BASE_ID YOUR_API_TOKENRestart your client and test the connection
Restart Claude Desktop after saving the configuration. Then ask Claude to list tables or retrieve data from a known table name to verify the connection is working.
NocoDB Examples
Client configuration
Full Claude Desktop configuration for the NocoDB MCP server with the three required credentials.
{
"mcpServers": {
"nocodb": {
"command": "node",
"args": ["/Users/yourname/nocodb-mcp-server/dist/start.js"],
"env": {
"NOCODB_URL": "https://app.nocodb.com",
"NOCODB_BASE_ID": "p_abc123xyz",
"NOCODB_API_TOKEN": "xc-token-your-token-here"
}
}
}
}Prompts to try
Natural language commands you can use with Claude once the NocoDB MCP server is connected.
- "Get all data from NocoDB table: Customers"
- "Add a new row to the Shinobi table with name: sasuke-2 and age: 17"
- "Update all rows in the Products table where category is 'Electronics', set stock to 0"
- "Delete all rows in the Orders table where status is 'Cancelled'"
- "Import this JSON data into a new table called ImportedData"Troubleshooting NocoDB
Authentication error when connecting to NocoDB
Verify your NOCODB_API_TOKEN is a valid token from NocoDB's Team & Settings > API Tokens page. Tokens start with `xc-` for NocoDB Cloud. Ensure there are no extra spaces in the environment variable value.
Base ID not found or incorrect
Open your NocoDB base in a browser. The Base ID is visible in the URL after your workspace name and before the table name. It typically looks like `p_abc123xyz`. Copy it exactly without any trailing slashes.
Server builds but Claude cannot find the MCP tools
Confirm the path in `args` points to `dist/start.js` (not `dist/index.js`). After editing the config, fully quit and relaunch Claude Desktop — a simple window close may not restart the MCP subprocess.
Frequently Asked Questions about NocoDB
What is NocoDB?
NocoDB is a Model Context Protocol (MCP) server that 📇 ☁️ - nocodb database integration, read and write capabilities It connects AI assistants to external tools and data sources through a standardized interface.
How do I install NocoDB?
Follow the installation instructions on the NocoDB GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with NocoDB?
NocoDB works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is NocoDB free to use?
Yes, NocoDB is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
NocoDB Alternatives — Similar Databases Servers
Looking for alternatives to NocoDB? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up NocoDB in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use NocoDB?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.