Nocodb

This MCP server exposes a set of tools to interact with a Nocodb database using the Model Context Protocol. It provides CRUD operations for Nocodb tables, including retrieving records, creating new records, updating existing ones, deleting records, and querying table schemas. The available tools are retrieve_records, create_records, update_records, delete_records, and get_schema. To use these tools, configure an MCP client (such as Claude Desktop, MCP CLI, or a Cursor-compatible client) to launch the nocodb_mcp_server.py process with the required environment variables (NOCODB_URL, NOCODB_API_TOKEN, and NOCODB_BASE_ID). Once running, you can issue Python-like calls through the MCP interface to perform operations against your Nocodb instance, with responses including error information when applicable.

Prerequisites:

• Python 3.8+ installed on your system
• Access to install Python packages
• A Nocodb instance with an API token

Step-by-step installation:

1. Install Python dependencies from the project:

pip install -r requirements.txt

2. Install the MCP Python SDK (if not already installed with dependencies):

pip install "mcp[cli]"

3. Ensure you have a configured environment for Nocodb (NOCODB_URL, NOCODB_API_TOKEN, NOCODB_BASE_ID) before running the server.

4. Run the MCP server directly (standalone) once dependencies are installed:

python nocodb_mcp_server.py

5. Or use the MCP CLI to run the server via an installed module:

mcp run nocodb_mcp_server.py

Tips and notes:

• Environment variables NOCODB_URL, NOCODB_API_TOKEN, and NOCODB_BASE_ID are required for authentication and proper operation with the Nocodb v2 REST API.
• Authentication uses the xc-token header, populated from NOCODB_API_TOKEN.
• The server uses v2 API endpoints like /api/v2/tables/{tableId}/records and /api/v2/meta/tables/{tableId} for CRUD and schema operations.
• Logging is set to ERROR by default in nocodb_mcp_server.py to reduce noise; adjust logging level if you need more verbose output during development.
• Ensure you provide correct NOCODB_BASE_ID to avoid base-id resolution issues; the base ID can usually be found in the Nocodb URL or via API responses when querying metadata.
• For MCP CLI installation, you can pass environment variables via -v KEY=VALUE or via an .env file with -f .env in the mcp install step.
• If you run into authentication errors, verify that the API token has sufficient permissions for the base and resources you are accessing.