productivity
NocoDB CLI for Headless Automation
Use the NocoDB CLI for headless automation with headless JSON commands, schema discovery, credentials, and permission controls.
15 functions 8 read 7 write API token auth
NocoDB CLI for Headless Automation
Use KosmoKrator as a non-interactive integration runtime for local automations and wrappers.
Use headless automation when another tool needs a stable local command surface. The NocoDB CLI uses the same integration registry as the TUI, Lua runtime, and MCP gateway, but returns predictable command output for automation.
Command Shape
# NocoDB CLI for Headless Automation
kosmokrator integrations:configure nocodb --set api_token="$NOCODB_API_TOKEN" --set base_url="$NOCODB_BASE_URL" --enable --read allow --write ask --json
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"}' --jsonDiscovery Before Execution
Agents and scripts can inspect NocoDB docs and schemas 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 --jsonUseful NocoDB CLI Functions
| Function | Type | Parameters | Description |
|---|---|---|---|
nocodb.nocodb_list_records | Read | table_id, view_id, limit, offset, where, sort, fields | List records from a NocoDB table with optional filtering, sorting, and pagination. |
nocodb.nocodb_get_record | Read | table_id, record_id, fields | Get a single NocoDB record by ID. |
nocodb.nocodb_create_record | Write | table_id, data | Create a new record in a NocoDB table. |
nocodb.nocodb_update_record | Write | table_id, record_id, data | Update an existing NocoDB record. |
nocodb.nocodb_delete_record | Write | table_id, record_id | Delete a record from a NocoDB table. |
nocodb.nocodb_batch_create | Write | table_id, records | Create multiple records in a single NocoDB API request. |
nocodb.nocodb_batch_update | Write | table_id, records | Update multiple records in a single NocoDB API request. |
nocodb.nocodb_batch_delete | Write | table_id, record_ids | Delete multiple records in a single NocoDB API request. |
nocodb.nocodb_list_bases | Read | none | List all NocoDB bases the token has access to. |
nocodb.nocodb_get_base | Read | base_id | Get details of a single NocoDB base. |
nocodb.nocodb_list_tables | Read | base_id | List all tables in a NocoDB base. |
nocodb.nocodb_get_table | Read | table_id | Get details of a single NocoDB table. |
nocodb.nocodb_create_table | Write | base_id, table_name, columns | Create a new table in a NocoDB base. |
nocodb.nocodb_list_views | Read | table_id | List views for a NocoDB table. |
nocodb.nocodb_count_records | Read | table_id, where | Count records in a NocoDB table with optional filtering. |
Automation Notes
- Use
--jsonfor machine-readable output. - Keep credentials out of argv by using environment variables or stored KosmoKrator configuration.
- Configure read/write policy before unattended runs; use
--forceonly for trusted automation. - Use the MCP gateway instead when the agent needs dynamic tool discovery inside a conversation.