Schema | mcp-sql

mcp-sql

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MCPSQL_HOST`	No	Database server host.
`MCPSQL_PORT`	No	Database server port.
`MCPSQL_DB_TYPE`	No	Engine type (e.g., mssql).
`AZURE_CLIENT_ID`	No	Azure client ID for service principal auth.
`AZURE_TENANT_ID`	No	Azure tenant ID for service principal auth.
`MCPSQL_DATABASE`	No	Database name.
`MCPSQL_MAX_ROWS`	No	Row cap for queries (default 1000).	1000
`MCPSQL_PASSWORD`	No	SQL Server login password (for sql_password auth).
`MCPSQL_USERNAME`	No	SQL Server login username (for sql_password auth).
`MCPSQL_AUTH_METHOD`	No	Authentication method (sql_password, windows, azure_ad).
`MCPSQL_CONNECTIONS`	No	JSON mapping of connection names to ODBC strings (for map backend).
`MCPSQL_ODBC_DRIVER`	No	ODBC driver name (default 'ODBC Driver 18 for SQL Server').	ODBC Driver 18 for SQL Server
`AZURE_CLIENT_SECRET`	No	Azure client secret for service principal auth.
`MCPSQL_KEYVAULT_URL`	No	Azure Key Vault URL for resolving connections (for keyvault backend).
`MCPSQL_AZURE_AUTH_MODE`	No	Azure AD token acquisition mode (default, service_principal, managed_identity).
`MCPSQL_CONNECTION_BACKEND`	No	Connection backend: static, map, keyvault.	static
`MCPSQL_CONNECTION_ALLOWLIST`	No	Comma-separated list of allowed connection names.
`MCPSQL_CONNECTION_CACHE_TTL`	No	Cache TTL for resolved connections in seconds.

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

This server cannot be deployed

ActivityInactive

ResponsivenessNo issues