Loading
Sql Server Analyst
io.github.coregentdevspaceClaim this server
Power your agent
Add this server
The publisher's own command. Not a PlugMCP endpoint.
Host a copy with our keys and logs.
Local command
npx -y [email protected]Credentials from the publisher
- MSSQL_SERVER — SQL Server hostname or FQDN (e.g. <name>.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 — SQL authentication login name.
- MSSQL_PASSWORD — 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).
Claude Code has no install link for a local command. Copy the command below and run it in a terminal.
shClaude Code
MSSQL_SERVER=<value> MSSQL_PORT=<value> MSSQL_DATABASE=<value> MSSQL_USER=<value> MSSQL_PASSWORD=<secret> MSSQL_ENCRYPT=<value> MSSQL_TRUST_SERVER_CERT=<value> ALLOWED_DATABASES=<value> ALLOWED_SCHEMAS=<value> MAX_ROWS=<value> MAX_ROWS_LIMIT=<value> QUERY_TIMEOUT_MS=<value> LOG_LEVEL=<value> claude mcp add io.github.coregentdevspace-sql-server-analyst-mcp -- npx -y sql-server-analyst-mcp@0.1.1Run in a terminal.
jsonClaude Desktop
{ "mcpServers": { "io.github.coregentdevspace-sql-server-analyst-mcp": { "command": "npx", "args": [ "-y", "[email protected]" ], "env": { "MSSQL_SERVER": "<value>", "MSSQL_PORT": "<value>", "MSSQL_DATABASE": "<value>", "MSSQL_USER": "<value>", "MSSQL_PASSWORD": "<secret>", "MSSQL_ENCRYPT": "<value>", "MSSQL_TRUST_SERVER_CERT": "<value>", "ALLOWED_DATABASES": "<value>", "ALLOWED_SCHEMAS": "<value>", "MAX_ROWS": "<value>", "MAX_ROWS_LIMIT": "<value>", "QUERY_TIMEOUT_MS": "<value>", "LOG_LEVEL": "<value>" } } }}claude_desktop_config.json
Local · npmPublisher installStep-by-step: add this in Claude
Remote URL or a command on your machine? How the two installs differ
Run on PlugMCP
Host a copy with our keys and logs.
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
LaunchServer facts
Local- Transport
Tools
Tools
No tool list yet. Remote servers get one after the first health check.
FAQ