Nocodb MCP server

Connect Nocodb to Claude, ChatGPT, Cursor, Claude Code, Codex, Gemini, GitHub Copilot and any other MCP client, for your whole team. Metorial adds security, governance, and tracing, and gives everyone one Magic MCP URL to connect.

What you can do with the Nocodb MCP server

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Use the get record tool in Nocodb
  • Use the delete records tool in Nocodb
  • Use the list records tool in Nocodb
  • Use the get table tool in Nocodb
  • Use the list tables tool in Nocodb
  • Use the list bases tool in Nocodb

Supported Tools

get_record

Get Record

Retrieve a single record by its row ID from a NocoDB table. Optionally specify which fields to include.

delete_records

Delete Records

Delete one or more records from a NocoDB table by their row IDs. This action is permanent and cannot be undone.

list_records

List Records

Query and list records from a NocoDB table with optional filtering, sorting, field selection, and pagination. Use the `where` parameter for filtering with syntax like `(fieldName,eq,value)`. Logical operators: `~and`, `~or`. Comparison operators: `eq`, `neq`, `gt`, `lt`, `gte`, `lte`, `like`, `nlike`, `is`, `isnot`, `in`, `btw`, `nbtw`. Use the `sort` parameter to order results; prefix with `-` for descending.

get_table

Get Table

Retrieve detailed metadata for a specific table, including its full schema with all fields/columns, their types, and configuration. Useful for understanding table structure before creating or updating records.

list_tables

List Tables

List all tables within a NocoDB base. Returns table metadata including IDs and titles. Use this to discover available tables before querying records.

list_bases

List Bases

List bases accessible in the NocoDB instance. Without workspaceId, use the instance-wide v2 route. With workspaceId, return one provider page of bases and its pagination metadata.

create_records

Create Records

Create one or more records in a NocoDB table. Each record is an object where keys are field names and values are the data to insert. Supports bulk insertion by passing multiple records at once.

create_table

Create Table

Create a new table in a NocoDB base. Optionally provide initial column definitions and a source ID. Column defaults depend on the deployment.

update_records

Update Records

Update one or more existing records in a NocoDB table. Each record must include its row `Id` along with the fields to update. Supports bulk update by passing multiple records at once.

manage_field

Manage Field

Create, update, or delete a field (column) on a NocoDB table. - **create**: Add a new field to a table by specifying tableId and field properties. - **update**: Modify an existing field by specifying fieldId and the properties to change. - **delete**: Remove a field by specifying its fieldId.

list_views

List Views

List all views for a NocoDB table. Views include Grid, Gallery, Form, Kanban, and Calendar types. Each view provides a filtered/sorted perspective of the table data.

manage_webhook

Manage Webhook

Create, update, delete, or list webhooks on a NocoDB table. Webhooks notify external services when record events occur (insert, update, delete). - **list**: List all webhooks for a table. - **create**: Create a new webhook on a table. - **update**: Update an existing webhook. - **delete**: Delete a webhook.

count_records

Count Records

Count records in a table or view, optionally applying a where filter without retrieving every record.

delete_base

Delete Base

Delete a NocoDB base and its resources. Call list_bases to discover base IDs.

update_base

Update Base

Update a base title, description, color, or metadata. Call list_bases to discover base IDs.

get_field

Get Field

Read a field definition and all provider options. Call get_table to discover field IDs.

get_base

Get Base

Read base metadata, including its data source IDs. Call list_bases to discover base IDs.

delete_table

Delete Table

Delete a table and its records. Call list_tables to discover table IDs.

create_base

Create Base

Create a NocoDB base. Optionally choose a workspace on deployments supporting workspace-specific creation.

update_table

Update Table

Update a NocoDB table title or metadata. Call list_tables to discover table IDs.

Connect Nocodb to your AI client

Every client uses the same Magic MCP URL, and so does any other MCP client. Add it once and sign in with SSO.

  1. Enable Nocodb in Metorial. In your Metorial portal, enable the Nocodb MCP server and sign in with the account that owns the data. Access stays governed by your team policies.
  2. Add a custom connector. Open Customize, then Connectors. Select Add, then Custom, then Web.
  3. Paste your Metorial MCP URL. Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
  4. Sign in. Select Add and sign in to load Nocodb tools.

Run Nocodb through the Metorial gateway

One governed layer for every app your agents reach, not a separate connector per tool.

  • Give Nocodb and every other app to your whole team through one MCP gateway, behind your SSO.
  • Scope which teams and agents can use Nocodb tools with role-based access control, and trace every call.
  • Prefer to run it yourself? Metorial is open source and self-hostable.

More integrations teams use with Nocodb

Notion

Create, read, update, and archive pages and databases in a Notion workspace. Manage blocks (paragraphs, lists, headings, embeds, etc.) within pages. Query databases with filters and sorts across rich property types including text, numbers, dates, selects, relations, and formulas. Search across pages and databases by title. Add and read comments on pages and blocks. Upload files to pages. Manage workspace users and retrieve user profiles.

Google Sheets

Create, read, and update spreadsheets and their cell data. Read and write values to individual cells, ranges, or multiple ranges using A1 notation or named ranges. Apply cell formatting including text styles, backgrounds, borders, number formats, and conditional formatting. Manage sheets (tabs) within a spreadsheet—add, delete, copy, rename, and reorder them. Create and manage embedded charts, pivot tables, filter views, data validation rules, protected ranges, named ranges, and merged cells. Perform batch operations to apply multiple updates atomically.

GitHub

Manage repositories, issues, and pull requests. Create and configure branches, star repositories, review code, and merge changes. Automate CI/CD workflows with GitHub Actions, manage workflow runs, secrets, and artifacts. Track issues with labels, milestones, and assignees. Search across code, repositories, issues, and users. Manage organizations, teams, and memberships. Create and manage projects, gists, packages, deployments, and environments. Access security alerts including code scanning, secret scanning, and Dependabot alerts. Read and write file contents in repositories. Manage webhooks, notifications, and codespaces.

Salesforce

Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. Resolve site users to numeric Person/Group LookupId values. Upload, download, move, copy, and version files in document libraries. Search across sites, files, folders, lists, and list items using Microsoft Search. Manage permissions at site, list, and item levels with granular access control. Define and manage content types and site columns. Retrieve site properties and search for sites across Microsoft 365.

Microsoft Outlook

Send, read, reply to, forward, and manage email messages in user mailboxes. Organize messages into folders, apply categories, flags, and importance levels. Manage file and item attachments. Create, update, delete, and respond to calendar events and meetings. Find available meeting times, manage attendees, handle recurrence, and work with shared or delegated calendars. Create, read, update, and delete contacts, organize them into contact folders, and manage contact photos. Manage tasks and task lists via Microsoft To Do, including due dates, reminders, recurrence, and checklist items. Support for Focused Inbox, @-mentions, mail tips, send-on-behalf, and send-as capabilities.

Technical notes for Nocodb

Manage databases through a spreadsheet-like no-code platform. Create, read, update, and delete workspaces, bases, tables, fields, and records. Query records with filtering, sorting, and field selection. Manage multiple view types including Grid, Gallery, Form, Kanban, and Calendar views. Create and configure webhooks for record, view, and field change events. Upload and manage file attachments. Connect to external data sources like PostgreSQL, MySQL, SQL Server, and MariaDB. Share views publicly or with password protection. Perform bulk record operations for inserting, updating, and deleting. Manage user access with role-based permissions at workspace and base levels. Support a wide variety of field types including text, numbers, dates, attachments, linked records, formulas, lookups, and rollups.

Frequently asked questions

Common questions about connecting Nocodb to AI agents with Metorial.

  1. How many tools does the Nocodb MCP server have?
    The Nocodb MCP server exposes 21 tools, including Get Record, Delete Records, List Records. Each one is governed and traced through Metorial.
  2. Nocodb exposes tools your agents call on demand; it does not publish event triggers yet. Everything still runs through one governed MCP URL.
  3. Any MCP client, including VS Code, Windsurf, Zed, OpenCode and Grok. Each one reaches the Nocodb MCP server through the same Metorial URL.
  4. Use role-based access control to decide which teams, users, and agents can use Nocodb and which of its tools they can call.
  5. Yes. Metorial is open source, so you can run the Nocodb MCP server yourself or use the hosted gateway.

Connect Nocodb to production AI agents

See how Metorial gives your team governed access to Nocodb, with tracing and security controls built in.