Azure Synapse MCP Server by CData

Created By

CDataSoftware7 months ago

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

# azure-synapse

# mcp-server

Overview Content Tools Comments

Overview

What is Azure Synapse MCP Server?

Azure Synapse MCP Server by CData is a read-only Model Context Protocol (MCP) server designed to allow large language models (LLMs) to query live data from Azure Synapse without needing SQL knowledge.

How to use Azure Synapse MCP Server?

To use the server, clone the repository, build the server, install the CData JDBC Driver, configure your connection, and create a configuration file for your AI client (e.g., Claude Desktop).

Key features of Azure Synapse MCP Server?

Provides a read-only interface to Azure Synapse data.
Allows natural language queries to retrieve live data.
Simplifies data access for LLMs without SQL.

Use cases of Azure Synapse MCP Server?

Querying live data from Azure Synapse using natural language.
Integrating with AI clients for data analysis and reporting.
Enabling data-driven decision-making through easy access to data.

FAQ from Azure Synapse MCP Server?

Can I write data using this server?

No, this server is read-only. For write capabilities, consider the full CData MCP Server for Azure Synapse.

Is there a trial version available?

Yes, you can access a free trial of the CData MCP Server for Azure Synapse.

What kind of data sources can I connect to?

The server supports various data sources, including Salesforce, and many more.

Server Config

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\azure-synapse.prp"
      ]
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

WindsurfThe new purpose-built IDE to harness magic

Tavily Mcp

Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors

Amap Maps高德地图官方 MCP Server

Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

Serper MCP ServerA Serper MCP Server