MCP.so
Sign In

Nocodb MCP Server

@edwinbernadus

Repository

About Nocodb MCP Server

nocodb mcp server

#mcp#nocodb#mcp-server

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

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

Overview

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

FAQ from Nocodb MCP Server

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.

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.

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.

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

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.

Frequently asked questions

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.

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.

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.

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}`.

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.

Comments

Basic information

Category

Other

Transports

stdio

Author

edwinbernadus

More Other MCP servers

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Mcp

browsermcp

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K