Connect Nocodb to AI agents

Connect Nocodb to Claude, Codex, Cursor, or other AI agents for your entire team. Metorial security, governance, observability, and gives your team a unified Magic MCP url to connect.

Deploy NocodbBook a demo

Supported Tools

Tools13Triggers1

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, titles, and column counts. Use this to discover available tables before querying records.

list_bases

List Bases

List all bases (databases/projects) accessible in the NocoDB instance. Returns base metadata including IDs, titles, and table counts.

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. If no columns are specified, a default table with a Title column is created.

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.

link_records

Link Records

Manage linked records between tables. List, link, or unlink records through a LinkToAnotherRecord field. - **list**: List all records linked to a given record through a link field. - **link**: Create links between a record and one or more target records. - **unlink**: Remove links between a record and one or more target records.

More integrations teams use with Nocodb

Linear

Create, read, update, and delete issues across teams with support for priorities, labels, assignees, due dates, and workflow states. Manage projects that group related issues, and organize work into time-boxed cycles (sprints). Create and manage documents, comments, and file attachments. Search issues using vector similarity or rich filters. Configure teams, workflow states, and labels. Track customers and link them to issues. Subscribe to real-time webhooks for changes to issues, projects, cycles, comments, documents, and more.

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.

Sharepoint

Manage SharePoint sites, document libraries, lists, and files. Create, read, update, and delete lists and list items with custom columns. 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. Subscribe to webhooks for list and library change notifications. Retrieve site properties and search for sites across Microsoft 365.

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. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.

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. Subscribe to webhook notifications for changes to messages, calendar events, and contacts. Support for Focused Inbox, @-mentions, mail tips, send-on-behalf, and send-as capabilities.

Airtable

Create, read, update, and delete records in Airtable bases and tables. Manage base schemas including creating tables and fields. Filter records using formulas, sort by fields, and scope queries to specific views. Upsert records to find, create, or update in a single call. Upload attachments to records, read and write record comments, list accessible bases, and receive real-time base change events through webhooks.

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.

Connect Nocodb to production AI agents

See how Metorial gives Nocodb access the governance, tracing, and security controls teams need.

Book a demoDeploy Nocodb

Frequently asked questions

Common questions about connecting Nocodb to AI agents with Metorial.

  1. Can Metorial connect Nocodb to AI agents?
    Yes. Metorial connects AI agents to Nocodb through a governed integration layer, so teams can use the provider while keeping access controlled and observable.
  2. Metorial is MCP compatible and lets teams expose approved provider tools to MCP-capable agents and clients through a controlled access layer.
  3. Metorial applies policies across users, groups, providers, agents, and individual tools, then records the context around every agent interaction.
  4. Yes. Metorial records provider activity so teams can inspect tool calls, troubleshoot integrations, and give security teams the visibility they need.