MCP.so
ログイン

Nocodb MCP Server

@edwinbernadus

基本情報

カテゴリ

その他

トランスポート

stdio

作者

edwinbernadus

Nocodb MCP Server について

nocodb mcp server

Nocodb MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "nocodb-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "nocodb-mcp-server",
        "{NOCODB_URL}",
        "{NOCODB_BASE_ID}",
        "{NOCODB_API_TOKEN}"
      ]
    }
  }
}

Nocodb MCP Server のツール

11

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 notes: only show result from output to user

Nocodb - Post Records

Nocodb - Post Records Multiple Records

Nocodb - Patch Records

Nocodb - Delete Records

Nocodb - Delete Records Multiple Records

Nocodb - Get Table Metadata

Nocodb - Alter Table Add 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

概要

What is Nocodb MCP Server?

The Nocodb MCP Server enables seamless interaction with your NocoDB database using the Model Context Protocol (MCP). It allows you to perform CRUD (Create, Read, Update, Delete) operations on NocoDB tables through natural language commands.

How to use Nocodb MCP Server?

Install dependencies with npm install, build with npm run build, then configure environment variables NOCODB_URL, NOCODB_API_TOKEN, and NOCODB_BASE_ID. You can integrate it with Claude Desktop via claude_desktop_config.json or call it directly from the CLI with npx -y nocodb-mcp-server {NOCODB_URL} {NOCODB_BASE_ID} {NOCODB_API_TOKEN}.

Key features of Nocodb MCP Server

  • Perform CRUD operations on NocoDB tables via natural language
  • Add, update, and delete columns and rows
  • Upload files to create tables automatically
  • Bulk create and delete records
  • Supports direct CLI invocation and Claude Desktop integration

Use cases of Nocodb MCP Server

  • Query and manage NocoDB data using natural language in AI assistants
  • Automate table creation from JSON files
  • Bulk update or delete records based on conditions
  • Add or remove columns through conversational commands

よくある質問

1

What does the Nocodb MCP Server do?

It acts as a bridge between MCP-compatible clients (like Claude Desktop) and a NocoDB database, allowing you to create, read, update, and delete records and columns using natural language commands.

2

How do I configure the Nocodb MCP Server?

Set the required environment variables `NOCODB_URL`, `NOCODB_API_TOKEN`, and `NOCODB_BASE_ID` in a `.env` file or pass them as command-line arguments when running the server.

3

How can I find my NOCODB_BASE_ID?

Look at your NocoDB instance URL: `https://app.nocodb.com/#/{USERNAME}/{NOCODB_BASE_ID}/{TABLE_ID}`. The base ID is the segment between the username and the table ID.

4

Can I use the Nocodb MCP Server from the command line?

Yes, you can call it directly with `npx -y nocodb-mcp-server {NOCODB_URL} {NOCODB_BASE_ID} {NOCODB_API_TOKEN}`.

5

What integrations are supported?

The server can be integrated with Claude Desktop by adding its configuration to `claude_desktop_config.json`. A hosted deployment is also available on Fronteir AI.

コメント

「その他」の他のコンテンツ