NocoDB

NocoDB is an MCP server that connects Model Context Protocol clients directly to self-hosted or cloud NocoDB database instances. Built in TypeScript as an open-source tool, it is designed for developers, data managers, and operational teams who want to interact with their relational databases using natural language commands. The server enables clients like Claude Desktop to execute full CRUD operations, such as creating, reading, updating, and deleting individual or bulk records in NocoDB tables. Beyond record management, it allows users to modify table structures dynamically by adding or removing columns and creating new tables directly from JSON data sources. By exposing NocoDB REST API functions to LLM interfaces, it removes the need to manually access the web dashboard for everyday spreadsheet and database modifications.

Category: CRM, ERP & E-commerce

Tags: airtable-alternative, database, data-management, nocodb, spreadsheet

Visit NocoDB

How to install and configure NocoDB

1. Clone the repository and install dependencies using npm install, then compile the TypeScript code with npm run build. 2. Locate your NocoDB Base ID from your instance URL (https://app.nocodb.com/#/{USERNAME}/{NOCODB_BASE_ID}/{TABLE_ID}) and obtain your API token. 3. Add the server configuration to your claude_desktop_config.json file: json { "mcpServers": { "nocodb": { "command": "node", "args": ["{working_folder}/dist/start.js"], "env": { "NOCODB_URL": "https://your-nocodb-instance.com", "NOCODB_BASE_ID": "your_base_id_here", "NOCODB_API_TOKEN": "your_api_token_here" } } } } 4. Alternatively, run the server directly via CLI using npx -y nocodb-mcp-server {NOCODB_URL} {NOCODB_BASE_ID} {NOCODB_API_TOKEN}.

What you can do with NocoDB

• Fetching and filtering table rows from a specified NocoDB database using conversational prompts inside Claude Desktop. - Adding new records or executing bulk data insertions across database tables without opening the web interface. - Performing mass updates or deletions on specific row entries matching designated field values or criteria. - Modifying database schemas dynamically by adding or deleting specific columns across existing NocoDB tables. - Generating and populating new NocoDB tables directly from local JSON file structures through automated prompts.

Key facts

• Open Source
• https://github.com/edwinbernadus/nocodb-mcp-server
• CRM, ERP & E-commerce, Databases & Data Stores
• airtable-alternative, database, data-management, nocodb, spreadsheet

Part of MCP Servers

How do I install NocoDB MCP server?

You can install it locally by running npm install and npm run build in the cloned repository, or invoke it directly using npx -y nocodb-mcp-server with your NocoDB URL, Base ID, and API token arguments.

What can NocoDB MCP server do?

The server enables natural language CRUD operations on NocoDB tables. You can retrieve records, insert new rows, update values, perform bulk deletions, manage schema columns, and generate new tables from JSON data.

Which MCP clients work with NocoDB?

It integrates with Claude Desktop through the claude_desktop_config.json file. It can also be tested and used with CLI clients such as @wong2/mcp-cli or any standard MCP-compliant client interface.

Where do I find my NOCODB_BASE_ID?

You can find your NOCODB_BASE_ID in your NocoDB web browser URL. In the standard link structure, it appears immediately after your username and before the table ID identifier.

Is NocoDB MCP server open source?

Yes, this MCP server is an open-source project distributed under the MIT license, and the source code is publicly available on GitHub.