MCP.so
Sign In

Azure Synapse MCP Server by CData

@CDataSoftware

Repository

About Azure Synapse MCP Server by CData

This read-only MCP Server allows you to connect to Azure Synapse data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

#azure-synapse#mcp-server#data-access

Basic information

Category

Cloud & Infrastructure

License

MIT

Runtime

java

Transports

stdio

Publisher

CDataSoftware

Submitted by

Cameron Leblanc

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\\azure-synapse.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 Azure Synapse MCP Server by CData?

A read-only MCP server that allows LLMs (like Claude Desktop) to query live Azure Synapse data via natural language questions, powered by the CData JDBC Driver for Azure Synapse.

How to use Azure Synapse MCP Server by CData?

Clone the repo, build with Maven, install and license the CData JDBC Driver, create a .prp file with connection properties, then configure Claude Desktop’s claude_desktop_config.json to point to the built JAR and .prp file. Run or refresh Claude Desktop to use the tools.

Key features of Azure Synapse MCP Server by CData

  • Query live Azure Synapse data using natural language.
  • Provides tools: get_tables, get_columns, run_query.
  • Built on the CData JDBC Driver for Azure Synapse.
  • Local, read-only MCP server via stdio transport.
  • Supports all tables by default or explicit table selection.

Use cases of Azure Synapse MCP Server by CData

  • Ask LLMs about Azure Synapse data trends without writing SQL.
  • Retrieve table and column metadata for data exploration.
  • Run SQL SELECT queries through an AI assistant interface.

FAQ from Azure Synapse MCP Server by CData

Is this server read-only or does it support write/update/delete?

The README states this project builds a local, read-only MCP server. For full CRUD capabilities, see the CData MCP Server for Azure Synapse.

What runtime requirements are needed?

You need Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Azure Synapse (requires installation and licensing). The driver is not bundled.

How does the server communicate with clients?

The server uses stdio transport, so it can only be used with clients running on the same machine as the server.

What authentication methods are supported?

The connection string can include OAuth (e.g., InitiateOAuth=GETANDREFRESH). OAuth-based sources will require browser authentication during setup.

Where does the data reside?

Data remains in Azure Synapse. The server queries live data; it does not store or cache any data locally.

Comments

More Cloud & Infrastructure MCP servers

GCP MCP

eniayomi

A Model Context Protocol (MCP) server that enables AI assistants like Claude to interact with your Google Cloud Platform environment. This allows for natural language querying and management of your GCP resources during conversations.

200

K8s MCP Server

alexei-led

K8s-mcp-server is a Model Context Protocol (MCP) server that enables AI assistants like Claude to securely execute Kubernetes commands. It provides a bridge between language models and essential Kubernetes CLI tools including kubectl, helm, istioctl, and argocd, allowing AI syste

212

AWS MCP

RafalWilinski

Talk with your AWS using Claude. Model Context Protocol (MCP) server for AWS. Better Amazon Q alternative.

295

tfmcp: Terraform Model Context Protocol Tool

nwiizo

🌍 Terraform Model Context Protocol (MCP) Tool - An experimental CLI tool that enables AI assistants to manage and operate Terraform environments. Supports reading Terraform configurations, analyzing plans, applying configurations, and managing state with Claude Desktop integrati

370

container-use

dagger

Development environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.

3.9K