Skip to main content
Glama
vpro1032

MSSQL Database MCP Server

by vpro1032

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MSSQL_HOSTYesThe hostname or IP address of the MSSQL server
MSSQL_PORTNoThe port number for the MSSQL server1433
MSSQL_USERYesThe username for MSSQL authentication
IDLE_TIMEOUTNoSeconds before an idle connection closes300
MAX_POOL_SIZENoMaximum number of concurrent connections in the pool10
MIN_POOL_SIZENoMinimum number of connections to maintain in the pool2
MSSQL_ENCRYPTNoWhether to use TLS encryption for the connectiontrue
MSSQL_DATABASENoThe database name to connect tomaster
MSSQL_PASSWORDYesThe password for MSSQL authentication
CONNECTION_LIFETIMENoMaximum lifetime of a connection in seconds (30 minutes)1800
MSSQL_ALLOW_WRITE_OPERATIONSNoEnable write operations (INSERT, UPDATE, DELETE, stored procedures). Disabled by default for safetyfalse
MSSQL_TRUST_SERVER_CERTIFICATENoWhether to trust the server certificatetrue

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

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