airtable_skill

Overview

This skill provides programmatic access to Airtable bases, tables, and records using Python and the pyairtable library. It helps inspect base schemas, list and search records, and perform write operations when explicitly authorized. The flows prioritize secure setup and clear, human-friendly output formats.

How this skill works

Before any operation it verifies system prerequisites: Python, the pyairtable package, and a configured Airtable API key. It runs small python3 -c snippets that initialize Api(os.environ['AIRTABLE_API_KEY']) and then list bases, fetch table schemas, read or filter records, or perform create/update operations when you grant permission. Results are formatted as concise tables or summaries rather than raw JSON.

When to use it

• You mention Airtable, an Airtable base, table, records, or spreadsheet-like data.
• You need to list available bases or view table schemas and fields.
• You want to list, filter, or search records from a specific table.
• You plan to create or update records and can explicitly grant write permission.
• You need short, reproducible python3 -c snippets that run locally with your API key.

Best practices

• Run the three prerequisite checks first: Python, pyairtable, and AIRTABLE_API_KEY environment variable.
• Keep operations minimal and fetch only required fields to protect privacy and reduce payloads.
• Never paste or echo your API key; store it in an environment variable and load via os.environ['AIRTABLE_API_KEY'].
• Ask for explicit permission before any write actions (create, update, delete).
• Prefer the provided python3 -c one-liners for quick tasks and the pyairtable Api + table patterns for scripts.

Example use cases

• List all bases and their names to decide which to inspect next.
• Fetch a base schema to see tables and field types before building integrations.
• List or filter records in a table (e.g., Status = Active) and display results as a clean table.
• Search a free-text field for a term using Airtable SEARCH formula and summarize matches.
• Create or batch-create records after you confirm write permission and provide target base/table IDs.