Schema | mssql-mcp

mssql-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MSSQL_LOG`	No	Set to true to enable logging to mssql-mcp/mcp.log.	false
`MSSQL_PORT`	No	The TCP port for SQL Server.	1433
`MSSQL_USER`	Yes	The SQL Server authentication login name.
`MSSQL_SERVER`	Yes	The SQL Server hostname, FQDN, or IP address. For named instances, use HOST\INSTANCE.
`MSSQL_ENCRYPT`	No	Encrypt connection. Keep true for remote server.	true
`MSSQL_LOG_MAX`	No	Maximum characters per log entry before truncation.	20000
`MSSQL_DATABASE`	Yes	The default database to connect to.
`MSSQL_LOG_FILE`	No	Custom path for log file.
`MSSQL_PASSWORD`	Yes	The password for the login.
`MSSQL_RATE_MAX`	No	Maximum requests per window. 0 disables.	0
`MSSQL_READONLY`	No	If true, only SELECT and WITH are allowed.	true
`MSSQL_MAX_CONCURRENT`	No	Maximum concurrent queries. 0 disables.	0
`MSSQL_RATE_WINDOW_MS`	No	Window in milliseconds for rate limiting.	1000
`MSSQL_TRUST_SERVER_CERT`	No	Set to true only when server uses self-signed certificate.	false

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": true }

Functions exposed to the LLM to take actions

Name	Description
queryA	Execute a single SELECT query against SQL Server and return rows as JSON. Read-only: only SELECT / WITH statements are permitted. Rate limit: 30 requests per 60s, 4 concurrent; exceeding it returns an error with a retry time, so pace your calls.
analyze_queryA	Execute a SELECT under SET STATISTICS XML/IO/TIME and return structured performance data: per-operator estimated vs actual rows, logical/physical reads, statement timing, missing-index suggestions, and plan warnings. Use this to explain why a query is slow. Rate limit: 30 requests per 60s, 4 concurrent; exceeding it returns an error with a retry time, so pace your calls.
list_tablesA	List tables and views in the current database (INFORMATION_SCHEMA).
describe_tableA	Return columns, types, nullability and defaults for a table.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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