sql-server-mcp
by ahaugerud
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_MAX_ROWS | No | Max rows returned per tool call (default: 25) | 25 |
| MCP_SQL_PASSWORD | No | SQL login password. Must be set together with `MCP_SQL_USERNAME` | |
| MCP_SQL_USERNAME | No | SQL login username. If set, the server uses username + password authentication instead of Entra ID (and `MCP_AZURE_TENANT_ID` is not needed) | |
| MCP_SQL_LEGACY_TLS | No | Set to `true` for old SQL Server hosts (e.g. SQL Server 2012) that reset the connection during the TLS handshake (`TCP Provider: Error code 0x2746`). Lowers OpenSSL's security level to 0 for this process (and its child processes), so it requires SQL login and is best avoided elsewhere. Default: `false` | false |
| MCP_AZURE_TENANT_ID | No | The Entra ID tenant ID — pins auth to this directory even if your machine has other `az login` sessions active | |
| MCP_SQL_SERVER_NAME | Yes | SQL Server / Fabric SQL endpoint hostname, e.g. `xyz-xyz.datawarehouse.fabric.microsoft.com` | |
| MCP_SQL_DATABASE_NAME | Yes | Default database to connect to | |
| MCP_SQL_TRUST_SERVER_CERTIFICATE | No | Set to `true` to skip server certificate validation (needed for servers with self-signed or otherwise untrusted certificates, e.g. older on-prem SQL Server). Default: `false` | false |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo issues