How to Use the Airtable MCP in VS Code Copilot

Q: Can VS Code Copilot search my Airtable base?

Yes. Copilot uses the searchrecords tool to execute formula-based queries against your base and returns the matching rows in the chat panel.

Give VS Code Copilot access to your Airtable bases to share live schemas and record data across your entire engineering team.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Airtable MCP to VS Code Copilot

Create your Vinkius account to connect Airtable to VS Code Copilot and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Airtable with VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Share Airtable schemas in VS Code

VS Code Copilot uses the `list_bases` and `get_base_metadata` tools to inspect your Airtable setup without requiring developers to open the browser. Anyone on your team can ask Copilot how a specific table is structured. The agent reads the live metadata and answers immediately. Committing your MCP configuration to the repository ensures everyone has the same access. When a new engineer joins, they can instantly run `list_fields` via Copilot to understand the database constraints.

Query live data via MCP Server

The `search_records` and `get_record` tools let Copilot pull specific rows directly into your editor context. You ask the agent to find a specific user profile or bug ticket. It queries the base and returns the exact data you requested. Getting real data into your editor helps you debug faster. By calling `list_records`, the agent pulls a batch of recent entries, giving you immediate context on what users are actually submitting to your system.

Manage records from the editor

Executing `create_records`, `update_records`, and `delete_records` allows you to modify Airtable data directly through Copilot Chat. You can bulk-update status fields or clear out stale test entries by just typing a command. Managing state from your IDE keeps you focused. The agent handles the payload formatting and executes the batch operation, returning a confirmation once the API accepts the changes.

Setup guide

Set up Airtable MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the Airtable MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the Airtable tools listed. Try asking: "List my recent Airtable transactions" and Copilot will invoke them automatically.

.vscode/mcp.json

{
  "mcpServers": {
    "airtable-mcp": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Airtable. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Airtable now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Airtable MCP in VS Code Copilot

Add the Vinkius endpoint to your local settings file. Once committed, every developer on your team gets access to the tools in their editor.

Yes. Copilot uses the `search_records` tool to execute formula-based queries against your base and returns the matching rows in the chat panel.

The server includes tools for bulk creating, updating, and deleting records. Copilot packages your requested changes into a single API call to modify multiple rows at once.

The agent likely sent a string to a linked record field. Ask Copilot to check the schema using `list_fields` before it tries to write the data.

Every request containing your base schemas or row data runs inside a secure, ephemeral V8 isolate. The sandbox executes the query and terminates immediately, guaranteeing zero persistent storage of your proprietary information.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript