Airtable agent connector

Airtable is a cloud-based platform that combines the simplicity of a spreadsheet with the power of a database. This connector provides access to bases, tables, and records for data analysis and workflow automation.

Example questions

The Airtable connector is optimized to handle prompts like these.

• List all my Airtable bases
• What tables are in base appXXX?
• Show me the schema for tables in base appXXX
• List records from table tblXXX in base appXXX
• Get record recXXX from table tblXXX in base appXXX
• What fields are in table tblXXX?
• List records where Status is 'Done' in table tblXXX

Unsupported questions

The Airtable connector isn't currently able to handle prompts like these.

• Create a new record in Airtable
• Update a record in Airtable
• Delete a record from Airtable
• Create a new table
• Modify table schema

Installation

uv pip install airbyte-agent-airtable

Usage

Connectors can run in open source or hosted mode.

Open source

In open source mode, you provide API credentials directly to the connector.

from airbyte_agent_airtable import AirtableConnector
from airbyte_agent_airtable.models import AirtableAuthConfig

connector = AirtableConnector(
    auth_config=AirtableAuthConfig(
        personal_access_token="<Airtable Personal Access Token. See https://airtable.com/developers/web/guides/personal-access-tokens>"
    )
)

@agent.tool_plain # assumes you're using Pydantic AI
@AirtableConnector.tool_utils
async def airtable_execute(entity: str, action: str, params: dict | None = None):
    return await connector.execute(entity, action, params or {})

Hosted

In hosted mode, API credentials are stored securely in Airbyte Cloud. You provide your Airbyte credentials instead.

This example assumes you've already authenticated your connector with Airbyte. See Authentication to learn more about authenticating. If you need a step-by-step guide, see the hosted execution tutorial.

from airbyte_agent_airtable import AirtableConnector

connector = AirtableConnector(
    external_user_id="<your_external_user_id>",
    airbyte_client_id="<your-client-id>",
    airbyte_client_secret="<your-client-secret>"
)

@agent.tool_plain # assumes you're using Pydantic AI
@AirtableConnector.tool_utils
async def airtable_execute(entity: str, action: str, params: dict | None = None):
    return await connector.execute(entity, action, params or {})

Full documentation

Entities and actions

This connector supports the following entities and actions. For more details, see this connector's full reference documentation.

Entity	Actions
Bases	List
Tables	List
Records	List, Get

Authentication and configuration

For all authentication and configuration options, see the connector's authentication documentation.

Airtable API docs

See the official Airtable API reference.

Version information

• Package version: 0.1.2
• Connector version: 1.0.1
• Generated with Connector SDK commit SHA: 5b20f488dec0e8f29410823753106603c23a4b65
• Changelog: View changelog