Skip to main content

Airbyte Airtable Connector for AI platforms

Project description

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, Search
Tables List, 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.56
  • Connector version: 1.0.7
  • Generated with Connector SDK commit SHA: 0bc9ab764a18fc48c3b595e69ba87a5337c63d51
  • Changelog: View changelog

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

airbyte_agent_airtable-0.1.56.tar.gz (149.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

airbyte_agent_airtable-0.1.56-py3-none-any.whl (178.2 kB view details)

Uploaded Python 3

File details

Details for the file airbyte_agent_airtable-0.1.56.tar.gz.

File metadata

  • Download URL: airbyte_agent_airtable-0.1.56.tar.gz
  • Upload date:
  • Size: 149.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.2.0 CPython/3.13.12

File hashes

Hashes for airbyte_agent_airtable-0.1.56.tar.gz
Algorithm Hash digest
SHA256 95f20448ab9cfa61870335f4826190ddbf5a9c75e56f10254291b950bac0462a
MD5 622575acff21f3b6a9fb9a2a69aaadf5
BLAKE2b-256 8402c3274d4e08e3672fd533a1fd58399f0f80de207d17cbe65fe54c36f79180

See more details on using hashes here.

File details

Details for the file airbyte_agent_airtable-0.1.56-py3-none-any.whl.

File metadata

File hashes

Hashes for airbyte_agent_airtable-0.1.56-py3-none-any.whl
Algorithm Hash digest
SHA256 0d76c1da68463c7f9d24dd65f171add924c88a0529951888754b3235721f0414
MD5 70700af18ccf9948b88972eeabf42400
BLAKE2b-256 00da4899ff8eaeebd531b61a55474da6f3e86671b79f237368ab2b17b7699d4a

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page