Frequently Asked Questions about Nocodb MCP Server

Q: What is the Nocodb MCP Server? A: The Nocodb MCP Server enables seamless interaction between AI agents and a Nocodb database using the Model Context Protocol (MCP). It facilitates CRUD (Create, Read, Update, Delete) operations on Nocodb tables.

Q: What is MCP (Model Context Protocol)? A: MCP is an open protocol that standardizes how applications provide context to Large Language Models (LLMs), allowing AI models to understand and interact with diverse data sources and tools.

Q: How do I set up the Nocodb MCP Server? A: Ensure Node.js and TypeScript are installed, then execute npm install and npm run build. Define the required environment variables (NOCODB_URL, NOCODB_API_TOKEN, NOCODB_BASE_ID) in a .env file.

Q: How do I find my NOCODB_BASE_ID? A: Check the URL of your Nocodb instance. For example, in https://app.nocodb.com/#/{USERNAME}/{NOCODB_BASE_ID}/{TABLE_ID}, the NOCODB_BASE_ID is the alphanumeric string after the username.

Q: Can I integrate the Nocodb MCP Server with Claude Desktop? A: Yes, modify claude_desktop_config.json to include the server’s command, arguments, and environment variables, as shown in the documentation.

Q: How can I call the MCP server directly from the command line? A: Use the command: npx -y nocodb-mcp-server {NOCODB_URL} {NOCODB_BASE_ID} {NOCODB_API_TOKEN}. Ensure NOCODB_URL, NOCODB_API_TOKEN, and NOCODB_BASE_ID are provided.

Q: What kind of API functions does the Nocodb MCP Server support? A: Read the API_FUNCTION.md file in the repository for a detailed list of supported API functions.

Q: What is the project structure of the Nocodb MCP Server? A: The project structure includes src/ (TypeScript source files), dist/ (compiled JavaScript output), .env (environment variable configurations), package.json (project dependencies and scripts), and tsconfig.json (TypeScript settings).

Q: Where can I find example prompts for using the Nocodb MCP Server? A: The documentation includes example prompts for tasks such as getting records, creating records, updating records, deleting records, adding columns, and deleting columns.

Q: Does the Nocodb MCP Server support uploading files? A: Yes, the server supports uploading JSON files to create tables in your Nocodb database.

Q: Can I perform bulk operations with the Nocodb MCP Server? A: Yes, the server facilitates bulk creation and deletion of records for improved efficiency.

Q: How can I contribute to the Nocodb MCP Server project? A: Contributions are encouraged! Feel free to open issues or submit pull requests on the repository.

Q: What license is the Nocodb MCP Server distributed under? A: This project is distributed under the MIT license.

Q: How does the Nocodb MCP Server relate to UBOS? A: The Nocodb MCP Server integrates seamlessly with the UBOS platform, allowing UBOS users to connect AI Agents to their Nocodb databases. UBOS provides a full-stack AI Agent Development Platform to build, orchestrate, and deploy AI agents.