Nocodb MCP Server
About
# Nocodb MCP Server This MCP server provides tools to interact with a Nocodb database through the Model Context Protocol, offering CRUD operations (Create, Read, Update, Delete) for Nocodb tables. ## Installation 1. Install the required dependencies: ```bash pip install -r requirements.txt ``` 2. Make sure you have…
Explore
- Five tools: retrieve_records, create_records, update_records, delete_records, get_schema
- Supports filtering, pagination, and sorting for record retrieval
- Bulk creation, update, and deletion of records
- Automatic table ID resolution from table names
- Uses Nocodb v2 REST API with xc-token authentication
- Structured error handling and logging for debugging
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Nocodb MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
1. Install the required dependencies:
``bash`
pip install -r requirements.txt
2. Make sure you have the MCP Python SDK installed (it should be installed with the dependencies above):
bash
pip install "mcp[cli]"
mcp install nocodb_mcp_server.py
mcp install nocodb_mcp_server.py -v NOCODB_URL=https://your-nocodb-instance.com -v NOCODB_API_TOKEN=your_token -v NOCODB_BASE_ID=your_base_id
bash
pip install -r requirements.txt
Authentication is handled via the xc-token header, which is automatically populated using the NOCODB_API_TOKEN` environment variable. This is the authentication mechanism required by the Nocodb v2 API.
nocodb-get-records
Nocodb - Get Recordshint: 1. Get all records from a table (limited to 10): retrieve_records(table_name="customers") 3. Filter records with conditions: retrieve_records( table_name="customers", filters="(age,gt,30)~and(status,eq,active)" ) 4. Paginate results: retrieve_records(table_name="customers", limit=20, offset=40) 5. Sort results: retrieve_records(table_name="customers", sort="-created_at") 6. Select specific fields: retrieve_records(table_name="customers", fields="id,name,email")
nocodb-get-list-tables
Nocodb - Get List Tables notes: only show result from output to user
nocodb-post-records
Nocodb - Post Records
nocodb-post-records-bulk
Nocodb - Post Records Multiple Records
nocodb-patch-records
Nocodb - Patch Records
nocodb-delete-records
Nocodb - Delete Records
nocodb-delete-records-bulk
Nocodb - Delete Records Multiple Records
nocodb-get-table-metadata
Nocodb - Get Table Metadata
nocodb-alter-table-add-column
Nocodb - Alter Table Add Column
nocodb-alter-table-remove-column
Nocodb - Alter Table Remove Column get columnId from getTableMetadata notes: remove column by columnId example: c7uo2ruwc053a3a [WARNING] this action is irreversible [RECOMMENDATION] give warning to user
nocodb-create-table
Nocodb - Create Table
The server provides the following tools:
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"nocodb mcp server": {
"Nocodb-MCP-Server": {
"command": "python",
"args": [
"nocodb_mcp_server.py"
]
}
}
}
}McpServers
{
"Nocodb-MCP-Server": {
"command": "python",
"args": [
"nocodb_mcp_server.py"
]
}
}Installation
1. Install the required dependencies: ``bash
pip install -r requirements.txt
`
2. Make sure you have the MCP Python SDK installed (it should be installed with the dependencies above):
`bash
pip install "mcp[cli]"
`
Configuration
This MCP server requires three environment variables:
- NOCODB_URL: The base URL of your Nocodb instance (e.g., https://example.com/ncdb)
- NOCODB_API_TOKEN: The API token for authentication with Nocodb
- NOCODB_BASE_ID: The base ID of your Nocodb database
You can obtain an API token from your Nocodb instance by:
1. Login to your Nocodb instance
2. Go to Account settings > API Tokens
3. Create a new token with appropriate permissions
The base ID can be found in the URL of your Nocodb dashboard: https://your-nocodb.com/dashboard/#/nc/base/YOUR_BASE_ID/table/...
Usage
With Claude Desktop
To integrate with Claude Desktop, add this configuration to claude_desktop_config.json:
`json
{
"mcpServers": {
"nocodb": {
"command": "python",
"args": [
"path/to/nocodb_mcp_server.py"
],
"env": {
"NOCODB_URL": "https://your-nocodb-instance.com",
"NOCODB_API_TOKEN": "your_api_token_here",
"NOCODB_BASE_ID": "your_base_id_here"
}
}
}
}
`
Or use the MCP CLI to install (recommended):
``bashSign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
