airtable_create_base_schema
Build a complete Airtable base schema with multiple relational tables and custom field types like currency, select, and formula to initialize your application.
Instructions
Provisions multiple tables and custom fields in an Airtable base using the official Metadata API. Supports singleLineText, singleSelect, currency, number, formula, checkbox, multipleRecordLinks, and more.
When to Use
When initializing a new application, portal, or workflow with multiple relational tables.
When creating tables with customized field types, select choices, or currency configurations.
When establishing the core data schema before building Interface Designer pages.
When NOT to Use
Do NOT use this tool to add a single field to an existing table. Use 'airtable_modify_schema' instead.
Do NOT use this tool to insert records. Use 'airtable_batch_upsert' instead.
Do NOT use this tool to inspect table field IDs. Use 'airtable_list_schema' instead.
Operational Disclosures
Side Effects: Creates permanent tables and field columns in the target Airtable base.
Persistence: Irreversible via this tool; created tables must be deleted manually from the Airtable UI if abandoned.
Rate Limits: Tables are created sequentially with 250ms spacing to prevent Metadata API 429 rate limit errors.
Auth Scopes: Requires Personal Access Token with 'schema.bases:write' scope.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tables | Yes | List of table configurations with name, description, and field definitions | |
| base_id | Yes | Airtable Base ID (starts with app, e.g. appoorUuG6wgx8dJ1) |