Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
Sql-server-analyst-mcp is an MCP integration. Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
The published npm package is sql-server-analyst-mcp, version 0.1.1. Its declared MCP transport is stdio.
The package declares MSSQL_SERVER (required): SQL Server hostname or FQDN (e.g. .database.windows.net for Azure SQL).; MSSQL_PORT: TCP port (default 1433; set 0 for named instance with dynamic port).; MSSQL_DATABASE: Default database to connect to. Most tools also accept an override argument.; MSSQL_USER (required): SQL authentication login name.; MSSQL_PASSWORD (required): SQL authentication password. Quote values containing '' in .env files.; MSSQL_ENCRYPT: Encrypt the connection (true|false). Required true for Azure SQL.; MSSQL_TRUST_SERVER_CERT: Trust self-signed certificates (true|false). Use true only for local dev.; ALLOWED_DATABASES: Comma-separated allowlist of databases the server may access. Empty = unrestricted.; ALLOWED_SCHEMAS: Comma-separated allowlist of schemas for schema tools. Empty = unrestricted.; MAX_ROWS: Default row limit per safe query (default 100).; MAX_ROWS_LIMIT: Hard cap on query rows (default 1000).; QUERY_TIMEOUT_MS: Query execution timeout in milliseconds (default 30000).; LOG_LEVEL: error | warn | info | debug (default info)..
Check the maintainer’s instructions for account access, authentication and the supported client configuration. Once connected, inspect the tools your client receives and try a small task that matches the server’s stated purpose. The registry description does not include a verified, complete tool list.
View the publisher’s registry entry · Project repository. This profile uses version 0.1.1 from the registry. Registration identifies the publisher namespace; it does not establish that this is a first-party integration for every service it connects.
Browse related databases MCP servers for tools that cover the same kind of work.
| Variable | Description | Required |
|---|---|---|
| MSSQL_SERVER | SQL Server hostname or FQDN (e.g. .database.windows.net for Azure SQL). | Yes |
| MSSQL_PORT | TCP port (default 1433; set 0 for named instance with dynamic port). | Optional |
| MSSQL_DATABASE | Default database to connect to. Most tools also accept an override argument. | Optional |
| MSSQL_USER | SQL authentication login name. | Yes |
| MSSQL_PASSWORD | SQL authentication password. Quote values containing '' in .env files. | Yes |
| MSSQL_ENCRYPT | Encrypt the connection (true|false). Required true for Azure SQL. | Optional |
| MSSQL_TRUST_SERVER_CERT | Trust self-signed certificates (true|false). Use true only for local dev. | Optional |
| ALLOWED_DATABASES | Comma-separated allowlist of databases the server may access. Empty = unrestricted. | Optional |
| ALLOWED_SCHEMAS | Comma-separated allowlist of schemas for schema tools. Empty = unrestricted. | Optional |
| MAX_ROWS | Default row limit per safe query (default 100). | Optional |
| MAX_ROWS_LIMIT | Hard cap on query rows (default 1000). | Optional |
| QUERY_TIMEOUT_MS | Query execution timeout in milliseconds (default 30000). | Optional |
| LOG_LEVEL | error | warn | info | debug (default info). | Optional |
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
Use the Supabase MCP server to inspect database schemas, query project data and retrieve docs through a project-scoped connection.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.