cosmic-mcp

All servers

sql-server-analyst-mcp

io.github.coregentdevspace/sql-server-analyst-mcp · version 0.1.1

Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.

Read-only SQL Server Analyst MCP — safe schema, stored procedure, and performance analysis.

https://github.com/coregentdevspace/sql-server-analyst-mcp

Quick facts

  • Listing: Community
  • Published Apr 22, 02:08 UTC
  • Transport: stdio
  • Package: npm sql-server-analyst-mcp 0.1.1
  • Listed by cosmic-mcp: Nov 8, 18:59 UTC

Databases

Setup snippets

Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.

Run it locally (npm)

npx -y '[email protected]'

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "ALLOWED_DATABASES": "<your allowed databases>",
        "ALLOWED_SCHEMAS": "<your allowed schemas>",
        "LOG_LEVEL": "<your log level>",
        "MAX_ROWS": "<your max rows>",
        "MAX_ROWS_LIMIT": "<your max rows limit>",
        "MSSQL_DATABASE": "<your mssql database>",
        "MSSQL_ENCRYPT": "<your mssql encrypt>",
        "MSSQL_PASSWORD": "<your mssql password>",
        "MSSQL_PORT": "<your mssql port>",
        "MSSQL_SERVER": "<your mssql server>",
        "MSSQL_TRUST_SERVER_CERT": "<your mssql trust server cert>",
        "MSSQL_USER": "<your mssql user>",
        "QUERY_TIMEOUT_MS": "<your query timeout ms>"
      }
    }
  }
}

Claude Code

claude mcp add 'sql-server-analyst-mcp' -- npx -y '[email protected]'

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "sql-server-analyst-mcp": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "ALLOWED_DATABASES": "<your allowed databases>",
        "ALLOWED_SCHEMAS": "<your allowed schemas>",
        "LOG_LEVEL": "<your log level>",
        "MAX_ROWS": "<your max rows>",
        "MAX_ROWS_LIMIT": "<your max rows limit>",
        "MSSQL_DATABASE": "<your mssql database>",
        "MSSQL_ENCRYPT": "<your mssql encrypt>",
        "MSSQL_PASSWORD": "<your mssql password>",
        "MSSQL_PORT": "<your mssql port>",
        "MSSQL_SERVER": "<your mssql server>",
        "MSSQL_TRUST_SERVER_CERT": "<your mssql trust server cert>",
        "MSSQL_USER": "<your mssql user>",
        "QUERY_TIMEOUT_MS": "<your query timeout ms>"
      }
    }
  }
}

VS Code (.vscode/mcp.json)

{
  "servers": {
    "sql-server-analyst-mcp": {
      "args": [
        "-y",
        "[email protected]"
      ],
      "command": "npx",
      "env": {
        "ALLOWED_DATABASES": "<your allowed databases>",
        "ALLOWED_SCHEMAS": "<your allowed schemas>",
        "LOG_LEVEL": "<your log level>",
        "MAX_ROWS": "<your max rows>",
        "MAX_ROWS_LIMIT": "<your max rows limit>",
        "MSSQL_DATABASE": "<your mssql database>",
        "MSSQL_ENCRYPT": "<your mssql encrypt>",
        "MSSQL_PASSWORD": "<your mssql password>",
        "MSSQL_PORT": "<your mssql port>",
        "MSSQL_SERVER": "<your mssql server>",
        "MSSQL_TRUST_SERVER_CERT": "<your mssql trust server cert>",
        "MSSQL_USER": "<your mssql user>",
        "QUERY_TIMEOUT_MS": "<your query timeout ms>"
      },
      "type": "stdio"
    }
  }
}

Related servers

  • AI for Database Verified domain
    Ask your databases questions in plain English, run read-only SQL and set up data alerts.
  • AI2SQL Verified domain
    Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
  • AICasePredict Verified domain
    Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts.
  • APC Security Reference Server
    Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...
  • AdoMcp
    Database MCP server for schema discovery, comments, and SQL queries.
  • Agent Swarm
    Full Agent Swarm API and MCP server with local SQLite storage for multi-agent orchestration.