Airtable Connector

Airtable offers a flexible, spreadsheet-meets-database platform for organizing tasks, projects, and diverse datasets in a customizable interface.

4.8 on G2
Weld · Data Sources
AirtableLive
Pick the tables to sync, and they appear here with their status.
Lands insnowflakebigquerydatabricksQueryable over MCP
How it works

Set up in minutes.
No code, no maintenance.

Airtable

Airtable

Data source

Authenticating...
Ready to connect
Overview

Airtable in your warehouse.
Ready for your agents.

Airtable offers a flexible, spreadsheet-meets-database platform for organizing tasks, projects, and diverse datasets in a customizable interface. Weld's Airtable connector is fully managed: it extracts data from Airtable, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

AgentsQuery over MCPYour warehouseClean, documented tablesWeldExtract, load, keep in syncAirtableSource
Weld MCP server

Ask your agent.
It can reach Airtable.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It finds the Airtable tables Weld has synced and queries your warehouse.

  • DiscoverSynced tables, columns and freshness
  • QuerySQL against your warehouse
  • OperateCheck, rerun and refresh syncs
Claude CodeOpus 5
>

Which Airtable tables do we have, and which one is the largest?

Looking up what the Airtable connection has synced.

●weld·search_available_references
⎿raw.airtable.*
tables, columns and freshness
●weld·get_reference_schema
⎿columns, types and nullability
●weld·run_query
⎿select count(*) from {{raw.airtable.…}}
submitted
●weld·get_query_status
⎿DONE
●weld·get_query_result
⎿rows returned
✓Answered from Airtable data in your warehouse
>Ask about your Airtable data
Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Airtable connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

POST/elt_syncs
▌
FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Talk to us

Put your Airtable data to work.

Connect Airtable, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

AirtableSource
WeldWeld
MCPAgents