Airtable Integration

Airtable is built into MeinGPT as a native tool (not an MCP server) and lets you interact directly with your Airtable databases. Create, read, update, and delete data in your Airtable workspace.

Setup

Prerequisites

1. An Airtable account
2. An Airtable Personal Access Token
   • Create a token at: https://airtable.com/create/tokens↗
   • Required permissions:
     • data.records:read - for reading records
     • data.records:write - for creating/updating records
     • schema.bases:read - for reading database structure
     • schema.bases:write - for creating/modifying tables

The token inherits the Airtable permissions of the account that created it. Create it with an account whose access is already limited to the bases you actually need, rather than with an account that has unrestricted workspace access.

Configuration

When activating the tool, enter your Airtable Personal Access Token in the "Airtable Personal Access Token" field.

Main Functions

Database Operations

• list_bases: Lists all accessible Airtable databases
• list_tables: Shows all tables in a database with optional detail level
• describe_table: Returns detailed information about a specific table

Record Operations

• list_records: Lists records from a table with filter options
  • Supports filter formulas, sorting, and views
  • Pagination for large data sets
• search_records: Searches text fields for specific terms
• get_record: Retrieves a specific record by ID
• create_record: Creates a new record
• update_records: Updates up to 10 records simultaneously
• delete_records: Deletes up to 10 records simultaneously

Schema Operations

• create_table: Creates a new table with defined fields
• update_table: Changes name or description of a table
• create_field: Adds a new field to a table
• update_field: Changes name or description of a field

Usage Examples

Search and Filter Records

"Find all customers in Berlin"
"Show me tasks with status 'Open' sorted by priority"
"Search for products with 'Premium' in the name"

Manage Data

"Create a new customer entry with name and email"
"Update the status of task ID xyz to 'Done'"
"Delete all entries with status 'Archived'"

Adjust Table Structure

"Create a new table 'Projects' with fields for name, status, and deadline"
"Add a number field 'Budget' to the project table"

Filter Formulas

Airtable supports complex filter formulas:

• {Status} = "Active" - Exact match
• AND({Price} > 100, {Category} = "Premium") - Multiple conditions
• OR(FIND("important", {Notes}), {Priority} = "High") - OR connection
• NOT({Archived}) - Negation

Permissions

• The Personal Access Token determines which of the scopes above are available – without data.records:write or schema.bases:write, the corresponding write operations fail
• The token also inherits the Airtable permissions of the account that created it (see the warning above) – the tool has no access to bases that account cannot see

Limitations

• Maximum 10 records per update/delete operation
• API rate limits: 5 requests per second
• Filter formulas must follow Airtable syntax
• Search function only available for text fields

Privacy and Security

• MeinGPT doesn't store an Airtable password, only the Personal Access Token you enter
• All data is transmitted encrypted
• You can change or remove the token anytime in the tool's configuration field, or revoke it in Airtable
• Because the token inherits the permissions of the account that created it, revoking it in Airtable immediately affects every action running through it