Connect NocoDB to Your AI Agent

Read table schemas and filtered records, create or update records, and upsert records by matching fields. Ask your connected AI assistant to explain the results or carry out the specified operation.

24 tools API key

Try a NocoDB Task

Copy a prompt into your agent with the oo Skill installed. Add your page links and source notes before running it.

oo Skill NocoDB

Summarize a Record Set

Read table metadata and filtered records for a grounded summary.

/oo NocoDB: Read NocoDB table [table ID] metadata, then list records in base [base ID] matching [where expression] and summarize the returned rows.

Apply Specified Row Updates

Use row IDs and supplied values to update selected records.

/oo NocoDB: For NocoDB base [base ID], table [table ID], update records [record IDs] with only these field values: [values].

Merge Imported Records

Create or update supplied rows by matching explicitly chosen fields.

/oo NocoDB: Upsert these records [records] into NocoDB base [base ID], table [table ID], matching on fields [field IDs].

Start Working with NocoDB

  1. Install OOMOL

    Set up oo CLI and the oo Skill in your agent.

    Install OOMOL →
  2. Connect NocoDB

    Provide a NocoDB API token and cloud or public self-hosted instance URL.

    Connect NocoDB →
  3. Give Your Agent a Task

    Use /oo with the pages to read, the changes to make, and where to save the result.

    Connection Guide →

Choose Your Agent

  • A cloud or publicly reachable NocoDB instance and an authorized API token.
  • Use table metadata to select valid fields. v3 record operations require both base and table IDs.

NocoDB Tools

NocoDB connects supported service operations to your AI assistant. Read table schemas and filtered records, create or update records, and upsert records by matching fields.

Schema and Records

Read table metadata, filtered record lists, and record counts.

Record Writes

Create, update, and upsert v3 table records.

Table Structure

Create tables, views, and fields with explicit definitions.

24 tools

Get Current User

Get the NocoDB user associated with the connected API token.

nocodb.get_current_user

List Bases

List bases visible to the connected NocoDB API token.

nocodb.list_bases

Get Base Schema

Get schema metadata for one NocoDB base.

nocodb.get_base_schema

List Tables

List tables in a NocoDB base or in a specific base source.

nocodb.list_tables

Create Table

Create a table in a NocoDB base using the v3 metadata API.

nocodb.create_table

Get Table Metadata

Get metadata for one NocoDB table, including columns and views when available.

nocodb.get_table_metadata

Update Table

Update a NocoDB table title, description, display field, or metadata using the v3 metadata API.

nocodb.update_table

Delete Table

Delete a NocoDB table using the v3 metadata API.

nocodb.delete_table

List Table Views

List views for a NocoDB table using the v3 metadata API.

nocodb.list_table_views

Create Table View

Create a view for a NocoDB table using the v3 metadata API.

nocodb.create_table_view

Create Table Field

Create a field in a NocoDB table using the v3 metadata API.

nocodb.create_table_field

List Records

List records from one NocoDB table with optional where, sort, field, limit, and offset query parameters.

nocodb.list_records

Count Records

Count records in one NocoDB table, optionally filtered by a where expression.

nocodb.count_records

Read Record

Read one record from a NocoDB table by record ID.

nocodb.read_record

Create Records

Create one or more records in a NocoDB table.

nocodb.create_records

Update Records

Update one or more records in a NocoDB table.

nocodb.update_records

Delete Records

Delete one or more records from a NocoDB table.

nocodb.delete_records

List Table Records

List records from one NocoDB table using the v3 data API with optional field, sort, filter, page, and view parameters.

nocodb.list_table_records

Count Table Records

Count records in one NocoDB table using the v3 data API.

nocodb.count_table_records

Read Table Record

Read one record from a NocoDB table using the v3 data API.

nocodb.read_table_record

Create Table Records

Create one or more records in a NocoDB table using the v3 data API.

nocodb.create_table_records

Update Table Records

Update one or more records in a NocoDB table using the v3 data API.

nocodb.update_table_records

Delete Table Records

Delete one or more records from a NocoDB table using the v3 data API.

nocodb.delete_table_records

Upsert Table Records

Create or update records in a NocoDB table by matching up to three fields using the v3 data API.

nocodb.upsert_table_records

Frequently Asked Questions

How does AI know the field names?

Read table metadata first and use the returned field definitions when constructing queries or writes.

Can I update an existing record instead of adding a duplicate?

Use record updates with known IDs, or upsert with up to three explicit matching fields.

Will a list request return the whole table?

Record lists are paginated. Continue pages or compare a filtered count before treating the returned rows as complete.

Connect NocoDB

About NocoDB ↗