NocoDB MCP connector

NocoDB is an open-source no-code database platform that transforms databases into collaborative workspaces with spreadsheet-like interfaces. The NocoDB MCP connector allows AI agents to navigate workspace and base hierarchies, browse table metadata, and manage row data across tables. It also supports querying rows with filters, bulk operations, and retrieving individual records for analysis or modification.

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:

• Track project tasks and deadlines across distributed teams without manual spreadsheet updates
• Organize customer information, contacts, and interaction history in a centralized workspace
• Monitor inventory levels and trigger alerts when stock falls below thresholds
• Log employee timesheets, approvals, and payroll data in real-time
• Build approval workflows that route requests through multiple stakeholders automatically
• Consolidate sales pipeline data from multiple sources into a single source of truth
• Archive completed records and maintain audit trails for compliance requirements

Example prompts

Use the following example prompts to invoke NocoDB MCP connector tools from your AI assistant or Boomi Connect workflow:

• Show me all overdue tasks in my NocoDB project management base.
• Create a new customer record in NocoDB with contact details and company information.
• List all bases in my NocoDB workspace so I can see what databases I have available.
• Update the status of all pending invoices to paid in NocoDB.
• Get the details of a specific order from my NocoDB sales table.
• Delete completed onboarding records from my NocoDB HR base from last quarter.
• Add 50 new leads to my NocoDB CRM base from our latest marketing campaign.
• Show me all tables in my NocoDB inventory base so I can understand the structure.
• List all workspaces in NocoDB to confirm which team databases are active.
• Retrieve all rows from my NocoDB customer feedback table that mention product quality.

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	Retrieves all available workspaces in the NocoDB instance.
listWorkspaceBases	Retrieves all bases contained within a specific workspace.
listBases	Retrieves all bases accessible across the entire NocoDB system.
listTables	Retrieves all tables contained within a specific base.
listRows	Retrieves all rows from a specified table with optional filtering.
createRows	Adds new rows to a table with the provided data.
updateRows	Modifies existing rows in a table with updated information.
deleteRows	Removes specified rows from a table permanently.
getRow	Retrieves a single row from a table by its identifier.