nocodb

name

nocodb

description

NocoDB is an open-source no-code database platform that turns relational databases into collaborative spreadsheet-style interfaces and APIs, allowing teams and developers to manage data, build internal tools, automate workflows, and integrate existing SQL databases without migrating underlying data. Read and write NocoDB data through One: bases, tables, tablerecords, columns, tablehooks, views and more, 167 actions with real parameter documentation. Use whenever the user asks to look something up in NocoDB, create or update a record there, or build code against the NocoDB API.

NocoDB through One

NocoDB is an open-source no-code database platform that turns relational databases into collaborative spreadsheet-style interfaces and APIs, allowing teams and developers to manage data, build internal tools, automate workflows, and integrate existing SQL databases without migrating underlying data.

One exposes NocoDB through four MCP tools. The table below carries real action ids from One's knowledge base, so for a common operation you can skip search and go straight to reading the action's parameters.

How to run an action

1. Find the action in the table below, or call search_one_platform_actions with platform nocodb if it is not listed.
2. Call get_one_action_knowledge with the action id. Do this every time, including for actions in this table. The table gives you the id, not the parameters.
3. Call execute_one_action with parameters copied from that knowledge.

Never guess a parameter name, a body field, or an enum value. The knowledge has the real schema, and a guessed field is either a 400 or a silent write of the wrong thing.

Before you start

Call list_one_integrations once and confirm NocoDB is connected. If it is missing, the user has not connected it: say so and point them at https://app.withone.ai rather than reaching for raw HTTP.

Each connection carries an access field. If it reports {"policy": "methods", "methods": ["GET"]} the agent is read-only here, so plan a read-only answer instead of attempting a write that will be refused.

Before a write

Creates, updates, deletes and sends land on a real NocoDB account and cannot be recalled. State the action and the specific target in one line before the first write in a task, and let the user stop you. Reads need no confirmation.

Actions

Bases

Action	Method	Path	Action id
Calculate the Base Cost	GET	/api/v2/meta/bases/{{baseId}}/cost	conn_mod_def::GLTrfY_oj_g::RkijMiTnQJC_0j6Qq5xQeQ
Get Base Schema	GET	/api/v2/meta/bases/{{baseId}}	conn_mod_def::GLTrfqPZELg::cuwBvXk2Tou-Ux-jGjL9LQ
List Bases for a Workspace	GET	/api/v2/meta/workspaces/{{workspaceId}}/bases	conn_mod_def::GLTrk1iBqag::JE0eW2CwQV-F81eq9OxXlw
List Bases Using Meta Bases OSS	GET	/api/v2/meta/bases/	conn_mod_def::GLTrfxtJNOg::ZFG31YwhTeqnhzsjRHd2uA
Create a Base in a Workspace	POST	/api/v2/meta/workspaces/{{workspaceId}}/bases	conn_mod_def::GLTrfiaJtFA::Zdvw5sStT2WpjA4X7Nt-lA
Create Base Using Meta Bases	POST	/api/v2/meta/bases/	conn_mod_def::GLTrfhIy4wA::HsytS6TKSAeb3BIFPgnLHQ
Delete Base	DELETE	/api/v2/meta/bases/{{baseId}}	conn_mod_def::GLTrfghymDg::oRClIpslTMiiHERpSmCQLw
Duplicate a Base	POST	/api/v2/meta/duplicate/{{baseId}}	conn_mod_def::GLTrfqFpIig::4owULLWpTGilopghnz5hyg
Update a Base	PATCH	/api/v2/meta/bases/{{baseId}}	conn_mod_def::GLTrf-0EiWA::Ll-9X8M4Qp-6P2UYi2wuEg

Tables

Action	Method	Path	Action id
List Tables for a Base Source	GET	/api/v2/meta/bases/{{baseId}}/{{sourceId}}/tables	conn_mod_def::GLTrjpDRs3A::_uYR5oWbRZKHqWSQmsWMfQ
List Tables in a Base	GET	/api/v2/meta/bases/{{baseId}}/tables	conn_mod_def::GLTrgL0XG5A::fBIer2PGQ7OHr_gvl2DdIQ
Create a Table in a Base	POST	/api/v2/meta/bases/{{baseId}}/tables	conn_mod_def::GLTrgAJeV3g::1HgGwIgdQhSwbnlEpxDHcA
Create a Table in a Base Source	POST	/api/v2/meta/bases/{{baseId}}/{{sourceId}}/tables	conn_mod_def::GLTrjZzygLg::Ti83ZG5fQdSON4eEgsSxag
Delete Table	DELETE	/api/v2/meta/tables/{{tableId}}	conn_mod_def::GLTrf-zxGNA::tPkFljwDT6GDQxa-Qy5ApA
Duplicate a Table in a Base	POST	/api/v2/meta/duplicate/{{baseId}}/table/{{tableId}}	conn_mod_def::GLTrgJjQLnA::0QzHoOjITT274x7nmwdHiQ
Reorder a Table	POST	/api/v2/meta/tables/{{tableId}}/reorder	conn_mod_def::GLTrgJzyvqA::XBaIxhmVSraTpG0tW1YzIg
Update a Table	PATCH	/api/v2/meta/tables/{{tableId}}	conn_mod_def::GLTrgJxKPeg::GPbJlKH6SwqVTw8lVspCOA

TableRecords

Action	Method	Path	Action id
List Table Records for a Table	GET	/api/v2/tables/{{tableId}}/records	conn_mod_def::GLTrkENiV8g::E5T_icTTQ_WslhAEa9FkiQ
Read Table Record	GET	/api/v2/tables/{{tableId}}/records/{{recordId}}	conn_mod_def::GLTrkDGQUOA::Pp6BT7ToT6y2VWq7VYRwGw
Create Table Records for a Table	POST	/api/v2/tables/{{tableId}}/records	conn_mod_def::GLTrj6WgKIA::kw4JvgJWTFq0KxP6XQIHMQ
Delete Table Records	DELETE	/api/v2/tables/{{tableId}}/records	conn_mod_def::GLTrj6cfrDA::eCs0fK7SQRqIHX-0GWPyHQ
Link Records to a Table Record	POST	/api/v2/tables/{{tableId}}/links/{{linkFieldId}}/records/{{recordId}}	conn_mod_def::GLTrj69OL4A::6v1xiHNhQn-bKY7cEOsDrw
Update Table Records	PATCH	/api/v2/tables/{{tableId}}/records	conn_mod_def::GLTrkCOuh1g::1-Sc4s6CTiy4NhC6Eivsvg

Columns

Action	Method	Path	Action id
Get Column Metadata	GET	/api/v2/meta/columns/{{columnId}}	conn_mod_def::GLTrgTDKwHg::JHzkir7rQBGKzuR_FmocJA
Create a Column for a Table	POST	/api/v2/meta/tables/{{tableId}}/columns	conn_mod_def::GLTrgXM2M0g::-mvjJQ8JQEWpULO7hBIKcw
Create Primary Value for a Column	POST	/api/v2/meta/columns/{{columnId}}/primary	conn_mod_def::GLTrgTOMbNA::USC6DsQgRyyw7473iK8b7g
Delete a Column	DELETE	/api/v2/meta/columns/{{columnId}}	conn_mod_def::GLTrgTwtMiA::71puP2wNSzeeX51rYH8rzw
Update a Column	PATCH	/api/v2/meta/columns/{{columnId}}	conn_mod_def::GLTrgfhPpBA::ECM703HSRDWtVl_xj6HRkw

TableHooks

Action	Method	Path	Action id
List Table Hooks for a Table	GET	/api/v2/meta/tables/{{tableId}}/hooks	conn_mod_def::GLTrg7GW0bg::KqNQ8Wu4TAW3B8lOA8r3KA
Create a Table Hook	POST	/api/v2/meta/tables/{{tableId}}/hooks	conn_mod_def::GLTrgxkokmg::64SrQJF_RNWSjJx0ji8Oxw
Delete Table Hook	DELETE	/api/v2/meta/hooks/{{hookId}}	conn_mod_def::GLTrgx11rTg::z_JwDOBwQo-EbSCoRWFd-g
Test Hook for a Table	POST	/api/v2/meta/tables/{{tableId}}/hooks/test	conn_mod_def::GLTrg7e5TLA::qrC5LCKzTdab2665xAnUEw
Update Table Hook	PATCH	/api/v2/meta/hooks/{{hookId}}	conn_mod_def::GLTrg8N_K3g::LqXoT57yTaizOmELiCjS5A

Views

Action	Method	Path	Action id
List Views for a Table	GET	/api/v2/meta/tables/{{tableId}}/views	conn_mod_def::GLTrhiEMaPg::zrkFkb2BQ8eZACYKyaS-Ug
Delete a View	DELETE	/api/v2/meta/views/{{viewId}}	conn_mod_def::GLTrhO_Xy8A::OSnJd5hqRR6viraqlWn3PQ
Hide All Columns in a View	POST	/api/v2/meta/views/{{viewId}}/hide-all	conn_mod_def::GLTrhgujzdA::98q1zXKUQeWe7KNzkmcxfA
Show All Columns in a View	POST	/api/v2/meta/views/{{viewId}}/show-all	conn_mod_def::GLTrhsBK2AA::nr5S_dixRoaWkTLAhLfI1g
Update View	PATCH	/api/v2/meta/views/{{viewId}}	conn_mod_def::GLTrh5TmyrA::wfCXYTqGQ6yWVA7Nv7tKJw

Plugins

Action	Method	Path	Action id
Get a Plugin	GET	/api/v2/meta/plugins/{{pluginId}}	conn_mod_def::GLTriUE0qnA::bnpAg6U8T_SuDa9E55iU0A
Get Plugin Status	GET	/api/v2/meta/plugins/{{pluginId}}/status	conn_mod_def::GLTriUn2p6g::-TG5X1u0Rb-FnzgVmZzc2Q
List Plugins	GET	/api/v2/meta/plugins	conn_mod_def::GLTris70wzA::pyIUoBK4T22R1KuPryeCYg
Test Plugin	POST	/api/v2/meta/plugins/test	conn_mod_def::GLTriuKH-kg::xF29WNYNQLGAafTc1HfL0w
Update Plugin	PATCH	/api/v2/meta/plugins/{{pluginId}}	conn_mod_def::GLTriux2r-A::vLPnGxRgThOKQbxOWvwB1A

Workspaces

Action	Method	Path	Action id
List Workspaces	GET	/api/v2/meta/workspaces	conn_mod_def::GLTrkt_ecDA::JQ-p-DJcQfCpuhVeHbGhIQ
Read Workspace	GET	/api/v2/meta/workspaces/{{workspaceId}}	conn_mod_def::GLTrkcMdTDg::w5voYMlNQKuyuRhCwdWoOQ
Create Workspaces	POST	/api/v2/meta/workspaces	conn_mod_def::GLTrkcVRI_g::NxsDb63VSp6pkcu1aEHhHg
Delete Workspace	DELETE	/api/v2/meta/workspaces/{{workspaceId}}	conn_mod_def::GLTrkcL5n2g::xM6aIsvMQNO70gCwHHkLYA
Update Workspace	PATCH	/api/v2/meta/workspaces/{{workspaceId}}	conn_mod_def::GLTrk1hdGkg::kfTKrN1nRLSEoMk-YdTS_Q

SharedBase

Action	Method	Path	Action id
Get a Base's Shared Base	GET	/api/v2/meta/bases/{{baseId}}/shared	conn_mod_def::GLTrfxPkoOg::NrXD8qhtRLKIypbdscrq4w
Create a Shared Base for a Base	POST	/api/v2/meta/bases/{{baseId}}/shared	conn_mod_def::GLTrfg4OpSA::_f0xU9GNQlS56aJPRmZUtA
Delete a Base's Shared Base	DELETE	/api/v2/meta/bases/{{baseId}}/shared	conn_mod_def::GLTrfqBZ4MA::5O4OSVHRTTCnBZ8W4fPgpg
Update a Base's Shared Base	PATCH	/api/v2/meta/bases/{{baseId}}/shared	conn_mod_def::GLTrf-0EsHA::QDQl2Pn9SA-TxnGTFbn70Q

WorkspaceUsers

Action	Method	Path	Action id
List a Workspace's Users	GET	/api/v2/meta/workspaces/{{workspaceId}}/users	conn_mod_def::GLTrlNh0-8g::dGTJHhWdSc-6T6l3M7648w
Read a Workspace User	GET	/api/v2/meta/workspaces/{{workspaceId}}/users/{{userId}}	conn_mod_def::GLTrk1WlvpA::eoU9W_6GQp6SqFbB9h9Uow
Delete a Workspace User	DELETE	/api/v2/meta/workspaces/{{workspaceId}}/users/{{userId}}	conn_mod_def::GLTrk-kOh8A::QQ7qYIp1R76liYiiRqsRmA
Update Workspace User	PATCH	/api/v2/meta/workspaces/{{workspaceId}}/users/{{userId}}	conn_mod_def::GLTrk3B9pZg::-aI0MqjyQ_q_ZCKwzFmcxQ

Comments

Action	Method	Path	Action id
Count Comments	GET	/meta/comments/count	conn_mod_def::GLTrkMAt2kg::2p-w32gwTI-Ywqi7oEiZ-w
List Comments	GET	/api/v2/meta/comments	conn_mod_def::GLTrkToVHOA::SvDymNOfQfet9EDSUIGOHA
Add Comment	POST	/api/v2/meta/comments	conn_mod_def::GLTrkLx26OA::u_lOoTdWR_mXyEcrE2LYUw
Update Comment	PATCH	/api/v2/meta/comment/{{commentId}}	conn_mod_def::GLTrkef7bGA::qfwmO3smTeWbRBLRQI58qg

ApiTokens

Action	Method	Path	Action id
List API Tokens in a Base	GET	/api/v2/meta/bases/{{baseId}}/api-tokens	conn_mod_def::GLTre_7NiIA::H1k5k9CwQoGMsv3amjGVtg
Create API Token in a Base	POST	/api/v2/meta/bases/{{baseId}}/api-tokens	conn_mod_def::GLTrfATN2WA::StzwtEW3RoKraENfTvyOeg
Delete API Token in a Base	DELETE	/api/v2/meta/bases/{{baseId}}/api-tokens/{{tokenId}}	conn_mod_def::GLTre_FkkKg::kd24_gSsTpeGWJd9GSHwJg

Filters

Action	Method	Path	Action id
Get Filter Metadata	GET	/api/v2/meta/filters/{{filterId}}	conn_mod_def::GLTrgqi12BA::c4Op_mNlRROOKvvTC9hQSQ
Delete Filter	DELETE	/api/v2/meta/filters/{{filterId}}	conn_mod_def::GLTrgdv2KgA::l313nOAvSlaTQsqFTc7vCA
Update Filter	PATCH	/api/v2/meta/filters/{{filterId}}	conn_mod_def::GLTrgm4x4Pg::f1GbdNUcSE6MRC6wqCiMXQ

Kanbans

Action	Method	Path	Action id
Get Kanban View Metadata	GET	/api/v2/meta/kanbans/{{kanbanViewId}}	conn_mod_def::GLTrhg7A0Pg::Rvt-YJasQWGQ-mn7wrL3FQ
Create Kanban View for a Table	POST	/api/v2/meta/tables/{{tableId}}/kanbans	conn_mod_def::GLTrhZSYQ4g::KRFY1V-ZR9iEfHm9rD_dkA
Update Kanban View	PATCH	/api/v2/meta/kanbans/{{kanbanViewId}}	conn_mod_def::GLTrh6MjkTA::CoMNEtUFR8-uV2jo8LX0RQ

Sources

Action	Method	Path	Action id
List Sources for a Base	GET	/api/v2/meta/bases/{{baseId}}/sources/	conn_mod_def::GLTrjnAWt-g::t6Dfxo28T8Og6-0wIPeNzg
Create a Source for a Base	POST	/api/v2/meta/bases/{{baseId}}/sources/	conn_mod_def::GLTrjZD2yMg::ah4k0YOaTLKAEOcjwO_Irg
Disable Share Erd for a Source in a Base	DELETE	/api/v2/meta/bases/{{baseId}}/sources/{{sourceId}}/share/erd	conn_mod_def::GLTrjwiRelg::7sDIKPXjRXSMC1Il0nLPkw

BaseUsers

Action	Method	Path	Action id
List Base Users	GET	/api/v2/meta/bases/{{baseId}}/users	conn_mod_def::GLTrfIFy7_A::zql40MyYRFyFpFCh83DZEQ
Resend Invite for a Base User	POST	/api/v2/meta/bases/{{baseId}}/users/{{userId}}/resend-invite	conn_mod_def::GLTrfQzuWZg::_td9f2ggS8OBYtRASnmZig
Update a Base User	PATCH	/api/v2/meta/bases/{{baseId}}/users/{{userId}}	conn_mod_def::GLTrfZLqL2g::O71-WNfsQZGEx1elCmDiKA

BaseUser

Action	Method	Path	Action id
Create Base User	POST	/api/v2/meta/bases/{{baseId}}/users	conn_mod_def::GLTrfAdTlfg::l6qZg4cGTsKlghwfAKPB1g
Delete a Base User	DELETE	/api/v2/meta/bases/{{baseId}}/users/{{userId}}	conn_mod_def::GLTrfH4CZfg::I8b5Ohl-Qwy-l_nxF_1vZQ

ViewFilters

Action	Method	Path	Action id
List View Filters	GET	/api/v2/meta/views/{{viewId}}/filters	conn_mod_def::GLTrgnL5GYA::UWDMAx1hS8CqN4AfsG0ArQ
Create View Filter	POST	/api/v2/meta/views/{{viewId}}/filters	conn_mod_def::GLTrgfDzEtg::YwvQPohfRTOzRjcAL4fO_g

HookFilters

Action	Method	Path	Action id
Get Hook Filters	GET	/api/v2/meta/hooks/{{hookId}}/filters	conn_mod_def::GLTrhFJTynA::WvoZ-y9zQN6CzmNlWsULjQ
Create Hook Filters for a Hook	POST	/api/v2/meta/hooks/{{hookId}}/filters	conn_mod_def::GLTrg7Ik0Ug::5C4rhhHhQdulsGzk2fT5Hg

ViewSorts

Action	Method	Path	Action id
List View Sorts	GET	/api/v2/meta/views/{{viewId}}/sorts	conn_mod_def::GLTrgzEksYA::Dl_d7XXaSbCHc-P-0UA_YA
Create View Sort for a View	POST	/api/v2/meta/views/{{viewId}}/sorts	conn_mod_def::GLTrgnQdgPg::7K3BzBnLSyGWUJeSYUBi0Q

ViewColumns

Action	Method	Path	Action id
List View Columns	GET	/api/v2/meta/views/{{viewId}}/columns	conn_mod_def::GLTriCHfwCA::1c9xDxdiRJaReOC8wpwzJw
Create Column in View	POST	/api/v2/meta/views/{{viewId}}/columns	conn_mod_def::GLTrh5Ta74g::4lPPzm78S8eZIv733Xx8qQ

SharedView

Action	Method	Path	Action id
Create Shared View for a View	POST	/api/v2/meta/views/{{viewId}}/share	conn_mod_def::GLTriCEkuTg::BJ9HGzyAQsmGc2QCJdcSNA
Update Shared View	PATCH	/api/v2/meta/views/{{viewId}}/share	conn_mod_def::GLTriVKr7vg::5g4ekNXzQ2qTvc_8StSykw

SharedViews

Action	Method	Path	Action id
List Shared Views for a Table	GET	/api/v2/meta/tables/{{tableId}}/share	conn_mod_def::GLTriCMyV9A::w8I15CAcQruKRPLmJWhO2g
Delete a Shared View	DELETE	/api/v2/meta/views/{{viewId}}/share	conn_mod_def::GLTriCE1bpA::5afxL0_ZR8miEEYwL-SOYQ

Sorts

Action	Method	Path	Action id
Delete Sort	DELETE	/api/v2/meta/sorts/{{sortId}}	conn_mod_def::GLTrgnbkQhg::-urvK5gcQvC0csd7GXEbpA

1 more Sorts actions are available through search.

This lists 90 of 167 actions. For anything not here, call search_one_platform_actions with platform nocodb. The full catalog is at https://www.withone.ai/knowledge/nocodb.

When a call fails

The error comes from NocoDB, not from One. A 400 or 422 means your parameters do not match the schema, so re-read the knowledge and fix the field. A 401 or 403 means the connection needs re-authorizing, which no retry will fix. A 404 means the id is not on this account. A 429 means slow down. Never retry a write more than once: the first attempt may have landed.

Full catalog: https://www.withone.ai/knowledge/nocodb

Integration knowledge by One (withone.ai), licensed under One-Knowledge-1.0. Attribution must be preserved in derivative works.