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.

159 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_basisChanges dataCreate a new basis. Required: title. API summary: Create Base (OSS).
create_basis_api_tokenDeletesCreate a new api token for a basis. Destructive action; may require approval. API summary: Create API Token.
create_basis_meta_diffChanges dataCreate a new meta diff for a basis. API summary: Sync Meta.
create_basis_sharedChanges dataCreate a new shared for a basis. API summary: Create Base Shared Base.
create_basis_sourceChanges dataCreate a new source for a basis. API summary: Create Source.
create_basis_userChanges dataCreate a new user for a basis. Required: email or roles. API summary: Create Base User.
create_basis_visibility_ruleChanges dataCreate a new visibility rule for a basis. API summary: Create UI ACL.
create_bulkVisible to othersCreate a new bulk. Has effects visible outside this system. API summary: Bulk create-update-delete columns.
create_changeDeletesCreate a new change. Required: current password or new password. Destructive action; may require approval. API summary: Change Password.
create_column_primaryChanges dataCreate a new primary for a column. API summary: Create Primary Value.
create_erdChanges dataCreate a new erd. API summary: share ERD view.
create_forgotDeletesCreate a new forgot. Required: email. Destructive action; may require approval. API summary: Forget Password.
create_hook_filterDeletesCreate a new filter for a hook. Search filters first to avoid duplicates. Destructive action; may require approval. API summary: Create Table Hook Filter.
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_shared_view_rowChanges dataCreate a new row for a shared view. Search rows first to avoid duplicates. API summary: Create Share View Row.
create_signupChanges dataCreate a new signup. Required: email or password.
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).
create_table_2Changes dataCreate a new table for a basis. Required: columns or title. API summary: Create Table.
create_table_columnChanges dataCreate a new column for a table. API summary: Create Column.
create_table_formChanges dataCreate a new form for a table. Required: title or type. API summary: Create Form View.
create_table_galleryChanges dataCreate a new gallery for a table. Required: title or type. API summary: Create Gallery View.
create_table_gridChanges dataCreate a new grid for a table. Required: title or type. API summary: Create Grid View.
create_table_hookDeletesCreate a new hook for a table. Required: title, operation, notification or type. Destructive action; may require approval. API summary: Create Table Hook.
create_table_kanbanChanges dataCreate a new kanban for a table. Required: title or type. API summary: Create Kanban View.
create_table_mapChanges dataCreate a new map for a table. Required: title or type. API summary: Create Map View.
create_table_reorderChanges dataCreate a new reorder for a table. API summary: Reorder Table.
create_testDeletesCreate a new test. Required: hook or payload. Destructive action; may require approval. API summary: Test Hook.
create_test_plugin_testChanges dataCreate a new test. Required: title, input or category. API summary: Test Plugin.
create_test_utils_test_connectionChanges dataCreate a new test. API summary: Test DB Connection.
create_view_columnChanges dataCreate a new column for a view. API summary: Create Column in View.
create_view_filterChanges dataCreate a new filter for a view. Search filters first to avoid duplicates. API summary: Create View Filter.
create_view_hide_allChanges dataCreate a new hide all for a view. API summary: Hide All Columns In View.
create_view_shareChanges dataCreate a new share for a view. API summary: Create Shared View.
create_view_sortChanges dataCreate a new sort for a view. API summary: Create View Sort.
create_workspaceChanges dataCreate a new workspace. API summary: Create workspaces ☁.
create_workspace_basisChanges dataCreate a new basis for a workspace. Required: title. API summary: Create Base.
create_workspace_userVisible to othersCreate a new user for a workspace. Has effects visible outside this system. API summary: Workspace user invite ☁.
delete_basisDeletesPermanently delete a basis by base id. Destructive action; may require approval. API summary: Delete Base.
delete_basis_api_tokenDeletesPermanently delete a api token by token id. Destructive action; may require approval. API summary: Delete API Token.
delete_basis_sharedsMoves moneyPermanently delete a shared by base id. Financial or irreversible action; may require approval. API summary: Delete Base Shared Base.
delete_basis_sourceDeletesPermanently delete a source by source id. Destructive action; may require approval. API summary: Delete Source.
delete_basis_userDeletesPermanently delete a user by user id. Destructive action; may require approval. API summary: Delete Base User.
delete_cachesMoves moneyPermanently delete a cache. Financial or irreversible action; may require approval. API summary: Delete Cache.
delete_columnDeletesPermanently delete a column by column id. Destructive action; may require approval. API summary: Delete Column.
delete_erdsMoves moneyPermanently delete a erd by source id. Financial or irreversible action; may require approval.
delete_filterDeletesPermanently delete a filter by filter id. Destructive action; may require approval. API summary: Delete Filter.
delete_hookDeletesPermanently delete a hook by hook id. Destructive action; may require approval. API summary: Delete Table Hook.
delete_link_recordDeletesPermanently delete a record by record id. Destructive action; may require approval. API summary: Unlink Records.
delete_messageDeletesPermanently delete a message by message id. Destructive action; may require approval. API summary: Delete Comment.
delete_recordMoves moneyPermanently delete a record from a table by `table_id`, with `body` holding the record's `Id`. This cannot be undone.
delete_sortDeletesPermanently delete a sort by sort id. Destructive action; may require approval. API summary: Delete Sort.
delete_tableDeletesPermanently delete a table by table id. Destructive action; may require approval. API summary: Delete Table.
delete_viewDeletesPermanently delete a view by view id. Destructive action; may require approval. API summary: Delete View.
delete_view_sharesMoves moneyPermanently delete a share by view id. Financial or irreversible action; may require approval. API summary: Delete Shared View.
delete_workspaceDeletesPermanently delete a workspace by workspace id. Destructive action; may require approval. API summary: Delete workspace ☁.
delete_workspace_userDeletesPermanently delete a user by user id. Destructive action; may require approval. API summary: Delete workspace user ☁.
export_exportsChanges dataExport exports. API summary: Trigger export as job.
get_baseGet one base by `base_id`, including its data sources.
get_basis_meta_diffGet one meta diff for a basis by source id. API summary: Source Meta Diff.
get_basis_sourceGet one source for a basis by source id. API summary: Get Source Schema.
get_calendar_viewGet one calendar view by shared view uuid. Results are paginated. API summary: List Shared View Rows.
get_calendar_view_by_dateGet one calendar view by shared view uuid. Results are paginated. API summary: Count of Records in Dates in Calendar View.
get_columnGet one column by column id. API summary: Get Column Metadata.
get_current_userGet the signed-in NocoDB user's profile.
get_filterGet one filter by filter id. API summary: Get Filter Metadata.
get_formGet one form by form view id. API summary: Get Form View Metadata.
get_galleryGet one gallery by gallery view id. API summary: Get Gallery View Metadata.
get_kanbanGet one kanban by kanban view id. API summary: Get Kanban View Metadata.
get_mapGet one map by map view id. API summary: Get Map View.
get_messageGet one message. API summary: Count Comments.
get_pluginGet one plugin by plugin id. API summary: Get Plugin.
get_plugin_statusGet the current status of a plugin by plugin id. API summary: Get Plugin Status.
get_recordGet one record by `table_id` and `record_id`.
get_sample_payloadGet one sample payload by version. API summary: Get Sample Hook Payload.
get_shared_view_groupGet one group for a shared view by column id. Results are paginated. API summary: List Shared View Grouped Data.
get_shared_view_nestedGet one nested for a shared view by column name. Results are paginated. API summary: List Nested Data Relation.
get_shared_view_rowGet one row for a shared view by column name. Results are paginated. API summary: List Nested List Data.
get_sortGet one sort by sort id. API summary: Get Sort Metadata.
get_tableGet one table by `table_id`, including its columns (field names and types). Check this before creating or updating records.
get_view_allChanges dataGet one view by view id. API summary: Show All Columns In View.
get_workspaceGet one workspace by workspace id. API summary: Read workspace ☁.
get_workspace_userGet one user for a workspace by user id. API summary: Workspace user read ☁.
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_basis_api_tokensList api tokens for a basis. API summary: List API Tokens in Base.
list_basis_infosList infos for a basis. API summary: Get Base info.
list_basis_meta_diffsList meta diffs for a basis.
list_basis_sharedsList shareds for a basis. API summary: Get Base Shared Base.
list_basis_sourcesList sources for a basis.
list_basis_usersList users for a basis. API summary: List Base Users.
list_basis_visibility_rulesList visibility rules for a basis. Optional filters: include m2 m. API summary: Get UI ACL.
list_cachesList caches. API summary: Get Cache.
list_grid_grid_columnsList grid columns for a grid. API summary: List Grid View Columns.
list_hashesList hashes. API summary: Get columns hash for table.
list_hook_logsList logs for a hook. Results are paginated. API summary: List Hook Logs.
list_infosList infos. API summary: Get App Info.
list_linked_recordsList the records linked to a record through a Links field, by `table_id`, `link_field_id` and `record_id`.
list_pluginsList plugins.
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_shared_base_metaList meta for a shared base. API summary: Get Share Source Meta.
list_shared_erd_metaList meta for a shared erd.
list_shared_view_metaList meta for a shared view. API summary: Get Share View Meta.
list_table_hooksList hooks for a table. API summary: List Table Hooks.
list_table_sharesList shares for a table. API summary: List Shared Views.
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_tables_2List tables for a basis. Optional filters: sort or include m2 m. Results are paginated.
list_view_columnsList columns for a view. API summary: List View Columns.
list_view_sortsList sorts for a view. API summary: List View Sorts.
list_webhooksList webhooks. API summary: Webhook List Plugins.
list_workspace_basesList the bases in one workspace by `workspace_id`.
list_workspace_usersList users for a workspace. API summary: Workspace users list ☁.
list_workspacesList the NocoDB workspaces you can access.
search_filter_childrenSearch children for a filter. Use this to find existing children before creating a new child. API summary: Get Filter Group Children.
search_hook_filtersSearch filters for a hook. Use this to find existing filters before creating a new filter. API summary: Get Table Hook Filter.
search_shared_view_aggregatesSearch aggregates for a shared view by where, filter arr json or aggregation. Use this to find existing aggregates before creating a new aggregate. API summary: Read Shared View Aggregated Data.
search_shared_view_bulk_aggregatesSearch bulk aggregates for a shared view by where, filter arr json, aggregation or aggregate filter list. Use this to find existing bulk aggregates before creating a new bulk aggregate. API summary: Read Shared View Bulk Aggregated Data.
search_shared_view_groupbiesSearch groupbies for a shared view by sort, where, sort arr json, filter arr json or column name. Use this to find existing groupbies before creating a new groupby. Results are paginated. API summary: List Shared View Rows.
search_shared_view_rowsSearch rows for a shared view by sort, where, sort arr json, filter arr json or pks. Use this to find existing rows before creating a new row. Results are paginated. API summary: List Shared View Rows.
search_view_filtersSearch filters for a view. Use this to find existing filters before creating a new filter. API summary: List View Filters.
submit_tokenDeletesRefresh a token. Destructive action; may require approval. API summary: Refresh Token.
submit_user_inviteVisible to othersResend a user (user id). Has effects visible outside this system. API summary: Resend User Invitation.
update_basisChanges dataUpdate an existing basis identified by base id. Only the fields you pass are changed. API summary: Update Base.
update_basis_meta_diffChanges dataUpdate an existing meta diff identified by source id. API summary: Synchronise Source Meta.
update_basis_sharedsVisible to othersUpdate an existing shared identified by base id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Update Base Shared Base.
update_basis_sourceChanges dataUpdate an existing source identified by source id. Only the fields you pass are changed. API summary: Update Source.
update_basis_userChanges dataUpdate an existing user identified by user id. Only the fields you pass are changed. API summary: Update Base User.
update_basis_usersVisible to othersUpdate an existing user identified by base id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Base user meta update.
update_columnChanges dataUpdate an existing column identified by column id. Only the fields you pass are changed. API summary: Update Column.
update_duplicateChanges dataUpdate an existing duplicate identified by source id. API summary: Duplicate Base Source.
update_duplicate_base_duplicateChanges dataUpdate an existing duplicate identified by base id. API summary: Duplicate Base.
update_duplicate_tableChanges dataUpdate an existing table identified by table id. API summary: Duplicate Table.
update_exportChanges dataUpdate an existing export identified by export as. API summary: Trigger export as job.
update_filterChanges dataUpdate an existing filter identified by filter id. Only the fields you pass are changed. API summary: Update Filter.
update_formChanges dataUpdate an existing form identified by form view id. Only the fields you pass are changed. API summary: Update Form View.
update_form_columnChanges dataUpdate an existing form column identified by form view column id. Only the fields you pass are changed. API summary: Update Form View Column.
update_galleryChanges dataUpdate an existing gallery identified by gallery view id. Only the fields you pass are changed. API summary: Update Gallery View.
update_gridChanges dataUpdate an existing grid identified by view id. Only the fields you pass are changed. API summary: Update Grid View.
update_grid_columnChanges dataUpdate an existing grid column identified by column id. Only the fields you pass are changed. API summary: Update Grid View Column.
update_hookDeletesUpdate an existing hook identified by hook id. Only the fields you pass are changed. Destructive action; may require approval. API summary: Update Table Hook.
update_kanbanChanges dataUpdate an existing kanban identified by kanban view id. Only the fields you pass are changed. API summary: Update Kanban View.
update_mapChanges dataUpdate an existing map identified by map view id. Only the fields you pass are changed. API summary: Update Map View.
update_messageChanges dataUpdate an existing message identified by message id. Only the fields you pass are changed. API summary: Update Comment.
update_pluginChanges dataUpdate an existing plugin identified by plugin id. Only the fields you pass are changed. API summary: Update Plugin.
update_projectChanges dataUpdate an existing project identified by base id. API summary: Get Jobs.
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.
update_sortChanges dataUpdate an existing sort identified by sort id. Only the fields you pass are changed. API summary: Update Sort.
update_tableChanges dataUpdate an existing table identified by table id. Only the fields you pass are changed. API summary: Update Table.
update_usersVisible to othersUpdate an existing user. Only the fields you pass are changed. Has effects visible outside this system. API summary: Update User Profile.
update_viewChanges dataUpdate an existing view identified by view id. Only the fields you pass are changed. API summary: Update View.
update_view_columnChanges dataUpdate an existing column identified by column id. Only the fields you pass are changed. API summary: Update View Column.
update_view_sharesVisible to othersUpdate an existing share identified by view id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Update Shared View.
update_workspaceChanges dataUpdate an existing workspace identified by workspace id. Only the fields you pass are changed. API summary: Update workspace ☁.
update_workspace_userChanges dataUpdate an existing user identified by user id. Only the fields you pass are changed. API summary: Update workspace user ☁.
upload_storageChanges dataUpload a storage. API summary: Attachment Upload.
upload_storage_by_urlChanges dataUpload a storage. API summary: Attachment Upload by URL.

Set up in three steps

1
Pick the app
Create a free HeyMyApps 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 HeyMyApps 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?

HeyMyApps 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. HeyMyApps calls the address you enter, so it must be reachable from the internet.