Advertise
MCP.so
Sign In
A

Airtable MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About Airtable MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Airtable (beta): https://www.cdata.com/download/download.aspx?sku=JAZK-V&type=beta

#airtable#mcp-server#cdata

Airtable MCP Server by CData config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\airtable.prp"
      ]
    }
  }
}

Airtable MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Airtable MCP Server by CData?

A read-only MCP server that enables LLMs (such as Claude Desktop) to query live Airtable data using natural language. It wraps the CData JDBC Driver for Airtable, which exposes Airtable bases as relational SQL models, so no SQL knowledge is required from the user.

How to use Airtable MCP Server by CData?

Clone the repository, build with Maven (mvn clean install), install and license the CData JDBC Driver for Airtable, create a .prp file with connection details, then configure the client (e.g., Claude Desktop) to launch the JAR with the .prp file. The server runs via stdio.

Key features of Airtable MCP Server by CData

  • Read‑only access to Airtable data for LLMs
  • Powered by the CData JDBC Driver for Airtable
  • Natural language querying – no SQL required
  • Tools for listing tables, columns, and running SELECT queries
  • Works with any MCP‑compatible client (e.g., Claude Desktop)
  • MIT licensed (JDBC driver requires separate licensing)

Use cases of Airtable MCP Server by CData

  • Ask an LLM “What are my top customers and their contact info?” from Airtable
  • Analyze correlations between Airtable fields (e.g., opportunity stage vs. industry)
  • Retrieve live calendar events or ticket counts without writing SQL
  • Integrate Airtable data into AI‑powered conversational assistants

Frequently asked questions

1

Is this server read‑only?

Yes. The project explicitly builds a read‑only MCP server. For full CRUD operations, CData offers a separate beta MCP Server.

2

What runtime dependencies are required?

Java (JDK), Maven, and the CData JDBC Driver for Airtable (which must be licensed, either with a trial or a purchased key).

3

What transport protocol does it use?

The server communicates over `stdio` only, so it must run on the same machine as the MCP client.

4

How do I configure the connection?

Create a `.prp` file containing the JDBC connection string (built via the driver’s GUI), the driver path, and a prefix/server name. Then point the client’s config file to the JAR and `.prp` file.

5

What tools does the server expose?

Three tools: `{prefix}_get_tables`, `{prefix}_get_columns`, and `{prefix}_run_query` (SELECT only). Output is in CSV format.

Comments

More Other MCP servers

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K
N

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Advertise