# Automate Airtable Records and Schema

Airtable operations often fail when field names, formulas, limits, or pagination are handled incorrectly. This skill provides schema-aware workflows through Rube MCP.

## Install

```bash
npx skillstore add sickn33/airtable-automation
```

## Metadata

- Status: approved
- Slug: sickn33-airtable-automation
- Skillstore revision: r2
- Version status: missing
- Tree hash: e49c00a0b6bf679a1d5805603937c32f3e03f15b59b23be8c006d844ac7bc20f
- Author: sickn33
- GitHub username: sickn33
- License: MIT
- Repository: https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/airtable-automation
- Ref: ebdfe608f5de2b66ff37ab4af12af8ac4f5e8006
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, network
- Quality score: 69
- Public page: https://skillstore.pages.dev/skills/sickn33-airtable-automation
- Manifest: https://skillstore.pages.dev/api/skills/sickn33-airtable-automation/manifest

## Capabilities

- Discovers available Airtable bases and inspects table schemas before operations.
- Lists and filters records with formulas, selected fields, sorting, limits, and pagination.
- Creates, updates, and deletes individual records or batches of up to ten records.
- Creates fields, updates field names or descriptions, and changes table metadata.
- Lists comments attached to an Airtable record.
- Handles common Airtable errors, identifier formats, rate limits, and pagination rules.

## Use Cases

- Maintain Operations Records: Create and update task, inventory, or request records while respecting Airtable schemas and batch limits.
- Query Structured Data: Filter records with Airtable formulas, selected fields, sorting, and stable pagination.
- Evolve Workspace Schema: Inspect tables, create fields, rename fields, and update table metadata with validated parameters.

## Prompt Templates

### Inspect a Base

```
List my Airtable bases. Inspect the schema for [base and table], then summarize each field name, type, and purpose.
```

### Find Matching Records

```
Find records in [base and table] where [conditions]. Return [fields], sort by [field], and continue through every page.
```

### Apply a Batch Update

```
Preview records matching [conditions]. After I confirm, update [fields] in batches of ten and report successes and failures.
```

### Plan a Field Migration

```
Inspect my schema and plan a safe migration from [old field] to [new field]. Migrate in batches, validate totals, and preserve the original.
```

## Limitations

- Requires Rube MCP, Composio, and an active authenticated Airtable connection.
- Batch record operations support at most ten records per request, while list pages support at most 100 records.
- Computed fields cannot be created, and existing field types or options cannot be changed.
- The documented comment workflow lists comments but does not add, edit, or delete them.

## Best Practices

- Inspect the current base schema before building formulas or sending record fields.
- Preview affected records and obtain explicit confirmation before destructive or structural changes.
- Keep filters, sorting, and views unchanged while following pagination offsets.

## Anti Patterns

- Do not guess base, table, field, or record identifiers.
- Do not send more than ten records in one create, update, or delete request.
- Do not reuse an offset after changing filters, sorting, or views.

## Security Audit

- Audited at: 2026-07-23T18:57:37.47\+00:00
- Summary: All 55 external-command findings are false positives caused by Markdown inline-code formatting, with no shell or Ruby execution present. The external MCP connection is real, and destructive Airtable operations lack an explicit confirmation safeguard.

## Stats

- Views: 104
- Downloads: 5
- Favorites: 0
- Popularity score: 0