sql-server-analyst-mcp
Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.
Open the source (opens github.com) https://github.com/coregentdevspace/sql-server-analyst-mcp
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: MSSQL_PASSWORD. Use a key with the least access you can.
What it is
MCP servers from io.github.coregentdevspace.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
npm package (stdio)
sql-server-analyst-mcp@0.1.1
From the server's entry in the official MCP Registry
Settings it asks for
MSSQL_SERVERrequired · 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_USERrequired · SQL authentication login name.MSSQL_PASSWORDsecret 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).
Related
-
GitHub MCP server
MCP serversGitHub's official MCP server. It lets an agent read and work with repositories, issues and pull requests.
https://api.githubcopilot.com/mcp/ -
Apify MCP server
MCP serversLets an agent run Apify's ready-made scrapers to pull data from websites, search engines, maps and social platforms.
-
Official MCP Registry
MCP serversThe MCP project's own registry of public MCP servers, so you can look for a connector before building one.
-
MCP reference servers
MCP serversSmall example servers from the MCP project (filesystem, git, fetch, memory and more) that show how MCP works.
-
Connect MCP servers to Claude Code
MCP serversAnthropic's guide to adding MCP servers to Claude Code, with examples of local and remote servers.
-
Playwright MCP
MCP serversLets an agent drive a real browser: open pages, click, fill in forms and read what's on screen.
claude mcp add playwright npx @playwright/mcp@latest