MSSQL MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MSSQL_HOSTNoDatabase server hostnamelocalhost
MSSQL_PORTNoDatabase server port1433
MSSQL_USERNoDatabase username
MSSQL_ENCRYPTNoEnable encryptionfalse
MSSQL_DATABASENoDatabase namemaster
MSSQL_PASSWORDNoDatabase password
MSSQL_CONNECTION_STRINGNoFull connection string to the MSSQL database.
MSSQL_TRUST_SERVER_CERTIFICATENoTrust server certificatetrue

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools