Advertise
MCP.so
Sign In

Nocodb MCP Server

@edwinbernadus

Repository

Basic information

Category

Other

Transports

stdio

Author

edwinbernadus

About Nocodb MCP Server

nocodb mcp server

#mcp#nocodb#mcp-server

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

Nocodb MCP Server 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

Frequently asked questions

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.

Comments

More Other MCP servers

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K
Advertise