Presto MCP Server by CData

@CDataSoftware

About Presto 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 Presto (beta)](https://www.cdata.com/download/download.aspx?sku=ORZK-V&type=beta).

#presto #mcp-server #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\\presto.prp"
      ]
    }
  }
}

Tools

No tools detected

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

Overview

What is Presto MCP Server by CData?

Presto MCP Server by CData is a read-only Bridge between Large Language Models (such as Claude Desktop) and live Presto data. It wraps the CData JDBC Driver for Presto, exposing Presto tables as SQL models through the Model Context Protocol so LLMs can answer natural‑language questions without writing SQL.

How to use Presto MCP Server by CData?

Clone the repository, build the JAR with Maven (mvn clean install), download and license the CData JDBC Driver for Presto, generate a JDBC connection string using the driver’s GUI utility, create a .prp property file with your connection details, and add the server to your client’s config (e.g., claude_desktop_config.json). The server runs over stdio and must be on the same machine as the client.

Key features of Presto MCP Server by CData

Read‑only MCP server using CData JDBC Driver for Presto
Three built‑in tools: get_tables, get_columns, run_query
Accepts natural‑language questions, no SQL required
Requires Java, Maven, and a licensed CData JDBC Driver
Supports all Presto data sources reachable by the JDBC driver
Transport via stdio (same‑machine clients only)

Use cases of Presto MCP Server by CData

Query Presto data by asking plain‑English questions in Claude Desktop
Explore available tables and their columns without memorizing schemas
Execute SQL SELECT queries through an LLM interface
Provide live data answers for business analysis and reporting

FAQ from Presto MCP Server by CData

Is this server read‑only?

Yes. This project builds a read‑only MCP server. For full CRUD and action support, check the free CData MCP Server for Presto (beta) linked in the README.

What dependencies are required?

Java, Apache Maven (to build), and the CData JDBC Driver for Presto (must be downloaded, installed, and licensed).

How is the connection configured?

Use the JDBC driver’s connection‑string builder to create a JDBC URL, then place it in a .prp file along with driver path, driver class, and optional table filters.

Where does the data live?

Data remains in the Presto source. The server does not store or cache data; it queries live via the CData JDBC Driver.

What transport does the server use?

It uses stdio transport, so it only works with clients running on the same machine as the server.

Frequently asked questions

Is this server read‑only?

Yes. This project builds a read‑only MCP server. For full CRUD and action support, check the free CData MCP Server for Presto (beta) linked in the README.

What dependencies are required?

Java, Apache Maven (to build), and the CData JDBC Driver for Presto (must be downloaded, installed, and licensed).

How is the connection configured?

Use the JDBC driver’s connection‑string builder to create a JDBC URL, then place it in a `.prp` file along with driver path, driver class, and optional table filters.