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 | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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