Skip to main content
Glama

MSSQL MCP Server

by jensenloke

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MSSQL_PORTNoPort number1433
MSSQL_USERNoUsername for authentication
MSSQL_DRIVERNoODBC driver name{ODBC Driver 17 for SQL Server}
MSSQL_SERVERYesServer hostname or IP address
MSSQL_DATABASEYesDatabase name to connect to
MSSQL_PASSWORDNoPassword for authentication
Trusted_ConnectionNoUse Windows authenticationno
TrustServerCertificateNoTrust server certificateyes

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

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/jensenloke/mcp-sqlserver-pro'

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