productivity
NocoDB CLI for CI
Use the NocoDB CLI for CI with headless JSON commands, schema discovery, credentials, and permission controls.
15 functions 8 read 7 write API token auth
NocoDB CLI for CI
Run integration calls from CI jobs with JSON output, explicit credentials, and predictable exit status.
Use this shape when a pipeline needs to read or update an external service. 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 CI
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.