Integration · Company data

Connect Claude & ChatGPT to NocoDB

Ask your AI what is in a NocoDB table, how many records match a filter, or to add and update rows for you. It can browse workspaces, bases, tables and views, read a table's columns, link records and add comments. It works with NocoDB Cloud and with your own self-hosted server.

Connect NocoDB free

Free plan, no credit card. Takes about a minute.

Try asking

“How many open tickets are in the Support table?”
The AI finds the table and counts the records matching a filter like (Status,eq,Open).
“Show the 10 newest leads in the Leads table.”
It lists records from the table, sorted newest first, with a limit of 10.
“Add a row to Orders: customer Nordic Foods, 40 units, status New.”
It reads the table's columns, then creates the record with those field values.

What your AI can do

Records

List, filter, sort and count records, read one by ID, and create or update records with only the fields you name.

Bases and tables

Browse workspaces, bases, tables and views, read a table's columns before writing, and create new tables.

Links and comments

Link records through Links fields, list linked records, and read or add comments on a record.

“Mark task 58 in the Tasks table as done.”
It updates only the Status field on that record. The other fields stay as they are.
“Which projects are linked to the client Acme?”
It lists the records linked to Acme's record through the Links field.
“Create a table for event sign-ups with name, email and date.”
It creates a new table in the base with those three columns.

19 tools for NocoDB

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

add_record_commentChanges dataAdd a `comment` to a record by `fk_model_id` (the table ID) and `row_id`.
count_recordsCount records in a table by `table_id`, optionally matching a `where` filter or `view_id`.
create_recordChanges dataCreate a record in a table by `table_id`. Put the field values in `body` as an object of column names to values.
create_tableChanges dataCreate a table in a base by `base_id` with a `title` and a list of `columns` (each with a title and type).
delete_recordMoves moneyPermanently delete a record from a table by `table_id`, with `body` holding the record's `Id`. This cannot be undone.
get_baseGet one base by `base_id`, including its data sources.
get_current_userGet the signed-in NocoDB user's profile.
get_recordGet one record by `table_id` and `record_id`.
get_tableGet one table by `table_id`, including its columns (field names and types). Check this before creating or updating records.
link_recordsChanges dataLink records to a record through a Links field by `table_id`, `link_field_id` and `record_id`; `body` holds the IDs to link.
list_basesList the bases (databases) you can access, with their IDs.
list_linked_recordsList the records linked to a record through a Links field, by `table_id`, `link_field_id` and `record_id`.
list_record_commentsList the comments on a record by `fk_model_id` (the table ID) and `row_id`.
list_recordsList records in a table by `table_id`, with optional `where` filter (e.g. (Status,eq,Open)), `sort`, `view_id`, `limit` and `offset`.
list_table_viewsList the views (grid, form, kanban and so on) of a table by `table_id`.
list_tablesList the tables in a base by `base_id`. Use to find a table's ID.
list_workspace_basesList the bases in one workspace by `workspace_id`.
list_workspacesList the NocoDB workspaces you can access.
update_recordVisible to othersUpdate a record in a table by `table_id`. Put the record's `Id` and the fields to change in `body`; other fields stay as they are.

Set up in three steps

1
Pick the app
Create a free PipMCP account and choose NocoDB from the app list.
2
Paste your key
Enter your NocoDB address (https://app.nocodb.com for NocoDB Cloud, or your self-hosted URL) and an API token. In NocoDB open Account Settings > API Tokens and click Create New API Token. Choose the bases and permissions the AI may use, then copy the token. It is shown only once.
3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
1. Click your name, then Settings › Connectors › Add custom connector.
2. Paste your link as the Remote MCP server URL.
3. Switch it on from the + menu in a chat.

Questions

What can the AI do in NocoDB?

The AI can list workspaces, bases, tables and views, read a table's columns, and list, filter, count and read records. It can create and update records, create tables, link records and add comments. It can also delete a record if you switch that tool on.

Does the AI see my NocoDB credentials?

No. Your NocoDB API token is encrypted at rest and never shown to the AI. After you save it, it is not shown again, not even to you. The AI only sees the results of the tools it calls.

Can I control what the AI is allowed to do?

Yes. You choose which tools are switched on, so you can start read-only. Updating records and deleting a record, which is permanent, can require your approval before they run. The bases and permissions you pick for the API token in NocoDB also limit what the AI can reach. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your PipMCP link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.

What does it cost?

PipMCP has a free plan with no credit card required. Paid plans bill per completed task. You also need your own NocoDB account or server.

Does it work with self-hosted NocoDB?

Yes. Enter your own server address instead of https://app.nocodb.com, together with an API token created on that server. PipMCP calls the address you enter, so it must be reachable from the internet.