by edwinbernadus
Enables seamless interaction with NocoDB databases using natural language commands to perform CRUD operations, column management, bulk actions, and file‑based table creation.
Provides a Model Context Protocol (MCP) server that translates natural‑language prompts into NocoDB API calls, allowing users to create, read, update, delete records, manage columns, and handle bulk operations without writing code.
npm install && npm run build (or use the pre‑built package via npx)..env file with NOCODB_URL, NOCODB_API_TOKEN and NOCODB_BASE_ID.npx -y nocodb-mcp-server $NOCODB_URL $NOCODB_BASE_ID $NOCODB_API_TOKEN
claude_desktop_config.json or invoke it from any MCP‑compatible client.Q: Do I need a NocoDB Cloud account? A: No, any self‑hosted or cloud instance works; just provide the correct URL and API token.
Q: Which environment variables are required?
A: NOCODB_URL, NOCODB_API_TOKEN, and NOCODB_BASE_ID.
Q: Can I use the server without TypeScript knowledge?
A: Yes, the compiled JavaScript in dist/ can be run directly via npx.
Q: How is authentication handled? A: The server forwards the provided API token to NocoDB for all requests.
Q: Is the project open‑source? A: Yes, it is licensed under the MIT License and accepts contributions via GitHub.
The NocoDB MCP Server enables seamless interaction with your NocoDB database using the Model Context Protocol (MCP). This server makes it easy to perform CRUD (Create, Read, Update, Delete) operations on NocoDB tables through natural language commands.
[Get Records]
get data from nocodb, table: Shinobi
[Create Record]
add new row, with name: sasuke-2
add other row, with name: naruto-2
[Update Record]
update all rows, remove suffix -
[Delete Record]
delete all rows with name naruto
[Add Column]
add column with name: Age
update all rows, set Age to 18
[Delete Column]
delete column with name: Age
[Create table]
from the json files
put on nocodb database
table name is TableShinobi
JSON location file in: example_upload.json

This repository is a TypeScript-based fork of NocoDB-MCP-Server. It retains the core functionality while improving maintainability and compatibility with modern TypeScript development practices.
Ensure that Node.js and TypeScript are installed, then execute:
npm install
npm run build
Define the required environment variables in a .env file:
NOCODB_URL=https://your-nocodb-instance.com
NOCODB_API_TOKEN=your_api_token_here
NOCODB_BASE_ID=your_base_id_here
Tip: You can copy the template from env.example and fill in your values.
To find your NOCODB_BASE_ID, check the URL of your Nocodb instance.
For example:
https://app.nocodb.com/#/wi6evls6/pqmob3ammcknma5/maty9c5xkmf4012
In this URL format:
https://app.nocodb.com/#/{USERNAME}/{NOCODB_BASE_ID}/{TABLE_ID}
Modify claude_desktop_config.json to include:
{
"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"
}
}
}
}
You can directly call the MCP server from the command line:
NOCODB_URL, NOCODB_API_TOKEN, and NOCODB_BASE_ID are required parameters.
NOCODB_URL=https://app.nocodb.com if you are using NocoDB cloud.
npx -y nocodb-mcp-server {NOCODB_URL} {NOCODB_BASE_ID} {NOCODB_API_TOKEN}
To run the tests, execute:
npx -y @wong2/mcp-cli npx nocodb-mcp-server {NOCODB_URL} {NOCODB_BASE_ID} {NOCODB_API_TOKEN}
For detailed information about available API functions, please refer to API_FUNCTION.md.
/project-root
├── src/ # TypeScript source files
├── dist/ # Compiled JavaScript output
├── .env # Environment variable configurations
├── package.json # Project dependencies and scripts
├── tsconfig.json # TypeScript settings
Contributions are encouraged! Feel free to open issues or submit pull requests.
This project is distributed under MIT.
Please log in to share your review and rating for this MCP.
{
"mcpServers": {
"nocodb": {
"command": "npx",
"args": [
"-y",
"nocodb-mcp-server"
],
"env": {
"NOCODB_URL": "<YOUR_NOCODB_URL>",
"NOCODB_BASE_ID": "<YOUR_BASE_ID>",
"NOCODB_API_TOKEN": "<YOUR_API_TOKEN>"
}
}
}
}claude mcp add nocodb npx -y nocodb-mcp-serverExplore related MCPs that share similar capabilities and solve comparable challenges
by googleapis
An MCP server that streamlines database tool development by handling connection pooling, authentication, observability, and secure access, allowing agents to interact with databases via natural language.
by bytebase
Provides a universal gateway that lets MCP‑compatible clients explore and query MySQL, PostgreSQL, SQL Server, MariaDB, and SQLite databases through a single standardized interface.
by designcomputer
Enables secure interaction with MySQL databases via the Model Context Protocol, allowing AI applications to list tables, read contents, and execute queries safely.
by benborla
Provides read‑only access to MySQL databases for large language models, allowing schema inspection and safe execution of SQL queries.
by neo4j-contrib
Enables natural‑language interaction with Neo4j databases, allowing large language models to query, modify, and manage graph data through multiple transport modes.
by mongodb-js
Provides a Model Context Protocol server that enables interaction with MongoDB databases and MongoDB Atlas clusters through a unified API.
by ClickHouse
Enables AI assistants to run read‑only ClickHouse queries, list databases and tables, and execute embedded chDB queries through an MCP interface.
by neondatabase
Interact with Neon Postgres databases using natural language commands through the Model Context Protocol, enabling conversational database creation, migration, and query execution.
by motherduckdb
Enables SQL analytics on DuckDB and MotherDuck databases via a Model Context Protocol server, allowing AI assistants and IDEs to query data directly.