Lets agents read and write NocoDB database tables and records with create, read, update and delete operations.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add nocodb --env NOCODB_URL='<NOCODB_URL>' --env NOCODB_BASE_ID='<NOCODB_BASE_ID>' --env NOCODB_API_TOKEN='<NOCODB_API_TOKEN>' -- npx nocodb-mcp-server '{{config.NOCODB_URL}}' '{{config.NOCODB_BASE_ID}}' '{{config.NOCODB_API_TOKEN}}'~/.codex/config.toml
[mcp_servers.nocodb]
command = "npx"
args = ["nocodb-mcp-server", "{{config.NOCODB_URL}}", "{{config.NOCODB_BASE_ID}}", "{{config.NOCODB_API_TOKEN}}"]
env = { NOCODB_URL = "<NOCODB_URL>", NOCODB_BASE_ID = "<NOCODB_BASE_ID>", NOCODB_API_TOKEN = "<NOCODB_API_TOKEN>" }
# codex mcp add nocodb --env NOCODB_URL='<NOCODB_URL>' --env NOCODB_BASE_ID='<NOCODB_BASE_ID>' --env NOCODB_API_TOKEN='<NOCODB_API_TOKEN>' -- npx nocodb-mcp-server '{{config.NOCODB_URL}}' '{{config.NOCODB_BASE_ID}}' '{{config.NOCODB_API_TOKEN}}'~/.cursor/mcp.json
{
"mcpServers": {
"nocodb": {
"command": "npx",
"args": [
"nocodb-mcp-server",
"{{config.NOCODB_URL}}",
"{{config.NOCODB_BASE_ID}}",
"{{config.NOCODB_API_TOKEN}}"
],
"env": {
"NOCODB_URL": "<NOCODB_URL>",
"NOCODB_BASE_ID": "<NOCODB_BASE_ID>",
"NOCODB_API_TOKEN": "<NOCODB_API_TOKEN>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"nocodb": {
"type": "stdio",
"command": "npx",
"args": [
"nocodb-mcp-server",
"{{config.NOCODB_URL}}",
"{{config.NOCODB_BASE_ID}}",
"{{config.NOCODB_API_TOKEN}}"
],
"env": {
"NOCODB_URL": "<NOCODB_URL>",
"NOCODB_BASE_ID": "<NOCODB_BASE_ID>",
"NOCODB_API_TOKEN": "<NOCODB_API_TOKEN>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"nocodb": {
"command": "npx",
"args": [
"nocodb-mcp-server",
"{{config.NOCODB_URL}}",
"{{config.NOCODB_BASE_ID}}",
"{{config.NOCODB_API_TOKEN}}"
],
"env": {
"NOCODB_URL": "<NOCODB_URL>",
"NOCODB_BASE_ID": "<NOCODB_BASE_ID>",
"NOCODB_API_TOKEN": "<NOCODB_API_TOKEN>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"nocodb": {
"command": "npx",
"args": [
"nocodb-mcp-server",
"{{config.NOCODB_URL}}",
"{{config.NOCODB_BASE_ID}}",
"{{config.NOCODB_API_TOKEN}}"
],
"env": {
"NOCODB_URL": "<NOCODB_URL>",
"NOCODB_BASE_ID": "<NOCODB_BASE_ID>",
"NOCODB_API_TOKEN": "<NOCODB_API_TOKEN>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"nocodb": {
"command": "npx",
"args": [
"nocodb-mcp-server",
"{{config.NOCODB_URL}}",
"{{config.NOCODB_BASE_ID}}",
"{{config.NOCODB_API_TOKEN}}"
],
"env": {
"NOCODB_URL": "<NOCODB_URL>",
"NOCODB_BASE_ID": "<NOCODB_BASE_ID>",
"NOCODB_API_TOKEN": "<NOCODB_API_TOKEN>"
}
}
}
}Environment variables
NOCODB_URLNOCODB_BASE_IDNOCODB_API_TOKEN
Replace the placeholders with your own credentials and keep them out of version control.