> For the complete documentation index, see [llms.txt](https://docs.stackai.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.stackai.com/integrations/catalog/nocodb.md).

# NocoDB

Connect to NocoDB Cloud or a self-hosted NocoDB instance to create, list, update, and delete records, and create new tables in your bases.

### Connectors

Choose the connector that matches your authentication method. The options below use the names shown in StackAI.

| Connector | Authentication |
| --------- | -------------- |
| NocoDB    | API Token      |

#### NocoDB

Connect to NocoDB Cloud or a self-hosted NocoDB instance with an API token to create, list, update, and delete records, and manage tables in your bases.

**Set up in NocoDB**

1. Prepare the NocoDB account or service that the workflow will access. Grant access to the required resources and operations.
2. **API Token:** Create a token at Account Settings > API Tokens, and grant it the bases you want plus the Records permission category. Add Tables and Fields too if you'll use Create Table.

**Set up in StackAI**

1. Open **Settings → Connections**, add a connection, and select **NocoDB**.
2. Enter the credentials and connection details in the fields below.
3. Save the connection and check its connection status. Select this saved connection when configuring an action or feature that uses it.

**Connection fields**

| StackAI field | Required                 | What to enter                                                                                                                                                                                                                                                      |
| ------------- | ------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| API Token     | Yes                      | Create a token at Account Settings > API Tokens, and grant it the bases you want plus the Records permission category. Add Tables and Fields too if you'll use Create Table. [Provider instructions](https://nocodb.com/docs/product/account-settings/api-tokens). |
| Server URL    | Optional / as applicable | Only needed for a self-hosted NocoDB instance; leave the default for NocoDB Cloud.                                                                                                                                                                                 |

#### Verify the connection

Check that the connection is healthy. Then run a read operation against a resource the connected account can access. A successful connection check confirms authentication; it does not guarantee permission for every action.

If access is denied, check the credential or OAuth permissions, the selected account or environment, and access to the specific resource. Update expired credentials or reconnect after permissions change.

### Use an action

1. Add the required **NocoDB** action to the workflow.
2. Select a connection when the action requests one.
3. Complete the required fields. Use the reference picker when a value comes from another workflow step.
4. Run the workflow and inspect the action’s output. Check the result before using it in a later step.

### Actions

#### List Bases

List the NocoDB bases your API token can access, across all your workspaces.

**Inputs**

No input fields are required in this catalog entry.

**Outputs**

| Field | Type          | Description               |
| ----- | ------------- | ------------------------- |
| Bases | object\_array | The bases you can access. |

#### List Tables

List the tables in a NocoDB base.

**Inputs**

| Field | Type            | Required | Description                                                                       |
| ----- | --------------- | -------- | --------------------------------------------------------------------------------- |
| Base  | select (string) | Yes      | The base whose tables you want to see. Options load from the selected connection. |

**Outputs**

| Field  | Type          | Description             |
| ------ | ------------- | ----------------------- |
| Tables | object\_array | The tables in the base. |

#### Get Table Fields

See the fields (columns) of a table and their types.

**Inputs**

| Field | Type            | Required | Description                                                                        |
| ----- | --------------- | -------- | ---------------------------------------------------------------------------------- |
| Base  | select (string) | Yes      | The base that holds the table. Options load from the selected connection.          |
| Table | select (string) | Yes      | The table whose fields you want to see. Options load from the selected connection. |

**Outputs**

| Field      | Type          | Description                         |
| ---------- | ------------- | ----------------------------------- |
| Table name | string        | The table's name.                   |
| Fields     | object\_array | The table's fields and their types. |

#### List Records

Find records in a table, with optional filtering and sorting.

**Inputs**

| Field            | Type            | Required | Description                                                                          |
| ---------------- | --------------- | -------- | ------------------------------------------------------------------------------------ |
| Base             | select (string) | Yes      | The base that holds the table. Options load from the selected connection.            |
| Table            | select (string) | Yes      | The table to read records from. Options load from the selected connection.           |
| Filter           | string          | No       | Only return records matching this filter.                                            |
| Sort by          | string          | No       | Field to sort results by.                                                            |
| Sort direction   | select (string) | No       | Sort ascending or descending. Available values: Ascending, Descending. Default: asc. |
| View             | select (string) | No       | Only return records visible in this view. Options load from the selected connection. |
| Fields to return | string          | No       | Comma-separated field names to include. Leave empty for all.                         |
| Max results      | integer         | No       | Returns about this many records at most. Minimum: 1. Maximum: 1000. Default: 50.     |
| Start page       | integer         | No       | Page to start from, from a previous run's next page. Minimum: 1.                     |

**Outputs**

| Field     | Type          | Description                                   |
| --------- | ------------- | --------------------------------------------- |
| Records   | object\_array | The matching records.                         |
| Next page | integer       | Page to continue from, if more records exist. |

#### Get Record

Get one record from a table by its ID.

**Inputs**

| Field     | Type            | Required | Description                                                                 |
| --------- | --------------- | -------- | --------------------------------------------------------------------------- |
| Base      | select (string) | Yes      | The base that holds the table. Options load from the selected connection.   |
| Table     | select (string) | Yes      | The table that holds the record. Options load from the selected connection. |
| Record ID | string          | Yes      | The ID of the record.                                                       |

**Outputs**

| Field     | Type   | Description          |
| --------- | ------ | -------------------- |
| Record ID | string | The record's ID.     |
| Fields    | object | The record's values. |

#### Create Record

Add a new record (row) to a table.

**Inputs**

| Field        | Type            | Required | Description                                                                |
| ------------ | --------------- | -------- | -------------------------------------------------------------------------- |
| Base         | select (string) | Yes      | The base that holds the table. Options load from the selected connection.  |
| Table        | select (string) | Yes      | The table to add the record to. Options load from the selected connection. |
| Field values | textarea        | Yes      | The new record's values as JSON, with field names as keys.                 |

**Outputs**

| Field     | Type   | Description                |
| --------- | ------ | -------------------------- |
| Record ID | string | The new record's ID.       |
| Fields    | object | The record's saved values. |

#### Update Record

Change values on an existing record. Fields you leave out stay as they are.

**Inputs**

| Field        | Type            | Required | Description                                                                 |
| ------------ | --------------- | -------- | --------------------------------------------------------------------------- |
| Base         | select (string) | Yes      | The base that holds the table. Options load from the selected connection.   |
| Table        | select (string) | Yes      | The table that holds the record. Options load from the selected connection. |
| Record ID    | string          | Yes      | The ID of the record to update.                                             |
| Field values | textarea        | Yes      | The values to change as JSON, with field names as keys.                     |

**Outputs**

| Field     | Type   | Description                           |
| --------- | ------ | ------------------------------------- |
| Record ID | string | The record's ID.                      |
| Fields    | object | The record's values after the update. |

#### Delete Record

Permanently delete a record from a table.

**Inputs**

| Field     | Type            | Required | Description                                                                 |
| --------- | --------------- | -------- | --------------------------------------------------------------------------- |
| Base      | select (string) | Yes      | The base that holds the table. Options load from the selected connection.   |
| Table     | select (string) | Yes      | The table that holds the record. Options load from the selected connection. |
| Record ID | string          | Yes      | The ID of the record to delete.                                             |

**Outputs**

| Field     | Type    | Description                     |
| --------- | ------- | ------------------------------- |
| Record ID | string  | The deleted record's ID.        |
| Deleted   | boolean | Whether the record was deleted. |

#### Create Table

Create a new table in a base, with the fields you list.

**Inputs**

| Field      | Type            | Required | Description                                                                                 |
| ---------- | --------------- | -------- | ------------------------------------------------------------------------------------------- |
| Base       | select (string) | Yes      | The base to create the table in. Options load from the selected connection.                 |
| Table name | string          | Yes      | Name of the new table.                                                                      |
| Fields     | string          | No       | Comma-separated field names, optionally with a type, like Name, Email:Email, Amount:Number. |

**Outputs**

| Field      | Type          | Description           |
| ---------- | ------------- | --------------------- |
| Table ID   | string        | The new table's ID.   |
| Table name | string        | The new table's name. |
| Fields     | object\_array | The fields created.   |

### Important behavior

Actions that create, update, send, or delete data can change the connected service. Review their inputs before running them. A retry can repeat an operation; consider this when configuring retries for actions that change data.

The catalog lists the fields and capabilities available in the supplied provider definition. Availability can also depend on your deployment and organization’s Feature Access settings.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.stackai.com/integrations/catalog/nocodb.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
