NocoDB MCP connector
Updated
NocoDB is an open-source no-code database platform that turns spreadsheets into relational databases with workspaces, bases, and tables. The NocoDB MCP connector allows AI agents to explore workspace and base structures and manage row-level data across tables. It also supports retrieving individual records and organizing data at scale, making it easier to automate database operations within existing workflows.
Authentication type
- API Key - Requires a static API key to be configured before the agent can connect to the service.
Uses
Use the NocoDB MCP connector to perform the following actions:
- Organize business data across workspaces, bases, and tables in NocoDB
- Retrieve customer, inventory, or project records instantly from NocoDB tables
- Add new rows to track leads, tasks, or orders in NocoDB
- Update existing records to reflect status changes or corrections
- Remove outdated or duplicate rows to keep tables accurate
- Audit workspace and base structures before building new workflows
- Fetch a single record for quick verification or reporting
- Sync no-code database changes into broader automation workflows
Example prompts
Use the following example prompts to invoke NocoDB MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me all the workspaces available in NocoDB.List every base inside our marketing workspace in NocoDB.What tables exist in the sales base in NocoDB?Show me all open invoices from last month in NocoDB.Add a new customer row to the contacts table in NocoDB.Update the status of order 1023 to shipped in NocoDB.Delete the duplicate entry for John Smith in NocoDB.Get the details for row 45 in the inventory table in NocoDB.List all rows in the projects table where the deadline is this week in NocoDB.Create three new rows for the leads generated this morning in NocoDB.
NocoDB MCP connector tools
The NocoDB MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.
| Tool | Description |
|---|---|
| listWorkspaces | List workspaces |
| listWorkspaceBases | List bases in workspace |
| listBases | List all bases |
| listTables | List tables in base |
| listRows | List rows |
| createRows | Create rows |
| updateRows | Update rows |
| deleteRows | Delete rows |
| getRow | Get a row |
