ZurekZurekMarketplace
Download
Back to catalog

Microsoft SQL Server

MCP

by alyiox · v1.1.0

Read-only MCP for Microsoft SQL Server: metadata discovery, parameterized SELECT, plans.

mcplocal

MCP configuration

stdio

Command

dnx Alyio.McpMssql

Environment

  • MCPMSSQL_CONNECTION_STRINGsecret

    Default profile SQL Server connection string (often contains secrets). Optional if profiles are only in user appsettings.

  • MCPMSSQL_DESCRIPTION

    Optional human-readable description for the default profile.

  • MCPMSSQL_QUERY_MAX_ROWS

    Max rows per interactive query (default 500; ceiling 1000).

  • MCPMSSQL_QUERY_COMMAND_TIMEOUT_SECONDS

    Interactive query command timeout in seconds (default 30).

  • MCPMSSQL_QUERY_SNAPSHOT_MAX_ROWS

    Max rows for snapshot queries (default 10000; ceiling 50000).

  • MCPMSSQL_QUERY_SNAPSHOT_COMMAND_TIMEOUT_SECONDS

    Snapshot query timeout in seconds (default 120).

  • MCPMSSQL_ANALYZE_COMMAND_TIMEOUT_SECONDS

    Execution plan analysis timeout in seconds (default 300).

  • DOTNET_ENVIRONMENT

    Set to Development to load dotnet user-secrets (local dev).

Install in one click with Zurek

Browse here, install from the native macOS app — pick targets, fill env vars, and write configs safely.

Download for macOSAbout the Zurek app