Enables interaction with Microsoft SQL Server databases through T-SQL query execution, table exploration, and schema inspection. Supports configurable write protection and row limiting for safe database operations.
Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find.
Install from
M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.
process.env. You'll be asked to provide them before it can run.MSSQL_ALLOW_WRITES— no false If false/unset, blocks common write/DDL/exec patterns in mssql_query (heuristic only)MSSQL_APP_NAME— no — options.appName (server tracing)MSSQL_AUTH_TYPE— MSSQL_DOMAIN no — Domain login (config.domain for SQL auth; required for =ntlm)MSSQL_AZURE_ACCESS_TOKEN— no‡ — Pre-obtained token for access-token authMSSQL_AZURE_CLIENT_ID— no‡ — Azure AD app (client) ID where requiredMSSQL_AZURE_CLIENT_SECRET— no‡ — Service principal secretMSSQL_AZURE_TENANT_ID— no‡ — Tenant ID (optional for password auth, defaults common; required for service principal)MSSQL_CONNECTION_RETRY_INTERVAL_MS— no — Tedious connectionRetryInterval; 0 → unsetMSSQL_CONNECTION_TIMEOUT_MS— no (driver default) Pool connectionTimeout (ms). 0 → unsetMSSQL_DATABASE— "": "your_database",MSSQL_DOMAIN— no — Domain login (config.domain for SQL auth; required for MSSQL_AUTH_TYPE=ntlm)MSSQL_ENCRYPT— no true TLS encrypt: true, false, or strict (TDS 8.0 / tedious)MSSQL_INSTANCE_NAME— MSSQL_PORT no 1433 TCP port; omit when using (driver uses instance + SQL Browser)MSSQL_MAX_RETRIES_ON_TRANSIENT_ERRORS— no — Tedious maxRetriesOnTransientErrors; 0 → unsetMSSQL_MULTI_SUBNET_FAILOVER— no false Availability-group style failover hintMSSQL_PASSWORD— "": "your_password",MSSQL_POOL_IDLE_TIMEOUT_MS— no 30000 pool.idleTimeoutMillisMSSQL_POOL_MAX— no 10 Pool max connectionsMSSQL_POOL_MIN— no 0 Pool min connectionsMSSQL_PORT— no 1433 TCP port; omit when using MSSQL_INSTANCE_NAME (driver uses instance + SQL Browser)MSSQL_QUERY_TIMEOUT_MS— no (driver default) Request timeout in ms for the driver. 0 → unsetMSSQL_READ_ONLY_INTENT— no false Read-only routing for AG secondariesMSSQL_SERVER— "": "localhost",MSSQL_TDS_VERSION— no — 7_1, 7_2, 7_3_A, 7_3_B, or 7_4MSSQL_TLS_CA_FILE— no — Path to CA PEM; passed via cryptoCredentialsDetails.caMSSQL_TLS_CERT_FILE— no — Optional client cert PEM (mutual TLS)MSSQL_TLS_KEY_FILE— no — Optional client private key PEMMSSQL_TLS_KEY_PASSPHRASE— no — Passphrase for encrypted client keyMSSQL_TLS_SERVER_NAME— no — Hostname for TLS validation when it differs from MSSQL_SERVER (e.g. connect by IP)MSSQL_TRUST_SERVER_CERTIFICATE— "": "true"MSSQL_USER— "": "your_user",MSSQL_USE_UTC— no true options.useUTC when set[](https://m8ven.ai/mcp/adriancy-mssql-mcp-1iq2o2)