Skip to main content

Airtable

The Airtable agent connector is a Python package that equips AI agents to interact with Airtable through strongly typed, well-documented tools. It's ready to use directly in your Python app, in an agent framework, or exposed through an MCP.

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 my first base?
  • Show me the schema for tables in a base
  • List records from a table in my base
  • Show me recent records from a table
  • What fields are in a table?
  • List records where Status is 'Done' in table tblXXX
  • Find records created last week in table tblXXX
  • Show me records updated in the last 30 days in base appXXX

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. If your Airbyte client can access multiple organizations, also set organization_id.

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, AirbyteAuthConfig

connector = AirtableConnector(
    auth_config=AirbyteAuthConfig(
        customer_name="<your_customer_name>",
        organization_id="<your_organization_id>",  # Optional for multi-org clients
        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, Context Store Search
Tables List, Context Store Search
Records List, Get

Authentication

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

Airtable API docs

See the official Airtable API reference.

Version information

  • Package version: 0.1.60
  • Connector version: 1.0.8
  • Generated with Connector SDK commit SHA: c5258debd165ab701252c1436d4acfb475bf92b9
  • Changelog: View changelog

Release files for airbyte-agent-airtable 0.1.60

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for airbyte-agent-airtable 0.1.60
File Size Uploaded
airbyte_agent_airtable-0.1.60.tar.gz 151.2 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for airbyte-agent-airtable 0.1.60
File Interpreter ABI Platform
airbyte_agent_airtable-0.1.60-py3-none-any.whl Python 3 none any Details

Total release size: 330.8 kB

Release files / airbyte_agent_airtable-0.1.60.tar.gz

Download URL airbyte_agent_airtable-0.1.60.tar.gz
Size 151.2 kB
Tags Source
SHA-256 checksum
How to use checksums
b7d31a5af7bfaacd8a4e7b2fe98c3d8ff66f5aac17af33f743907b8aaea3910f
BLAKE2b-256 checksum
How to use checksums
d2108e7531e52dc390961eec13cf1ecbe16698b54ea26e1b0213bf9cba4025c4
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.13.12

Release files / airbyte_agent_airtable-0.1.60-py3-none-any.whl

Download URL airbyte_agent_airtable-0.1.60-py3-none-any.whl
Size 179.6 kB
Tags Python 3
SHA-256 checksum
How to use checksums
62d8df72234545f13ac59fa36f9287ee61a0f93d00b47727a6f3ec058df533a8
BLAKE2b-256 checksum
How to use checksums
77b7d0c8d1bc4787cd64acd6354af8d440770ed52eb6f1eff0cbf222e4d59f6f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.13.12

Release history Release notifications | RSS feed

This release

0.1.60 This release

2 release files

0.1.51

2 release files

0.1.50

2 release files

0.1.49

2 release files

0.1.48

2 release files

0.1.47

2 release files

0.1.46

2 release files

0.1.45

2 release files

0.1.40

2 release files

0.1.39

2 release files

0.1.38

2 release files

0.1.37

2 release files

0.1.36

2 release files

0.1.35

2 release files

0.1.34

2 release files

0.1.33

2 release files

0.1.32

2 release files

0.1.31

2 release files

0.1.30

2 release files

0.1.29

2 release files

0.1.28

2 release files

0.1.27

2 release files

0.1.26

2 release files

0.1.25

2 release files

0.1.9

2 release files

0.1.8

2 release files

0.1.7

2 release files

0.1.6

2 release files

0.1.5

2 release files

0.1.4

2 release files

0.1.3

2 release files

0.1.2

2 release files

0.1.1

2 release files

0.1.0

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page