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. |
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 | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/mihai-dulgheru/mssql-mcp-node'
If you have feedback or need assistance with the MCP directory API, please join our Discord server