NocoDB

NocoDB (nocodb.com). Use this skill for ANY NocoDB request — reading, creating, updating, and deleting data. Whenever a task involves NocoDB, use this skill instead of calling the API directly.

Operate NocoDB through your OOMOL-connected account. This skill calls the nocodb connector with the oo CLI; OOMOL injects credentials server-side, so you never handle raw tokens.

Category: Data & Analytics, Productivity. Exposes 24 action(s).

Running an action

Assume the user has already installed the oo CLI, signed in, and connected NocoDB. Do not run oo auth login or open the connection URL proactively — just run the action. Fall back to First-time setup only when a command actually fails with an auth or connection error.

1. Inspect the contract to get the authoritative input/output schema before building a payload:

oo connector schema "nocodb" --action "<action_name>"

2. Run the action with a JSON payload that matches the input schema:

oo connector run "nocodb" --action "<action_name>" --data '<json>' --json

• --data takes a JSON object string or @path/to/file.json; omit it to send {}.
• The response is { "data": ..., "meta": { "executionId": "..." } }; the execution id lives under meta.executionId.

Each action below links to a reference file with its purpose and exact commands. Read the linked file, then fetch the live schema with oo connector schema before constructing --data.

Available actions

• count_records — Count records in one NocoDB table, optionally filtered by a where expression.
• count_table_records — Count records in one NocoDB table using the v3 data API.
• create_records — Create one or more records in a NocoDB table.
• create_table — Create a table in a NocoDB base using the v3 metadata API.
• create_table_field — Create a field in a NocoDB table using the v3 metadata API.
• create_table_records — Create one or more records in a NocoDB table using the v3 data API.
• create_table_view — Create a view for a NocoDB table using the v3 metadata API.
• delete_records — Delete one or more records from a NocoDB table.
• delete_table — Delete a NocoDB table using the v3 metadata API.
• delete_table_records — Delete one or more records from a NocoDB table using the v3 data API.
• get_base_schema — Get schema metadata for one NocoDB base.
• get_current_user — Get the NocoDB user associated with the connected API token.
• get_table_metadata — Get metadata for one NocoDB table, including columns and views when available.
• list_bases — List bases visible to the connected NocoDB API token.
• list_records — List records from one NocoDB table with optional where, sort, field, limit, and offset query parameters.
• list_table_records — List records from one NocoDB table using the v3 data API with optional field, sort, filter, page, and view parameters.
• list_table_views — List views for a NocoDB table using the v3 metadata API.
• list_tables — List tables in a NocoDB base or in a specific base source.
• read_record — Read one record from a NocoDB table by record ID.
• read_table_record — Read one record from a NocoDB table using the v3 data API.
• update_records — Update one or more records in a NocoDB table.
• update_table — Update a NocoDB table title, description, display field, or metadata using the v3 metadata API.
• update_table_records — Update one or more records in a NocoDB table using the v3 data API.
• upsert_table_records — Create or update records in a NocoDB table by matching up to three fields using the v3 data API.

Safety

• Read actions (get / list / search) are safe to run directly.
• Create, update, send, or post actions change NocoDB state — confirm the exact payload and effect with the user before running.
• Delete or remove actions are destructive — always confirm the target and get explicit approval first.

First-time setup

These are one-time steps — do not repeat them on every call. Run a step only when a command fails for the matching reason.

• oo: command not found — install the oo CLI (other platforms: https://cli.oomol.com/install-guide.md):

  curl -fsSL https://cli.oomol.com/install.sh | bash    # macOS / Linux
  

  irm https://cli.oomol.com/install.ps1 | iex           # Windows PowerShell
  

• Not signed in / authentication error — sign in to your OOMOL account once:

  oo auth login
  

• scope_missing / credential_expired / app_not_ready / app_not_found — NocoDB is not connected, or the connection expired or lacks a scope. Connect once (auth type: API key) at:

  https://console.oomol.com/app-connections?provider=nocodb
  

• HTTP 402 / OOMOL_INSUFFICIENT_CREDIT — billing stop. Recharge at https://console.oomol.com/billing/token-recharge before retrying.

Resources

• NocoDB homepage: https://nocodb.com