MCP SQL Server Gateway
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP SQL Server Gatewaylist databases in the server"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
<<<<<<< HEAD
MCP SQL Server Gateway
Enterprise-safe MCP server for Claude Enterprise access to approved on-prem SQL Server data.
Goal
Expose governed, auditable, read-only SQL Server tools through a remote MCP endpoint.
Related MCP server: SQL Server MCP
First principles
SQL Server remains private.
Claude never connects directly to SQL.
MCP gateway enforces authentication, authorization, query controls, logging, timeouts, and row limits.
Start with metadata, saved reports, and read-only SELECT access.
Prefer approved SQL views over raw tables.
Initial MCP tools
sql_list_databasessql_list_schemassql_list_tablessql_describe_tablesql_sample_rowssql_query_readonlysql_saved_report
Suggested phases
Project scaffold and local mock MCP server.
Read-only SQL connector against dev SQL.
AuthN/AuthZ and allowlist policy.
AKS deployment behind existing MCP ingress pattern.
Claude Enterprise custom connector registration.
Observability, audit, and production hardening.
cp-apps-mcp-onpremsql
a09eb63f3769fc96fe2e82314af1d8c0db9aa3bb
This server cannot be deployed
Maintenance
Related MCP Connectors
Cloud-hosted MCP server for secure AI access to enterprise data sources via CData Connect AI.
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.
Related MCP Servers
- AlicenseNot gradedqualityFmaintenanceAn MCP server for Microsoft SQL Server integration that enables users to query, monitor, and analyze databases directly through Claude. It supports schema exploration, performance analysis, and optional write operations via natural language commands.4 npm1MIT
- AlicenseAqualityDmaintenanceA read-only MCP server for SQL Server database introspection that enables Claude to explore and query databases via tools like listing objects and executing SELECT queries.201MIT
- AlicenseBqualityDmaintenanceAn MCP server that connects AI assistants to Microsoft SQL Server databases, enabling schema exploration and read-only queries safely.4914 npm4MIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol (MCP) server for SQL Server / Azure SQL that enables querying, monitoring, and analyzing databases directly from Claude.6 npmMIT