Skip to main content
Glama
blimyj

mssql-mcp

by blimyj

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MSSQL_LOGNoSet to true to enable logging to mssql-mcp/mcp.log.false
MSSQL_PORTNoThe TCP port for SQL Server.1433
MSSQL_USERYesThe SQL Server authentication login name.
MSSQL_SERVERYesThe SQL Server hostname, FQDN, or IP address. For named instances, use HOST\INSTANCE.
MSSQL_ENCRYPTNoEncrypt connection. Keep true for remote server.true
MSSQL_LOG_MAXNoMaximum characters per log entry before truncation.20000
MSSQL_DATABASEYesThe default database to connect to.
MSSQL_LOG_FILENoCustom path for log file.
MSSQL_PASSWORDYesThe password for the login.
MSSQL_RATE_MAXNoMaximum requests per window. 0 disables.0
MSSQL_READONLYNoIf true, only SELECT and WITH are allowed.true
MSSQL_MAX_CONCURRENTNoMaximum concurrent queries. 0 disables.0
MSSQL_RATE_WINDOW_MSNoWindow in milliseconds for rate limiting.1000
MSSQL_TRUST_SERVER_CERTNoSet to true only when server uses self-signed certificate.false

Capabilities

Server capabilities have not been inspected yet.

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

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/blimyj/mssql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server