Nocodb MCP Server
by granthooks
This MCP server provides tools to interact with a Nocodb database through the Model Context Protocol. It offers CRUD operations for Nocodb tables, enabling seamless data management.
Last updated: N/A
What is Nocodb MCP Server?
The Nocodb MCP Server is a tool that allows you to interact with a Nocodb database using the Model Context Protocol (MCP). It provides a set of functions to perform Create, Read, Update, and Delete (CRUD) operations on Nocodb tables, making it easier to manage and access your data.
How to use Nocodb MCP Server?
To use the Nocodb MCP Server, you need to install the required dependencies, configure the server with your Nocodb URL, API token, and base ID, and then integrate it with tools like Claude Desktop or Cursor, or run it as a standalone server using the MCP CLI. The server provides tools like retrieve_records, create_records, update_records, delete_records, and get_schema to interact with Nocodb tables.
Key features of Nocodb MCP Server
CRUD operations (Create, Read, Update, Delete) for Nocodb tables
Integration with Claude Desktop and Cursor
Standalone server execution via MCP CLI
Schema retrieval for Nocodb tables
Comprehensive error handling and logging
Use cases of Nocodb MCP Server
Automating data management tasks in Nocodb
Integrating Nocodb with AI tools like Claude Desktop
Building custom applications that interact with Nocodb
Retrieving and manipulating data from Nocodb tables programmatically
FAQ from Nocodb MCP Server
How do I get the NOCODB_URL?
How do I get the NOCODB_URL?
The NOCODB_URL is the base URL of your Nocodb instance (e.g., https://example.com/ncdb).
Where do I find the NOCODB_API_TOKEN?
Where do I find the NOCODB_API_TOKEN?
You can obtain an API token from your Nocodb instance by logging in, going to Account settings > API Tokens, and creating a new token with appropriate permissions.
How do I find the NOCODB_BASE_ID?
How do I find the NOCODB_BASE_ID?
The base ID can be found in the URL of your Nocodb dashboard: https://your-nocodb.com/dashboard/#/nc/base/YOUR_BASE_ID/table/...
What are the security considerations when using this server?
What are the security considerations when using this server?
Use dedicated API tokens with minimal privileges, never share API tokens, restrict database access, enable logging and auditing, regularly review and rotate API tokens, and store environment variables securely.
How do I run the server in development mode?
How do I run the server in development mode?
Use the command mcp dev nocodb_mcp_server.py for testing and debugging with the MCP Inspector.