io.github.coregentdevspace/sql-server-analyst-mcp MCP Server
io.github.coregentdevspace/sql-server-analyst-mcp
What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the io.github.coregentdevspace/sql-server-analyst-mcp MCP server?
Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
How to install io.github.coregentdevspace/sql-server-analyst-mcp
Copy-paste configuration for popular MCP clients.
MSSQL_SERVERrequiredSQL Server hostname or FQDN (e.g. <name>.database.windows.net for Azure SQL).
MSSQL_PORTTCP port (default 1433; set 0 for named instance with dynamic port).
MSSQL_DATABASEDefault database to connect to. Most tools also accept an override argument.
MSSQL_USERrequiredSQL authentication login name.
MSSQL_PASSWORDrequiredsecretSQL authentication password. Quote values containing '#' in .env files.
MSSQL_ENCRYPTEncrypt the connection (true|false). Required true for Azure SQL.
MSSQL_TRUST_SERVER_CERTTrust self-signed certificates (true|false). Use true only for local dev.
ALLOWED_DATABASESComma-separated allowlist of databases the server may access. Empty = unrestricted.
ALLOWED_SCHEMASComma-separated allowlist of schemas for schema tools. Empty = unrestricted.
MAX_ROWSDefault row limit per safe query (default 100).
MAX_ROWS_LIMITHard cap on query rows (default 1000).
QUERY_TIMEOUT_MSQuery execution timeout in milliseconds (default 30000).
LOG_LEVELerror | warn | info | debug (default info).
{
"mcpServers": {
"sql-server-analyst-mcp": {
"command": "npx",
"args": [
"-y",
"sql-server-analyst-mcp"
],
"env": {
"MSSQL_SERVER": "<YOUR_MSSQL_SERVER>",
"MSSQL_PORT": "<YOUR_MSSQL_PORT>",
"MSSQL_DATABASE": "<YOUR_MSSQL_DATABASE>",
"MSSQL_USER": "<YOUR_MSSQL_USER>",
"MSSQL_PASSWORD": "<YOUR_MSSQL_PASSWORD>",
"MSSQL_ENCRYPT": "<YOUR_MSSQL_ENCRYPT>",
"MSSQL_TRUST_SERVER_CERT": "<YOUR_MSSQL_TRUST_SERVER_CERT>",
"ALLOWED_DATABASES": "<YOUR_ALLOWED_DATABASES>",
"ALLOWED_SCHEMAS": "<YOUR_ALLOWED_SCHEMAS>",
"MAX_ROWS": "<YOUR_MAX_ROWS>",
"MAX_ROWS_LIMIT": "<YOUR_MAX_ROWS_LIMIT>",
"QUERY_TIMEOUT_MS": "<YOUR_QUERY_TIMEOUT_MS>",
"LOG_LEVEL": "<YOUR_LOG_LEVEL>"
}
}
}
}Related MCP servers
Semantic search knowledge base with serverless LanceDB. Zero setup, 100% local, 25+ file types

io.github.costkits/costkits-mcp
MCP server for CostKits: live healthcare procedure cost estimates and provider pricing.
Connect AI agents to Couchbase clusters for natural language data exploration, querying, and management.

text2sql
Ask any SQL database in natural language. Agent explores schema, writes SQL, self-corrects.

Open Archives
MCP server for Open Archives: Dutch genealogical records and historical page transcriptions.

Real User Monitoring for Core Web Vitals. Query LCP, INP, CLS field data from real visitors.
