Airtable User MCP
Fills the gaps in Airtable's public REST API by exposing the internal endpoints the web UI actually uses. You get 66 tools for schema management, field creation and updates, view configuration, formula validation, and extension handling. Runs locally over stdio and authenticates through your browser with full SSO and 2FA support, so credentials stay in your OS keychain. Designed to run alongside the official Airtable MCP server: use theirs for record operations over HTTP, use this one for everything the REST API doesn't expose. Includes permission profiles (read-only, safe-write, full) and optional daemon mode with remote tunneling.
- tools
- 72
- transport
- STDIO
- env vars
- 3
- last updated
- Apr 11, 2026
Tools
72 toolsPublic tool metadata for what this MCP can expose to an agent.
get_base_schemaFull schema of all tables, fields, and views in a base
Full schema of all tables, fields, and views in a base
No parameter schema in public metadata yet.
list_tablesList all tables in a base with IDs and names
List all tables in a base with IDs and names
No parameter schema in public metadata yet.
get_table_schemaFull schema for a single table
Full schema for a single table
No parameter schema in public metadata yet.
list_fieldsAll fields in a table with id, name, and type (lightweight); pass includeOptions: true for full typeOptions
All fields in a table with id, name, and type (lightweight); pass includeOptions: true for full typeOptions
No parameter schema in public metadata yet.
list_viewsAll views in a table with IDs, names, and types
All views in a table with IDs, names, and types
No parameter schema in public metadata yet.
get_viewRead a single view's full state — filters, sorts, grouping, visibility, description
Read a single view's full state — filters, sorts, grouping, visibility, description
No parameter schema in public metadata yet.
validate_formulaValidate a formula expression before applying
Validate a formula expression before applying
No parameter schema in public metadata yet.
list_view_sectionsList sidebar sections for a table with their view membership
List sidebar sections for a table with their view membership
No parameter schema in public metadata yet.
list_record_templatesList record templates (saved row scaffolds) for a table
List record templates (saved row scaffolds) for a table
No parameter schema in public metadata yet.
download_formula_fieldDownload a formula field to a local .formula file with an AT: metadata header — field refs resolved to real {Field Name} syntax. Pass outputPath to save; omit to read inline.
Download a formula field to a local .formula file with an AT: metadata header — field refs resolved to real {Field Name} syntax. Pass outputPath to save; omit to read inline.
No parameter schema in public metadata yet.
download_base_formulasDownload all formula fields in a base to .formula files, organised into per-table subfolders — field refs resolved to real {Field Name} syntax. Each file includes the AT: header for one-click upload.
Download all formula fields in a base to .formula files, organised into per-table subfolders — field refs resolved to real {Field Name} syntax. Each file includes the AT: header for one-click upload.
No parameter schema in public metadata yet.
query_recordsFetch up to 1 000 records from a view with all field values already resolved (lookup fields return the linked record's display string, not a raw ID). Pass search for case-insensitive substring matching across every field value including lookups, rollups, formula fields, and mu...
Fetch up to 1 000 records from a view with all field values already resolved (lookup fields return the linked record's display string, not a raw ID). Pass search for case-insensitive substring matching across every field value including lookups, rollups, formula fields, and mu...
No parameter schema in public metadata yet.
duplicate_recordsDuplicate one or more existing records within the same table. Pass sourceRowIds array; returns the new record IDs.
Duplicate one or more existing records within the same table. Pass sourceRowIds array; returns the new record IDs.
No parameter schema in public metadata yet.
create_recordsCreate one or more records in a table. Each item supplies cellValuesByColumnId (computed fields are read-only and must be omitted). Returns created record IDs; a failing row is reported, not fatal.
Create one or more records in a table. Each item supplies cellValuesByColumnId (computed fields are read-only and must be omitted). Returns created record IDs; a failing row is reported, not fatal.
No parameter schema in public metadata yet.
update_recordsUpdate primitive / single-select cells of existing records via cellValuesByColumnId. Array cells (multi-select, links, attachments) are not set here. Per-row isolation.
Update primitive / single-select cells of existing records via cellValuesByColumnId. Array cells (multi-select, links, attachments) are not set here. Per-row isolation.
No parameter schema in public metadata yet.
upload_attachmentUpload attachments into an attachment cell by URL — Airtable's servers fetch each URL directly. The only way to set multipleAttachments fields; update_records cannot. Appends to the cell (calling twice adds two).
Upload attachments into an attachment cell by URL — Airtable's servers fetch each URL directly. The only way to set multipleAttachments fields; update_records cannot. Appends to the cell (calling twice adds two).
No parameter schema in public metadata yet.
delete_recordsDelete one or more records from a table in a single batch call. The returned deleted count equals rowIds.length (optimistic) — already-deleted rows are silently skipped by the server.
Delete one or more records from a table in a single batch call. The returned deleted count equals rowIds.length (optimistic) — already-deleted rows are silently skipped by the server.
No parameter schema in public metadata yet.
create_tableCreate a new table with default fields
Create a new table with default fields
No parameter schema in public metadata yet.
rename_tableRename a table
Rename a table
No parameter schema in public metadata yet.
delete_tableDelete a table (requires expectedName safety guard)
Delete a table (requires expectedName safety guard)
No parameter schema in public metadata yet.
create_fieldCreate a field — auto-maps url / email / phone / dateTime aliases, plus formula, rollup, lookup, count
Create a field — auto-maps url / email / phone / dateTime aliases, plus formula, rollup, lookup, count
No parameter schema in public metadata yet.
create_formula_fieldCreate a formula field (shorthand)
Create a formula field (shorthand)
No parameter schema in public metadata yet.
update_formula_fieldUpdate the formula text of an existing field
Update the formula text of an existing field
No parameter schema in public metadata yet.
update_field_configUpdate configuration of any computed field
Update configuration of any computed field
No parameter schema in public metadata yet.
rename_fieldRename a field with pre-validation
Rename a field with pre-validation
No parameter schema in public metadata yet.
delete_fieldDelete with safety guards and a compact dependency summary
Delete with safety guards and a compact dependency summary
No parameter schema in public metadata yet.
delete_fieldsBulk-delete multiple fields in 1–2 API calls. Takes a fields array of {fieldId, expectedName} pairs; validates names before deleting. Use force: true to override dependency blocks. Optional checkpointFile writes progress after each batch.
Bulk-delete multiple fields in 1–2 API calls. Takes a fields array of {fieldId, expectedName} pairs; validates names before deleting. Use force: true to override dependency blocks. Optional checkpointFile writes progress after each batch.
No parameter schema in public metadata yet.
duplicate_fieldClone a field, optionally copying cell values
Clone a field, optionally copying cell values
No parameter schema in public metadata yet.
update_field_descriptionSet or update a field's description text
Set or update a field's description text
No parameter schema in public metadata yet.
create_viewCreate grid, form, kanban, calendar, gallery, gantt, or list view
Create grid, form, kanban, calendar, gallery, gantt, or list view
No parameter schema in public metadata yet.
duplicate_viewClone a view with all configuration
Clone a view with all configuration
No parameter schema in public metadata yet.
rename_viewRename a view
Rename a view
No parameter schema in public metadata yet.
delete_viewDelete a view (cannot delete last view)
Delete a view (cannot delete last view)
No parameter schema in public metadata yet.
update_view_descriptionSet or clear a view's description
Set or clear a view's description
No parameter schema in public metadata yet.
update_view_filtersSet or append filter conditions (AND/OR, nested groups, isEmpty/isNotEmpty auto-normalized for text/formula(text)/lookup/rollup)
Set or append filter conditions (AND/OR, nested groups, isEmpty/isNotEmpty auto-normalized for text/formula(text)/lookup/rollup)
No parameter schema in public metadata yet.
reorder_view_fieldsChange column order — accepts a partial map and merges with current order
Change column order — accepts a partial map and merges with current order
No parameter schema in public metadata yet.
show_or_hide_view_columnsToggle visibility for an explicit list of columns
Toggle visibility for an explicit list of columns
No parameter schema in public metadata yet.
apply_view_sortsSet or clear sort conditions
Set or clear sort conditions
No parameter schema in public metadata yet.
update_view_group_levelsSet or clear grouping. For Kanban views, stack by is implemented as a single group level
Set or clear grouping. For Kanban views, stack by is implemented as a single group level
No parameter schema in public metadata yet.
update_view_row_heightChange row height (small / medium / large / xlarge)
Change row height (small / medium / large / xlarge)
No parameter schema in public metadata yet.
set_view_columnsOne-shot: hide all + show a curated list in left-to-right order + optional frozen-column count
One-shot: hide all + show a curated list in left-to-right order + optional frozen-column count
No parameter schema in public metadata yet.
show_or_hide_all_columnsBulk hide-all / show-all primitive
Bulk hide-all / show-all primitive
No parameter schema in public metadata yet.
move_visible_columnsMove column(s) to a target index in the visible-only ordering
Move column(s) to a target index in the visible-only ordering
No parameter schema in public metadata yet.
move_overall_columnsMove column(s) to a target index in the overall (visible + hidden) ordering
Move column(s) to a target index in the overall (visible + hidden) ordering
No parameter schema in public metadata yet.
update_frozen_column_countSet the frozen-column divider position
Set the frozen-column divider position
No parameter schema in public metadata yet.
set_view_coverSet or clear cover-image field and fit vs crop (Kanban + Gallery)
Set or clear cover-image field and fit vs crop (Kanban + Gallery)
No parameter schema in public metadata yet.
set_view_color_configApply a color config (currently selectColumn type — cards colored by a single-select field's choice colors)
Apply a color config (currently selectColumn type — cards colored by a single-select field's choice colors)
No parameter schema in public metadata yet.
set_view_cell_wrapToggle whether long cell values wrap or truncate
Toggle whether long cell values wrap or truncate
No parameter schema in public metadata yet.
set_calendar_date_columnsSet Calendar dateColumnRanges (single-date or range; multiple overlays supported)
Set Calendar dateColumnRanges (single-date or range; multiple overlays supported)
No parameter schema in public metadata yet.
create_view_sectionCreate a new sidebar section in a table
Create a new sidebar section in a table
No parameter schema in public metadata yet.
rename_view_sectionRename a sidebar section
Rename a sidebar section
No parameter schema in public metadata yet.
move_view_to_sectionMove view INTO a section, OUT to ungrouped, reorder within a section, or reorder sections among each other
Move view INTO a section, OUT to ungrouped, reorder within a section, or reorder sections among each other
No parameter schema in public metadata yet.
delete_view_sectionDestroy a section. Contained views are auto-promoted to ungrouped at the section's former position
Destroy a section. Contained views are auto-promoted to ungrouped at the section's former position
No parameter schema in public metadata yet.
create_record_templateCreate a new record template (client-side rtp... ID)
Create a new record template (client-side rtp... ID)
No parameter schema in public metadata yet.
rename_record_templateRename a template
Rename a template
No parameter schema in public metadata yet.
update_record_template_descriptionSet or clear a template's description
Set or clear a template's description
No parameter schema in public metadata yet.
set_record_template_cellSet a cell value — static (text/number/select), linkedRows, or linkedTemplates
Set a cell value — static (text/number/select), linkedRows, or linkedTemplates
No parameter schema in public metadata yet.
set_record_template_visible_columnsChoose which columns the template surfaces in its UI
Choose which columns the template surfaces in its UI
No parameter schema in public metadata yet.
duplicate_record_templateClone an existing template
Clone an existing template
No parameter schema in public metadata yet.
apply_record_templateApply a template to create a new record using its cell defaults
Apply a template to create a new record using its cell defaults
No parameter schema in public metadata yet.
delete_record_templateDelete a template
Delete a template
No parameter schema in public metadata yet.
set_form_metadataBundled tool for description, afterSubmitMessage, redirectUrl, refreshAfterSubmit, shouldAllowRequestCopyOfResponse, shouldAttributeResponses, isAirtableBrandingRemoved
Bundled tool for description, afterSubmitMessage, redirectUrl, refreshAfterSubmit, shouldAllowRequestCopyOfResponse, shouldAttributeResponses, isAirtableBrandingRemoved
No parameter schema in public metadata yet.
set_form_submission_notificationPer-user email-on-submit toggle
Per-user email-on-submit toggle
No parameter schema in public metadata yet.
create_extensionRegister a new extension/block in a base
Register a new extension/block in a base
No parameter schema in public metadata yet.
create_extension_dashboardCreate a new dashboard page
Create a new dashboard page
No parameter schema in public metadata yet.
install_extensionInstall an extension onto a dashboard page
Install an extension onto a dashboard page
No parameter schema in public metadata yet.
update_extension_stateEnable or disable an installed extension
Enable or disable an installed extension
No parameter schema in public metadata yet.
rename_extensionRename an installed extension
Rename an installed extension
No parameter schema in public metadata yet.
duplicate_extensionClone an installed extension
Clone an installed extension
No parameter schema in public metadata yet.
remove_extensionRemove an extension from a dashboard
Remove an extension from a dashboard
No parameter schema in public metadata yet.
sync_baseCopy a base's schema, views, and records to another base, with plan, diff, status, apply and reconcile modes
Copy a base's schema, views, and records to another base, with plan, diff, status, apply and reconcile modes
No parameter schema in public metadata yet.
manage_toolsList profiles, switch the active profile, toggle individual tools/categories
List profiles, switch the active profile, toggle individual tools/categories
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageConfiguration
AIRTABLE_HEADLESS_ONLYHeadless auth (no browser UI)
AIRTABLE_NO_BROWSERForce manual session mode
AIRTABLE_USER_MCP_HOMEOverride config directory
Readme
Airtable Formulas, Scripts, Automation, MCP & LSP
Formula, script & automation editor · MCP server (73 tools + manage_tools) · Language server · AI skill
Details
- Repository
- github.com/automations-project/vscode-airtable-formula
- Website
- github.com/Automations-Project/VSCode-Airtable-Formula/tree/main/packages/mcp-server
- Categories
- Developer Tools, Documents & Knowledge
- Package
airtable-user-mcp- Transport
- STDIO
- Registry
- MCP registry, active
Related Developer Tools MCP servers
View all
Neverinfamous Memory Journal Mcpneverinfamous/memory-journal-mcpA MCP server built for developers enabling Git based project management with project and personal…17stars
Instagitinstalabsai/instagitMCP server for Instagit — AI-powered Git repository analysis for coding agents17starsMemory Journal Mcpneverinfamous/memory-journal-mcpDeveloper journal with knowledge graphs, relationships, Git context, and semantic search17stars
Driflyte Mcp Serverserkan-ozal/driflyte-mcp-serverDriflyte MCP server which lets AI assistants query topic-specific knowledge from web and GitHub.10stars
Fossicklipdog/fossick-mcpSearch all of GitHub from your AI agent — find libraries, drill into repos, find code patterns.3stars
ActionsPulsetsviz/github-mcp-server-devopsReal-time GitHub Actions observability: DORA Metrics, Cost Analysis, CI/CD Health dashboards.0stars