presto-mcp-server-by-cdata

presto-mcp-server-by-cdata

0
research_and_datadatabases

The project is a read-only Model Context Protocol (MCP) Server by CData for Presto. It connects Presto data to large language models, enabling natural language querying without needing SQL. The server utilizes CData's JDBC Driver to provide seamless data interaction.

CData's Model Context Protocol (MCP) Server for Presto

  • Purpose: This project is a read-only MCP Server designed to enable large language models (LLMs) to query live data from Presto via the CData JDBC Driver.
  • Features:
    • Converts Presto data into a relational SQL model accessible through a simple MCP interface.
    • Allows LLMs to retrieve information using natural language questions.

Setup Guide

  • Steps:
    1. Clone the repository and build the server.
    2. Install and license the CData JDBC Driver for Presto.
    3. Configure the server with a .prp file and connection string.

Usage

  • Enables AI clients to read, write, update, and delete data without explicit tool calls, using natural language.

Tools & Descriptions

  • {servername}_get_tables: Retrieves available tables.
  • {servername}_get_columns: Retrieves columns from a table.
  • {servername}_run_query: Executes SQL queries.

License

  • Licensed under the MIT License, allowing free use, modification, and distribution.