Agent skill

airtable

Airtable API for bases and records. Use when user mentions "Airtable", "airtable.com", shares an Airtable link, "create record", or asks about Airtable base.

View SKILL.md on GitHub Repository
Stars 50
Forks 8

Install this agent skill to your Project

npx add-skill https://github.com/vm0-ai/vm0-skills/tree/main/airtable

SKILL.md

Airtable API

Manage bases, tables, records, and comments in Airtable.

Official docs: https://airtable.com/developers/web/api/introduction

When to Use

  • List and inspect Airtable bases and tables
  • Read, create, update, and delete records
  • Manage table schemas (fields, views)
  • Read and write record comments
  • Get current user info

Core APIs

Get Current User

bash
curl -s "https://api.airtable.com/v0/meta/whoami" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq .

List Bases

bash
curl -s "https://api.airtable.com/v0/meta/bases" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq '.bases[] | {id, name, permissionLevel}'

Get Base Schema (List Tables)

Replace <base-id> with your actual base ID (starts with app):

bash
curl -s "https://api.airtable.com/v0/meta/bases/<base-id>/tables" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq '.tables[] | {id, name, fields: [.fields[] | {id, name, type}]}'

List Records

Replace <base-id> and <table-id-or-name> with actual values. Table name must be URL-encoded if it contains spaces.

bash
curl -s "https://api.airtable.com/v0/<base-id>/<table-id-or-name>?maxRecords=10" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq '.records[] | {id, fields, createdTime}'

List Records with Field Selection

bash
curl -s "https://api.airtable.com/v0/<base-id>/<table-id-or-name>?maxRecords=10&fields%5B%5D=Name&fields%5B%5D=Status" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq '.records[] | {id, fields}'

Get a Single Record

bash
curl -s "https://api.airtable.com/v0/<base-id>/<table-id-or-name>/<record-id>" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq .

Create Records

Write the request body to a temp file, then send it:

bash
cat > /tmp/request.json << 'BODY'
{
  "records": [
    {
      "fields": {
        "Name": "New Record",
        "Status": "Todo"
      }
    }
  ]
}
BODY
curl -s -X POST "https://api.airtable.com/v0/<base-id>/<table-id-or-name>" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" --header "Content-Type: application/json" -d @/tmp/request.json | jq '.records[] | {id, fields}'

Update Records (PATCH)

PATCH updates only the specified fields, leaving others unchanged:

bash
cat > /tmp/request.json << 'BODY'
{
  "records": [
    {
      "id": "<record-id>",
      "fields": {
        "Status": "Done"
      }
    }
  ]
}
BODY
curl -s -X PATCH "https://api.airtable.com/v0/<base-id>/<table-id-or-name>" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" --header "Content-Type: application/json" -d @/tmp/request.json | jq '.records[] | {id, fields}'

Delete Records

bash
curl -s -X DELETE "https://api.airtable.com/v0/<base-id>/<table-id-or-name>?records%5B%5D=<record-id>" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq .

List Record Comments

bash
curl -s "https://api.airtable.com/v0/<base-id>/<table-id-or-name>/<record-id>/comments" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" | jq '.comments[] | {id, author, text, createdTime}'

Add a Comment to a Record

bash
cat > /tmp/request.json << 'BODY'
{
  "text": "This is a comment added via the API."
}
BODY
curl -s -X POST "https://api.airtable.com/v0/<base-id>/<table-id-or-name>/<record-id>/comments" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" --header "Content-Type: application/json" -d @/tmp/request.json | jq .

Create a Table

bash
cat > /tmp/request.json << 'BODY'
{
  "name": "New Table",
  "fields": [
    {"name": "Name", "type": "singleLineText"},
    {"name": "Notes", "type": "multilineText"},
    {"name": "Status", "type": "singleSelect", "options": {"choices": [{"name": "Todo"}, {"name": "In Progress"}, {"name": "Done"}]}}
  ]
}
BODY
curl -s -X POST "https://api.airtable.com/v0/meta/bases/<base-id>/tables" --header "Authorization: Bearer $(printenv AIRTABLE_TOKEN)" --header "Content-Type: application/json" -d @/tmp/request.json | jq '{id, name, fields: [.fields[] | {id, name, type}]}'

Guidelines

  1. Base IDs start with app, table IDs start with tbl, record IDs start with rec, field IDs start with fld.
  2. Use maxRecords parameter to limit results. Default returns up to 100 records.
  3. For pagination, use the offset value from the response in the next request.
  4. URL-encode table names that contain spaces (e.g., My%20Table). Using table IDs avoids this issue.
  5. The create/update endpoints accept up to 10 records per request.
  6. Field names are case-sensitive and must match exactly.
  7. Use PATCH for partial updates (only specified fields change) and PUT for full replacement.

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

vm0-ai/vm0-skills

brave-search

Brave Search API for web search. Use when user says "search web", "Brave search", or asks to "find on web" without specifying Google.

50 8
Explore
vm0-ai/vm0-skills

supadata

Supadata API for YouTube/web data. Use when user mentions "Supadata", "YouTube data", "channel stats", or web scraping data.

50 8
Explore
vm0-ai/vm0-skills

roadmap-planning

Build and prioritize product roadmaps using scoring models like RICE, ICE, and value-effort matrices. Activate when creating a product roadmap, prioritizing features, sequencing initiatives, mapping dependencies, balancing team capacity, choosing between Now/Next/Later or quarterly planning, or communicating roadmap tradeoffs to executives and stakeholders.

50 8
Explore
vm0-ai/vm0-skills

qdrant

Qdrant API for vector search. Use when user mentions "Qdrant", "vector database", "semantic search", or embeddings storage.

50 8
Explore
vm0-ai/vm0-skills

calendly

Calendly scheduling API. Use when user mentions "Calendly", "calendly.com", "schedule a meeting", "booking link", "event types", or asks about interview scheduling.

50 8
Explore
vm0-ai/vm0-skills

stripe

Stripe API for payments. Use when user mentions "Stripe", "payment", "subscription", "billing", "invoice", or asks about payment processing.

50 8
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results