A TypeScript MCP server that provides convenient interaction with NocoDB databases through natural language commands, offering CRUD operations for tables and file uploads.

Installation

From Source

npm install
npm run build

Direct NPX Invocation

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

Configuration

Claude Desktop

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

Features

• CRUD operations with NocoDB tables through natural language commands
• File uploads to create tables from JSON data
• Bulk record creation and deletion
• Dynamic column addition and removal
• Record updates using natural language commands
• TypeScript implementation for improved maintainability

Environment Variables

Required

• NOCODB_URL - URL of your NocoDB instance
• NOCODB_API_TOKEN - Your NocoDB API token for authentication
• NOCODB_BASE_ID - ID of your NocoDB database (found in the URL)

Usage Examples

get data from nocodb, table: Shinobi

add new row, with name: sasuke-2

update all rows, remove suffix -

delete all rows with name naruto

add column with name: Age

Notes

This is a fork of the original NocoDB-MCP-Server in TypeScript with improved maintainability. For detailed information on API functions, refer to API_FUNCTION.md. NOCODB_BASE_ID can be found in your NocoDB URL in the following format: https://app.nocodb.com/#{USERNAME}/{NOCODB_BASE_ID}/{TABLE_ID}. Use https://app.nocodb.com as your NOCODB_URL if you are using the NocoDB cloud version.