presto-mcp-server-by-cdata

presto-mcp-server-by-cdata

3.2

If you are the rightful owner of presto-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 Presto is a read-only server that allows LLMs to query live data from Presto using the CData JDBC Driver.

The Presto MCP Server by CData is designed to facilitate the interaction between large language models (LLMs) and live data from Presto databases. By leveraging the CData JDBC Driver, this server exposes Presto data as relational SQL models, enabling LLMs to query data using natural language without the need for SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask questions in natural language and receive data-driven responses. The server is read-only, but a full-featured version with read, write, update, and delete capabilities is available in beta. The setup involves cloning the repository, building the server, licensing the JDBC driver, and configuring the connection to the data source. Once set up, the server can be integrated with clients like Claude Desktop to provide seamless data access.

Features

  • Read-only access to Presto data via MCP interface
  • Integration with CData JDBC Driver for Presto
  • Natural language querying without SQL
  • Support for various data sources through JDBC
  • Configurable connection settings for tailored access

Tools

  1. {servername}_get_tables

    Get a list of available tables in the data source

  2. {servername}_get_columns

    Get column information for the specified table

  3. {servername}_run_query

    Execute SQL SELECT query