nocodb-mcp-server

Overview

The NocoDB MCP Server provides a seamless interface for interacting with NocoDB databases using the Model Context Protocol. It allows users to perform comprehensive database operations including creating, reading, updating, and deleting records, as well as managing table structures through natural language prompts. The server supports bulk operations and file uploads, making it suitable for managing database contents efficiently.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• get_records

  Retrieve data from a NocoDB table

  Try:Get data from nocodb, table: Shinobi
• create_record

  Create a new record in a NocoDB table

  Try:add new row, with name: sasuke-2
• update_record

  Update existing records in a NocoDB table

  Try:update all rows, remove suffix -
• delete_record

  Delete records from a NocoDB table

  Try:delete all rows with name naruto
• add_column

  Add a new column to a NocoDB table

  Try:add column with name: Age
• delete_column

  Delete a column from a NocoDB table

  Try:delete column with name: Age
• create_table

  Create a new table in NocoDB from JSON files

  Try:from the json files, put on nocodb database, table name is TableShinobi
• bulk_create_records

  Create multiple records in a NocoDB table at once

  Try:Create bulk records in the Shinobi table
• bulk_delete_records

  Delete multiple records in a NocoDB table at once

  Try:Delete bulk records from the Shinobi table

Note: Tool names were inferred from example prompts in the README, as there wasn't a dedicated 'Tools' section with formal definitions. The actual tool names might differ from the action phrases used in examples.

Comparable tools

Installation

npm install
npm run build

NOCODB_URL=https://your-nocodb-instance.com
NOCODB_API_TOKEN=your_api_token_here
NOCODB_BASE_ID=your_base_id_here

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

npx -y nocodb-mcp-server {NOCODB_URL} {NOCODB_BASE_ID} {NOCODB_API_TOKEN}

FAQ

How do I find my NOCODB_BASE_ID?

Check the URL of your Nocodb instance. It follows the format: https://app.nocodb.com/#/{USERNAME}/{NOCODB_BASE_ID}/{TABLE_ID}

Can I use this server with the cloud version of NocoDB?

Yes, use NOCODB_URL=https://app.nocodb.com for the cloud version.

Compare nocodb-mcp-server with