MSSQL MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PORT | No | Port for HTTP transport. Default '3000'. | |
| MSSQL_PORT | No | Port number. Defaults to SQL Server default (1433). | |
| MSSQL_USER | No | Login username. Required in single-database mode. | |
| MSSQL_SERVER | No | Hostname or IP of the SQL Server. Required in single-database mode; default 'localhost'. | |
| MSSQL_ENCRYPT | No | Set 'true' to encrypt the connection. Default 'false'. | |
| MSSQL_DATABASE | No | Database name for single-database mode. Required in that mode. | |
| MSSQL_PASSWORD | No | Login password. Required in single-database mode. | |
| MSSQL_MAINDB_PORT | No | Port for multi-database mode. | |
| MSSQL_MAINDB_USER | No | User for multi-database mode. Falls back to MSSQL_USER. | |
| MSSQL_ENABLE_WRITES | No | Set 'true' to enable write queries. Default 'false'. | |
| MSSQL_MAINDB_SERVER | No | Server for multi-database mode (replace 'MAINDB' with your key). Falls back to MSSQL_SERVER. | |
| MSSQL_MAINDB_ENCRYPT | No | Encrypt setting for multi-database mode. | |
| MSSQL_MAINDB_DATABASE | No | Database name for multi-database mode. Required for each database key. | |
| MSSQL_MAINDB_PASSWORD | No | Password for multi-database mode. Falls back to MSSQL_PASSWORD. | |
| MSSQL_REPORTINGDB_PORT | No | Port for reporting DB. | |
| MSSQL_REPORTINGDB_USER | No | User for reporting DB. | |
| MSSQL_REPORTINGDB_SERVER | No | Server for another multi-database key (example). | |
| MSSQL_REPORTINGDB_ENCRYPT | No | Encrypt for reporting DB. | |
| MSSQL_REPORTINGDB_DATABASE | No | Database name for reporting DB. | |
| MSSQL_REPORTINGDB_PASSWORD | No | Password for reporting DB. | |
| MSSQL_TRUST_SERVER_CERTIFICATE | No | Set 'false' to enforce certificate validation. Default 'true'. | |
| MSSQL_MAINDB_TRUST_SERVER_CERTIFICATE | No | Trust certificate setting for multi-database mode. | |
| MSSQL_REPORTINGDB_TRUST_SERVER_CERTIFICATE | No | Trust cert for reporting DB. |
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
ResponsivenessResponsive