productivity
NocoDB CLI for Shell Scripts
Use the NocoDB CLI for shell scripts with headless JSON commands, schema discovery, credentials, and permission controls.
15 functions 8 read 7 write API token auth
NocoDB CLI for Shell Scripts
Call integration functions from shell scripts with stable JSON input and output.
Use shell scripts for small local automations that need one or more integration calls. 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 Shell Scripts
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"}' --json Discovery 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 --json Useful 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.