airtable

Query Airtable bases, tables, and records via REST API with filters, sorts, and pagination.

1|Updated May 12, 2018

Search Tags:#database #api #query #pagination #records #base #airtable

Ready to run

npx skills add https://github.com/tbroadley/dotfiles --skill airtable

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: airtable
Source: https://github.com/tbroadley/dotfiles/tree/main/claude/skills/airtable
Command: npx skills add https://github.com/tbroadley/dotfiles --skill airtable

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides streamlined access to Airtable bases, tables, and records via the Airtable REST API, enabling quick lookups, simple queries, and fast data retrieval.

Core Features & Use Cases

Query Bases & Tables: List bases, fetch table schemas, and retrieve records with filtering, sorting, and pagination.
Search & Read: Read structured data from Airtable fields and surfaces relevant results for decision making.
Use Case: Retrieve all open tasks from a base and compile a summary of due dates for project planning.

Quick Start

Use the airtable skill to fetch records from a base named "Projects" and display fields: Name, Status, and Due Date.

Frequently Asked Questions about airtable

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I query Airtable records via the REST API?▼

You can query Airtable records by sending requests to the https://api.airtable.com/v0 endpoint with an Authorization header using your AIRTABLE_TOKEN. The API supports filtering, sorting, and pagination to retrieve targeted records from your bases.

Can I list Airtable bases and fetch table schemas using the API?▼

Yes, you can list Airtable bases and fetch table schemas using the Airtable REST API. This functionality allows you to discover base structures and retrieve field definitions for workflow tracking and data analytics scenarios.

Do I need an Airtable token to retrieve records from a base?▼

Yes, retrieving records from an Airtable base requires a valid Airtable token exposed as AIRTABLE_TOKEN. This token authenticates your requests via standard Authorization headers to the https://api.airtable.com/v0 endpoint.

How does pagination work when fetching Airtable records?▼

Pagination when fetching Airtable records is managed through the Airtable REST API, allowing you to retrieve large datasets in batches. You can combine pagination with filters and sorts to read structured data and surface relevant results for decision making.

What is the best way to retrieve open tasks from an Airtable base for project planning?▼

The best way to retrieve open tasks from an Airtable base for project planning is to query the Airtable REST API with filters on the Status field. You can then compile a summary of due dates from the retrieved records to support your project planning workflow.

Are there limitations when using the Airtable REST API for data retrieval?▼

Limitations when using the Airtable REST API for data retrieval include reliance on standard API rate limits and the need to handle pagination for large record sets. You must securely manage your AIRTABLE_TOKEN and structure queries to respect filtering and sorting constraints.