airtable-mcp-server-by-cdata

airtable-mcp-server-by-cdata

3.2

If you are the rightful owner of airtable-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

CData's Model Context Protocol (MCP) Server for Airtable is a read-only server designed to allow LLMs to query live Airtable data using natural language.

The CData MCP Server for Airtable is a specialized server that facilitates the interaction between large language models (LLMs) and Airtable data. By leveraging the CData JDBC Driver for Airtable, this server exposes Airtable data as relational SQL models, enabling LLMs to access and query live data without the need for SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve information from Airtable. The server is read-only, meaning it allows for data retrieval but not modification. For full CRUD capabilities, users are encouraged to explore the CData MCP Server for Airtable (beta). The server is built using Java and requires the CData JDBC Driver to be installed and licensed. It supports a simple setup process and can be integrated with various platforms through JSON-RPC requests.

Features

  • Read-only access to Airtable data through natural language queries.
  • Integration with LLMs like Claude Desktop for seamless data retrieval.
  • Utilizes CData JDBC Driver to expose Airtable as relational SQL models.
  • Simple setup process with detailed configuration instructions.
  • JSON-RPC support for scripting and automation.

Tools

  1. airtable_get_tables

    Retrieves a list of tables available in the data source.

  2. airtable_get_columns

    Retrieves a list of columns for a specified table.

  3. airtable_run_query

    Executes a SQL SELECT query on the data source.