Best for
- Developers who want to interact with NocoDB using natural language.
- Users needing quick CRUD operations on NocoDB tables.
- Scenarios integrating with AI assistants via MCP.
N
NocoDB MCP Server
Community
MCP server for interacting with NocoDB databases via natural language.
GitHub source repository ↗
43FMRS · D
This server provides a straightforward integration of NocoDB with MCP, supporting CRUD and bulk operations, but as a community fork, its stability and security should be evaluated by the user.
The NocoDB MCP Server enables seamless interaction with NocoDB databases using the Model Context Protocol (MCP). It allows performing CRUD operations (Create, Read, Update, Delete) on NocoDB tables through natural language commands. It also supports adding/deleting columns, bulk operations, and creating tables from JSON files. This TypeScript-based fork of Nocodb-MCP-Server focuses on maintainability and modern TypeScript practices.
Tools
get_records
Retrieve records from a NocoDB table.
create_record
Create a new record in a NocoDB table.
update_record
Update existing records in a NocoDB table.
delete_record
Delete records from a NocoDB table.
add_column
Add a new column to a NocoDB table.
delete_column
Delete a column from a NocoDB table.
bulk_create_records
Bulk create records in a NocoDB table.
bulk_delete_records
Bulk delete records from a NocoDB table.
create_table_from_json
Create a new table in NocoDB based on JSON data.
Setup
Ensure Node.js and TypeScript are installed, then run npm install and npm run build in the project root. Configure the .env file with NOCODB_URL, NOCODB_API_TOKEN, and NOCODB_BASE_ID. For Claude Desktop, edit claude_desktop_config.json to add the mcpServers configuration.
claude_desktop_config.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"
}
}
}
}
Fit and risk
Not for
- Not suitable for databases other than NocoDB.
- Not ideal for complex transactional or advanced query requirements.
- Not recommended for production environments with high security needs, as this fork is not officially maintained.
Required permissions
- Requires NocoDB instance URL, API token, and Base ID.
- Uses NocoDB API, requiring appropriate read/write permissions.
Risks and side effects
- API tokens may be exposed; store them securely.
- Third-party fork may not be security audited.
- Misuse could lead to permanent data deletion or overwrite.
Troubleshooting
- Common issues include misconfigured environment variables, unreachable NocoDB URL, or invalid API token.
- Verify the values in the .env file and ensure the NocoDB instance is accessible.
Use cases
Query and manipulate NocoDB data using natural language.
Automate data entry, e.g., creating tables from JSON files.
Bulk update or delete records for easier data maintenance.
Supported clients
Claude DesktopFull support