Schema | mcp-mssql-secure

mcp-mssql-secure

Describes the environment variables required to run the server.

Name	Required	Description	Default
`MSSQL_HOST`	Yes	Database host (required).
`MSSQL_PORT`	No	Database port (default: 1433).	1433
`MSSQL_USER`	Yes	SQL authentication login (required).
`MSSQL_ENCRYPT`	No	Enable TLS encryption (default: true). Use 'true' or 'false'.	true
`MSSQL_DATABASE`	Yes	Database name (required).
`MSSQL_PASSWORD`	Yes	SQL authentication password (required).
`MSSQL_ACCESS_MODE`	No	Access mode: 'readonly' (default), 'dml', or 'full'. Can be overridden by --access-mode CLI flag.	readonly
`MSSQL_LOCK_CONNECTION`	No	Disables connect_db at runtime when true (default: true when env config is set). Use 'true' or 'false'.	true
`MSSQL_TRUST_SERVER_CERTIFICATE`	No	Trust self-signed certificates (default: false). Use 'true' or 'false'. Recommended for on-prem dev with self-signed certs.	false

Features and capabilities supported by this server

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
connect_dbD	Disabled when MSSQL_LOCK_CONNECTION=true (use environment variables instead)
queryA	Execute a read-only SQL query (SELECT, WITH, EXPLAIN, TABLE, VALUES)
list_schemasA	List all schemas in the database
list_tablesC	List tables in the database
describe_tableC	Get table structure
list_programmable_objectsA	List stored procedures, functions, views, and triggers (read-only metadata)
describe_programmable_objectA	Get full T-SQL definition and parameters for a stored procedure, function, view, or trigger (read-only; does not execute)

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

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