MCP SQL Server
by alyiox
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCPMSSQL_DESCRIPTION | No | Optional description for the default profile (tooling/AI discovery) | |
| MCPMSSQL_QUERY_MAX_ROWS | No | Optional max rows per interactive query (default 500; hard ceiling 1000) | |
| MCPMSSQL_CONNECTION_STRING | Yes | Required connection string for SQL Server (e.g., Server=127.0.0.1;User ID=sa;Password=<YourStrong@Passw0rd>;Encrypt=True;TrustServerCertificate=True;) | |
| MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS | No | Optional max rows for snapshot queries (default 10000; hard ceiling 50000) | |
| MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS | No | Optional query timeout in seconds (default 30) | |
| MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS | No | Optional analyze timeout in seconds (default 300) | |
| MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS | No | Optional snapshot query timeout in seconds (default 120) |
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
ActivityActive
ResponsivenessUnresponsive