> ## Documentation Index
> Fetch the complete documentation index at: https://veryfront.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Airtable

> Read and write records in Airtable bases and tables

## At a glance

* **Availability**: Enabled by default.
* **Auth**: OAuth 2.0.
* **Connection**: A user authorizes the connection in the provider's consent screen.
* **Scopes**: `data.records:read`, `data.records:write`, `schema.bases:read`, `schema.bases:write`.

## Credentials

Set these per environment. See [Connect an integration](/cloud/integrations).

With a managed OAuth app, Connect works without these variables; set them to use your own OAuth app instead.

| Variable                 | Required | Description                                                                                       |
| ------------------------ | -------- | ------------------------------------------------------------------------------------------------- |
| `AIRTABLE_CLIENT_ID`     | Yes      | Airtable OAuth Client ID (from your OAuth integration) [Docs](https://airtable.com/create/oauth). |
| `AIRTABLE_CLIENT_SECRET` | Yes      | Airtable OAuth Client Secret [Docs](https://airtable.com/create/oauth).                           |

## Tools

| Tool           | Access | Description                                                          |
| -------------- | ------ | -------------------------------------------------------------------- |
| List Bases     | Read   | List all accessible Airtable bases                                   |
| Get Base       | Read   | Get schema information for a specific base                           |
| List Records   | Read   | List records from a table with optional filtering                    |
| Get Record     | Read   | Get a specific record by ID                                          |
| Create Record  | Write  | Create a new record in a table                                       |
| Create Records | Write  | Create multiple records in a table                                   |
| Update Record  | Write  | Update fields on an existing record                                  |
| Delete Record  | Write  | Delete a record from a table                                         |
| Create Table   | Write  | Create a new table in an Airtable base                               |
| Update Table   | Write  | Update table metadata such as name or description using the table ID |
| Create Field   | Write  | Create a new field in an Airtable table                              |

## Example prompts

* Search and query records from my Airtable bases. Find specific information across tables.
* Create a new record in an Airtable table with the specified field values.
* Analyze the structure and schema of an Airtable base, including all tables and their fields.