M
MCP Directory CURATED DIRECTORY
911 MCP servers indexed
中文
← Back to directory
N

NocoDB MCP Server

Community
MCP server for interacting with NocoDB databases via natural language.
How to install ↓ Compare GitHub source repository ↗
Category
Database #53 of 58
Stars
★ 76 Popular
Transport
stdio (local process)
Runtime
Node.js
Credentials
API key / credential required
Last commit
⚠
Tools
9
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.

Strongest · Setup experience 12/20 Weakest · Reliability 6/20

Reliability
6/20
Security and permissions
8/20
Maintenance
8/20
Documentation
9/20
Setup experience
12/20
Why each score
Reliability 6/20
The repository contains TypeScript sources and build scripts, but no CI workflow or test suite is present. Tool list and error handling cannot be statically verified, so reliability is capped at 6.
Security and permissions 8/20
Credentials are passed via environment variables, no hardcoded secrets found in the code. Tools perform CRUD operations without explicit confirmation for destructive actions. Network access is limited to the configured NocoDB instance.
Maintenance 8/20
The repository has recent commits, one open issue, but no license file found. Maintenance is active but lacks formal governance and release strategy.
Documentation 9/20
README provides clear installation, configuration, and client integration examples, with a link to API function docs. However, troubleshooting and limitations are missing.
Setup experience 12/20
Setup steps are simple with clear build and configuration instructions, and client config examples are provided. However, no CI or tests are present, and manual build steps are required.

Static review · not runListed 2026-08-07

Read the FMRS scoring method →

Fit and risk

What it can accessUses the networkConnects to a database

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.

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.

Setup

Before you start

Runtime：Node.js

NOCODB_URL required URL of your NocoDB instance; use https://app.nocodb.com for NocoDB cloud.
NOCODB_BASE_ID required The NocoDB base ID, taken from the instance URL path (https://app.nocodb.com/#/{USERNAME}/{NOCODB_BASE_ID}/{TABLE_ID}).
NOCODB_API_TOKEN requiredsecret A NocoDB API token generated in NocoDB; treat it as a secret credential.

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"
      }
    }
  }
}

Shown for Claude Desktop. Other clients may use a different file or key (VS Code uses "servers") — the configurator below converts it.

.vscode/mcp.json
{
  "servers": {
    "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"
      }
    }
  }
}

Goes in your project's .vscode/mcp.json (VS Code uses a "servers" key).

Terminal
claude mcp add nocodb -e NOCODB_URL=https://your-nocodb-instance.com -e NOCODB_BASE_ID=your_base_id_here -e NOCODB_API_TOKEN=your_api_token_here -- node '{working_folder}/dist/start.js'

Run it in a terminal; replace any <…> placeholders with your own values first.

Generate and validate client config

Check that it works

After starting, check that tools such as get_records and create_record appear in your MCP client's tool list, then run a natural-language prompt like "get data from nocodb, table: Shinobi" to confirm records are returned.

Troubleshooting

  1. Common issues include misconfigured environment variables, unreachable NocoDB URL, or invalid API token.
  2. Verify the values in the .env file and ensure the NocoDB instance is accessible.

Things to try

Once connected, you can ask your AI assistant things like:

  • get data from nocodb, table: Shinobi
  • add new row, with name: sasuke-2
  • update all rows, remove suffix -
  • delete all rows with name naruto

Tools 9

get_records read-only
Retrieve records from a NocoDB table.
create_record writes
Create a new record in a NocoDB table.
update_record writes
Update existing records in a NocoDB table.
delete_record destructive
Delete records from a NocoDB table.
add_column writes
Add a new column to a NocoDB table.
delete_column destructive
Delete a column from a NocoDB table.
bulk_create_records writes
Bulk create records in a NocoDB table.
bulk_delete_records destructive
Bulk delete records from a NocoDB table.
Show 1 more tools
create_table_from_json
Create a new table in NocoDB based on JSON data.

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 Desktop

Listed from the project's documentation, not tested by this site.

Overview

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.

Similar servers

Compare with other MCP servers

Source revision adccc50804c7 Data synced 2026-10-19 Read the FMRS scoring method