Can I use NocoDB as a CLI?

Yes. KosmoKrator exposes a NocoDB CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose NocoDB through MCP?

Yes. The KosmoKrator MCP gateway can expose selected NocoDB tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are NocoDB credentials stored?

NocoDB credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for NocoDB MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

productivity

NocoDB CLI for AI Agents

Use the NocoDB CLI from KosmoKrator to call NocoDB tools headlessly, return JSON, inspect schemas, and automate workflows from coding agents, scripts, and CI.

15 functions 8 read 7 write API token auth

Submit NocoDB feedback View package source

NocoDB CLI Setup

NocoDB can be configured headlessly with `kosmokrator integrations:configure nocodb`.

# Install KosmoKrator first if it is not available on PATH.
curl -fsSL https://raw.githubusercontent.com/OpenCompanyApp/kosmokrator/main/install.sh | bash

# Configure and verify this integration.
kosmokrator integrations:configure nocodb --set api_token="$NOCODB_API_TOKEN" --set base_url="$NOCODB_BASE_URL" --enable --read allow --write ask --json
kosmokrator integrations:doctor nocodb --json
kosmokrator integrations:status --json

Credentials

Authentication type: API token api_token. Configure credentials once, then use the same stored profile from scripts, coding CLIs, Lua code mode, and the MCP gateway.

Key	Env var	Type	Required	Label
`api_token`	`NOCODB_API_TOKEN`	Secret `secret`	yes	API Token
`base_url`	`NOCODB_BASE_URL`	Text `text`	yes	Base URL

Call NocoDB Headlessly

Use the generic call form when another coding CLI or script needs a stable universal interface.

kosmo integrations:call nocodb.nocodb_list_records '{
  "table_id": "example_table_id",
  "view_id": "example_view_id",
  "limit": 1,
  "offset": 1,
  "where": "example_where",
  "sort": "example_sort",
  "fields": "example_fields"
}' --json

Use the provider shortcut form for shorter human-facing commands.

kosmo integrations:nocodb nocodb_list_records '{
  "table_id": "example_table_id",
  "view_id": "example_view_id",
  "limit": 1,
  "offset": 1,
  "where": "example_where",
  "sort": "example_sort",
  "fields": "example_fields"
}' --json

Agent Discovery Commands

These commands return structured output for coding agents that need to inspect capabilities before choosing a function.

kosmo integrations:docs nocodb --json
kosmo integrations:docs nocodb.nocodb_list_records --json
kosmo integrations:schema nocodb.nocodb_list_records --json
kosmo integrations:search "NocoDB" --json
kosmo integrations:list --json

All CLI Functions

Every function below can be called headlessly. The generic form is stable across all integrations; the provider shortcut is shorter but specific to NocoDB.

`nocodb.nocodb_list_records`

Read read

List records from a NocoDB table with optional filtering, sorting, and pagination.

Parameters: table_id, view_id, limit, offset, where, sort, fields

Generic CLI call

kosmo integrations:call nocodb.nocodb_list_records '{"table_id":"example_table_id","view_id":"example_view_id","limit":1,"offset":1,"where":"example_where","sort":"example_sort","fields":"example_fields"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_list_records '{"table_id":"example_table_id","view_id":"example_view_id","limit":1,"offset":1,"where":"example_where","sort":"example_sort","fields":"example_fields"}' --json

`nocodb.nocodb_get_record`

Read read

Get a single NocoDB record by ID.

Parameters: table_id, record_id, fields

Generic CLI call

kosmo integrations:call nocodb.nocodb_get_record '{"table_id":"example_table_id","record_id":"example_record_id","fields":"example_fields"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_get_record '{"table_id":"example_table_id","record_id":"example_record_id","fields":"example_fields"}' --json

`nocodb.nocodb_create_record`

Write write

Create a new record in a NocoDB table.

Parameters: table_id, data

Generic CLI call

kosmo integrations:call nocodb.nocodb_create_record '{"table_id":"example_table_id","data":"example_data"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_create_record '{"table_id":"example_table_id","data":"example_data"}' --json

`nocodb.nocodb_update_record`

Write write

Update an existing NocoDB record.

Parameters: table_id, record_id, data

Generic CLI call

kosmo integrations:call nocodb.nocodb_update_record '{"table_id":"example_table_id","record_id":"example_record_id","data":"example_data"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_update_record '{"table_id":"example_table_id","record_id":"example_record_id","data":"example_data"}' --json

`nocodb.nocodb_delete_record`

Write write

Delete a record from a NocoDB table.

Parameters: table_id, record_id

Generic CLI call

kosmo integrations:call nocodb.nocodb_delete_record '{"table_id":"example_table_id","record_id":"example_record_id"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_delete_record '{"table_id":"example_table_id","record_id":"example_record_id"}' --json

`nocodb.nocodb_batch_create`

Write write

Create multiple records in a single NocoDB API request.

Parameters: table_id, records

Generic CLI call

kosmo integrations:call nocodb.nocodb_batch_create '{"table_id":"example_table_id","records":"example_records"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_batch_create '{"table_id":"example_table_id","records":"example_records"}' --json

`nocodb.nocodb_batch_update`

Write write

Update multiple records in a single NocoDB API request.

Parameters: table_id, records

Generic CLI call

kosmo integrations:call nocodb.nocodb_batch_update '{"table_id":"example_table_id","records":"example_records"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_batch_update '{"table_id":"example_table_id","records":"example_records"}' --json

`nocodb.nocodb_batch_delete`

Write write

Delete multiple records in a single NocoDB API request.

Parameters: table_id, record_ids

Generic CLI call

kosmo integrations:call nocodb.nocodb_batch_delete '{"table_id":"example_table_id","record_ids":"example_record_ids"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_batch_delete '{"table_id":"example_table_id","record_ids":"example_record_ids"}' --json

`nocodb.nocodb_list_bases`

Read read

List all NocoDB bases the token has access to.

Parameters: none

Generic CLI call

kosmo integrations:call nocodb.nocodb_list_bases '{}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_list_bases '{}' --json

`nocodb.nocodb_get_base`

Read read

Get details of a single NocoDB base.

Parameters: base_id

Generic CLI call

kosmo integrations:call nocodb.nocodb_get_base '{"base_id":"example_base_id"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_get_base '{"base_id":"example_base_id"}' --json

`nocodb.nocodb_list_tables`

Read read

List all tables in a NocoDB base.

Parameters: base_id

Generic CLI call

kosmo integrations:call nocodb.nocodb_list_tables '{"base_id":"example_base_id"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_list_tables '{"base_id":"example_base_id"}' --json

`nocodb.nocodb_get_table`

Read read

Get details of a single NocoDB table.

Parameters: table_id

Generic CLI call

kosmo integrations:call nocodb.nocodb_get_table '{"table_id":"example_table_id"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_get_table '{"table_id":"example_table_id"}' --json

`nocodb.nocodb_create_table`

Write write

Create a new table in a NocoDB base.

Parameters: base_id, table_name, columns

Generic CLI call

kosmo integrations:call nocodb.nocodb_create_table '{"base_id":"example_base_id","table_name":"example_table_name","columns":"example_columns"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_create_table '{"base_id":"example_base_id","table_name":"example_table_name","columns":"example_columns"}' --json

`nocodb.nocodb_list_views`

Read read

List views for a NocoDB table.

Parameters: table_id

Generic CLI call

kosmo integrations:call nocodb.nocodb_list_views '{"table_id":"example_table_id"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_list_views '{"table_id":"example_table_id"}' --json

`nocodb.nocodb_count_records`

Read read

Count records in a NocoDB table with optional filtering.

Parameters: table_id, where

Generic CLI call

kosmo integrations:call nocodb.nocodb_count_records '{"table_id":"example_table_id","where":"example_where"}' --json

Provider shortcut

kosmo integrations:nocodb nocodb_count_records '{"table_id":"example_table_id","where":"example_where"}' --json

Function Schemas

Use these parameter tables when building CLI payloads without calling integrations:schema first.

`nocodb.nocodb_list_records`

List records from a NocoDB table with optional filtering, sorting, and pagination.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_list_records --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`view_id`	string	no	View ID to filter records by the view's filters.
`limit`	integer	no	Maximum number of records to return (default 25).
`offset`	integer	no	Pagination offset for skipping records.
`where`	string	no	NocoDB where clause for filtering (e.g., "(Status,eq,Done)").
`sort`	string	no	JSON array of sort objects, e.g. [{"field":"Name","direction":"asc"}].
`fields`	string	no	Comma-separated list of field names to return.

`nocodb.nocodb_get_record`

Get a single NocoDB record by ID.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_get_record --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`record_id`	string	yes	Record ID.
`fields`	string	no	Comma-separated list of field names to return.

`nocodb.nocodb_create_record`

Create a new record in a NocoDB table.

Operation: Write write
Schema command: kosmo integrations:schema nocodb.nocodb_create_record --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`data`	string	yes	JSON object of field name → value pairs (e.g., {"Name":"John","Age":30}).

`nocodb.nocodb_update_record`

Update an existing NocoDB record.

Operation: Write write
Schema command: kosmo integrations:schema nocodb.nocodb_update_record --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`record_id`	string	yes	Record ID.
`data`	string	yes	JSON object of field name → value pairs to update (e.g., {"Status":"Done"}).

`nocodb.nocodb_delete_record`

Delete a record from a NocoDB table.

Operation: Write write
Schema command: kosmo integrations:schema nocodb.nocodb_delete_record --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`record_id`	string	yes	Record ID.

`nocodb.nocodb_batch_create`

Create multiple records in a single NocoDB API request.

Operation: Write write
Schema command: kosmo integrations:schema nocodb.nocodb_batch_create --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`records`	string	yes	JSON array of record objects (e.g., [{"Name":"Alice"},{"Name":"Bob"}]).

`nocodb.nocodb_batch_update`

Update multiple records in a single NocoDB API request.

Operation: Write write
Schema command: kosmo integrations:schema nocodb.nocodb_batch_update --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`records`	string	yes	JSON array of record objects, each with an "Id" key and fields to update (e.g., [{"Id":1,"Name":"Updated"}]).

`nocodb.nocodb_batch_delete`

Delete multiple records in a single NocoDB API request.

Operation: Write write
Schema command: kosmo integrations:schema nocodb.nocodb_batch_delete --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`record_ids`	string	yes	JSON array of record IDs to delete (e.g., [1, 2, 3]).

`nocodb.nocodb_list_bases`

List all NocoDB bases the token has access to.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_list_bases --json

Parameter	Type	Required	Description
No parameters.

`nocodb.nocodb_get_base`

Get details of a single NocoDB base.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_get_base --json

Parameter	Type	Required	Description
`base_id`	string	yes	Base ID.

`nocodb.nocodb_list_tables`

List all tables in a NocoDB base.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_list_tables --json

Parameter	Type	Required	Description
`base_id`	string	yes	Base ID.

`nocodb.nocodb_get_table`

Get details of a single NocoDB table.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_get_table --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.

`nocodb.nocodb_create_table`

Create a new table in a NocoDB base.

Operation: Write write
Schema command: kosmo integrations:schema nocodb.nocodb_create_table --json

Parameter	Type	Required	Description
`base_id`	string	yes	Base ID.
`table_name`	string	yes	Name for the new table.
`columns`	string	yes	JSON array of column definitions (e.g., [{"column_name":"Name","uidt":"SingleLineText"},{"column_name":"Age","uidt":"Number"}]).

`nocodb.nocodb_list_views`

List views for a NocoDB table.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_list_views --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.

`nocodb.nocodb_count_records`

Count records in a NocoDB table with optional filtering.

Operation: Read read
Schema command: kosmo integrations:schema nocodb.nocodb_count_records --json

Parameter	Type	Required	Description
`table_id`	string	yes	Table ID.
`where`	string	no	NocoDB where clause for filtering (e.g., "(Status,eq,Done)").

Permissions

Headless calls still follow the integration read/write permission policy. Configure read/write defaults with integrations:configure. Add --force only for trusted automation that should bypass that policy.