manjotsingh20/azure-synapse-mcp
Free, open-source MCP server for Azure Synapse Analytics. Full CRUD SQL, Pipelines, Spark & Notebooks. No paid drivers. Works with Claude, Cursor & any MCP client.
Platform-specific configuration:
{
"mcpServers": {
"azure-synapse-mcp": {
"command": "npx",
"args": [
"-y",
"azure-synapse-mcp"
]
}
}
}Add the config above to .claude/settings.json under the mcpServers key.
[](https://pypi.org/project/azure-synapse-mcp/) [](LICENSE) [](https://www.python.org/) [](https://modelcontextprotocol.io)
A free, open-source Model Context Protocol (MCP) server for Azure Synapse Analytics — giving Claude, Cursor, and any MCP-compatible AI client full access to your Synapse workspace.
> ✅ No paid drivers. No Java. No vendor lock-in. > Uses Microsoft's free ODBC Driver and official Azure Python SDKs.
---
| Category | Tools | |---|---| | SQL / Data | list_databases, list_tables, describe_table, run_query, run_statement, get_table_stats | | Pipelines | list_pipelines, run_pipeline, get_pipeline_run_status | | Spark | list_spark_jobs, submit_spark_job | | Notebooks | list_notebooks |
| | This server | CData server | |---|---|---| | License | ✅ Free & open-source | ❌ Requires paid JDBC driver | | Language | ✅ Python (pip install) | ❌ Java (Maven build required) | | Auth | ✅ Azure AD, MI, SP, SQL | ❌ Connection string only | | Write support | ✅ INSERT / UPDATE / DELETE / DDL | ❌ Read-only | | Pipelines | ✅ List, trigger, monitor | ❌ Not supported | | Spark | ✅ Submit and list jobs | ❌ Not supported | | Notebooks | ✅ List notebooks | ❌ Not supported |
---
Loading reviews...