azure-synapse-mcp-server-by-cdata

azure-synapse-mcp-server-by-cdata

0

The CData Model Context Protocol (MCP) Server for Azure Synapse allows integration of Azure Synapse data with large language models through a simple interface. This read-only server enables querying of live data without using SQL, leveraging the CData JDBC Driver for connectivity.

Azure Synapse MCP Server by CData

CData's Model Context Protocol (MCP) Server for Azure Synapse provides a read-only server to allow large language models (LLMs) to query live Azure Synapse data without needing to write SQL. The server uses the CData JDBC Driver and exposes data through a simple MCP interface for LLMs to query with natural language.

Purpose

  • Query live Azure Synapse data with LLMs like Claude Desktop.
  • Connected via CData JDBC Driver, making it accessible as relational SQL models.

Setup Guide

  • Clone the repository and build the server.
  • Install and license the CData JDBC Driver.
  • Configure the connection to the data source.

Usage Details

  • AI clients can read, write, update, and delete data by asking questions in natural language.

Tools & Descriptions

  • Retrieve tables and columns available in the data source.
  • Execute SELECT queries using the tools provided.