MCP connector · Data warehouse

The MCP server for Azure Synapse Analytics

Point your AI at a Synapse dedicated SQL pool without handing out warehouse credentials. Read-only T-SQL one statement at a time, schema browsing, Data Sets on a schedule, and every query in an immutable audit log.

  • Free 7-day trial — 14 days for teams
  • Not charged until your trial ends
  • Cancel anytime
Capabilities

What you get with Azure Synapse Analytics

Everything below is enforced server-side — the AI client only ever sees governed tools and their results.

  • Live read-only T-SQL against a Synapse dedicated SQL pool over TDS
  • Schema browsing across schemas, tables, columns, and declared foreign keys
  • Data Sets refreshed on an interval or cron, with incremental refresh
  • Opt-in writes, owner-only and audited — off by default
  • SSRF-guarded, IP-pinned dialing; AES-256-GCM encrypted credentials
  • OAuth 2.1 + PKCE client auth with read-only team sharing
How it works

From sign-up to querying Azure Synapse Analytics in minutes

No infrastructure to stand up — connect, authorize, and start asking questions.

  1. 01

    Start the free trial.

  2. 02

    Allow mcpMyAdmin's egress address through your Synapse workspace firewall.

  3. 03

    Add the dedicated SQL pool with a read-only SQL login — encryption is pre-enabled.

  4. 04

    Connect Claude, ChatGPT, Cursor, or any MCP client over OAuth 2.1 + PKCE.

FAQ

Azure Synapse Analytics + mcpMyAdmin, answered

More connectors

Related engines

mcpMyAdmin connects to relational databases, warehouses, NoSQL stores, and SaaS sources — all through one governed MCP server.

Put Azure Synapse Analytics to work for your AI today

Governed access, encrypted credentials, and a full audit trail — up and running in minutes, free while you try it.

Start your free trial