Connect NocoDB to Your AI Agent

Keep shared tables current without re-entering the same information.

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 Table Records

Filter records and summarize the information relevant to your question.

/oo NocoDB: Read [base and table] and summarize records matching [conditions]. Explain the fields used in your summary.

Update Selected Records

Apply the specific field changes you provide to selected rows.

/oo NocoDB: In [base and table], update the selected records with [changes]. Keep other fields unchanged.

Merge Imported Records

Create or update supplied rows by matching explicitly chosen fields.

/oo NocoDB: Merge these records into [base and table], matching on [up to three fields]. Update matching rows and create rows for new entries.

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.
  • Specify the base and table you want to work with. The assistant can read their fields before editing records.

NocoDB Tools

Inspect table structures, filter records, edit selected rows, and merge imports by up to three matching fields. Large result sets may require multiple batches.

Table Structure and Records

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

Record Writes

Create records, edit selected rows, or merge data by matching fields.

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

Can I avoid duplicate rows when importing?

Yes. Choose up to three fields that identify matching records so existing rows can be updated.

Can the assistant learn the table’s fields?

Yes. It can read the table’s structure before filtering or organizing records.

Will a summary include the whole table?

Large tables are read in batches. Specify the scope and ask the assistant to state how much it reviewed.

Connect NocoDB

About NocoDB ↗