Schema | mssql-mcp

mssql-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DB_USER`	Yes	SQL Server username (for SQL authentication)
`MAX_ROWS`	No	Maximum rows returned by read tools (default: 10000)	10000
`READONLY`	No	true for read-only mode, false for full access	false
`DATABASES`	No	Comma-separated allowlist for multi-database access (e.g., ProdDB,StagingDB)
`ENABLE_DDL`	No	true enables create_table, create_index, drop_table (default: false)	false
`DB_PASSWORD`	Yes	SQL Server password (for SQL authentication)
`SERVER_NAME`	Yes	SQL Server host (e.g., localhost, my-server.database.windows.net)
`MCP_BASE_URL`	No	Optional externally visible base URL for remote deployments
`DATABASE_NAME`	No	Default database name. Optional when DATABASES is set.
`MCP_HTTP_HOST`	No	Bind host for Streamable HTTP mode (default: 127.0.0.1)	127.0.0.1
`MCP_HTTP_PORT`	No	Bind port for Streamable HTTP mode (default: 3333)	3333
`MCP_TRANSPORT`	No	stdio (default) or http	stdio
`MAX_WRITE_ROWS`	No	Maximum rows a single write tool may affect before blocked (default: 100)	100
`QUERY_TIMEOUT_MS`	No	Query timeout in milliseconds (default: 30000)	30000
`CONNECTION_TIMEOUT`	No	Timeout in seconds (default: 30)	30
`REQUIRE_WRITE_PREVIEW`	No	true (default) requires preview token for update/delete; false skips token	true
`TRUST_SERVER_CERTIFICATE`	No	true for self-signed certs (default: false)	false

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

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