NocoDB

Query and edit NocoDB records from an AI agent.

Opens Agent Studio, where connecting is one click. The connector URL below works in any MCP client.

Paste it into any MCP client. Setup docs

What the NocoDB connector does

The NocoDB MCP server connects a NocoDB base to Claude and any MCP-compatible agent. Its 11 listed tools read table schemas, query, count and aggregate records, read attachments, and create, update and delete records. On Cloud and licensed deployments the surface extends well past records.

Connection verified

Connection checked by Agentman on .

Listed in Anthropic’s Connectors Directory at community tier — a listing, not a partner-level review.

Anthropic states this reflects the level of review a connector received, not a security audit.

NocoDB tools (11)

  • aggregate
  • countRecords
  • createRecords
  • deleteRecords
  • getBaseInfo
  • getRecord
  • getTableSchema
  • getTablesList
  • queryRecords
  • readAttachment
  • updateRecords

Tool names from Anthropic's directory listing. This server requires sign-in, so we could not read tool descriptions or parameter schemas.

Limits

  • deleteRecords is a single call and NocoDB's own example is a bulk delete. No two-phase confirmation is published.
  • The real surface depends on your edition. Cloud and licensed self-hosted expose schema, workflow and permission tools that the portable 11 do not include.
  • Permission tools can change visibility, including Record-Level Security policies — a larger grant than data editing.
  • Your base role is the ceiling, which is also the main mitigation: viewers read, editors write, and audit behaves as it does through the REST API.
  • The endpoint returns an application error to unauthenticated requests rather than a standard challenge, which can read as a dead URL.
  • We did not read tool schemas. The endpoint requires OAuth, so names come from Anthropic's directory and behaviour from NocoDB's documentation. We exercised no tool.

Frequently asked questions

Can the NocoDB MCP server delete my records?

Yes. deleteRecords is one of the eleven tools every NocoDB edition exposes, alongside createRecords and updateRecords. NocoDB's own sample prompt for the delete action is removing all tasks assigned to a person, so bulk deletion is the documented intent. No two-phase confirmation is published for it.

Does the NocoDB MCP server do more on Cloud than self-hosted?

Yes. Every edition exposes the record tools, but NocoDB documents that Cloud and licensed self-hosted deployments also expose tools for tables and fields, views, scripts, dashboards, webhooks, comments, interfaces, workflows, permissions, documents, import and export, duplication, row colouring, and folders and members.

Can the NocoDB MCP server change table permissions?

On Cloud and licensed self-hosted deployments, yes. NocoDB lists setting table and field permissions and Record-Level Security policies among the workspace tools. That is a notable capability to grant an agent, because it can alter who sees what rather than only changing data within existing rules.

Does the NocoDB MCP server respect my role?

Yes. NocoDB documents that tools respect the token owner's base role — viewers can read and editors can write — and that each tool wraps the same service as the matching REST API, so validation, permissions and audit behave identically. The connector inherits your existing base role rather than bypassing it.

Why does the NocoDB MCP endpoint return an error in a browser?

Because an unauthenticated request has no base context. Requesting the endpoint directly returns a NocoDB application error about a base not being found, rather than a protocol response. The server is running and OAuth-protected — it publishes RFC 9728 metadata at the same host — so that error is not a sign the endpoint is wrong.

Which clients does NocoDB document for MCP?

Both desktop and web. NocoDB publishes configuration for Claude, Cursor, Windsurf, AntiGravity and Codex as desktop clients with a JSON example, and separate OAuth setup steps for web-based clients including Claude Web and ChatGPT, with a section on configuring tool permissions in Claude Web.

Sources

Use it in an agent

Put NocoDB to work.

Connect NocoDB once and your agents call these tools on their own: on a schedule, in a workflow, with nobody at the keyboard.

Call (650) 285-1019Our AI receptionist answers.