Schema | MCP SQL Server Tool

MCP SQL Server Tool

Describes the environment variables required to run the server.

Name	Required	Description
`MCPMSSQL_DESCRIPTION`	No	Optional description for the default profile (tooling/AI discovery)
`MCPMSSQL_QUERY_MAX_ROWS`	No	Optional max rows per interactive query (default 500; hard ceiling 1000)
`MCPMSSQL_CONNECTION_STRING`	Yes	Required connection string for SQL Server (e.g., Server=127.0.0.1;User ID=sa;Password=<YourStrong@Passw0rd>;Encrypt=True;TrustServerCertificate=True;)
`MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS`	No	Optional max rows for snapshot queries (default 10000; hard ceiling 50000)
`MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS`	No	Optional query timeout in seconds (default 30)
`MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS`	No	Optional analyze timeout in seconds (default 300)
`MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS`	No	Optional snapshot query timeout in seconds (default 120)

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.

Server capabilities have not been inspected yet.

Functions exposed to the LLM to take actions

Name	Description
No tools

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

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