MCP SQL Server

MCPReference

by GK-Leyton

Indexed by Glama. No runnable package is published via Glama's API — open the repository for install instructions.

mcpremote-capable

MCP configuration

stdio

Environment

  • MCP_LOG_FILE

    Log file path (default: mcp_sqlserver.log)

  • MCP_MAX_ROWS

    Maximum number of rows returned (default: 100)

  • MCP_LOG_LEVEL

    Log level (default: INFO)

  • SQLSERVER_HOSTrequired

    SQL Server host (e.g., localhost)

  • SQLSERVER_PORT

    SQL Server port (default 1433)

  • SQLSERVER_USERrequired

    SQL Server login user

  • SQLSERVER_DRIVER

    ODBC driver name (default: ODBC Driver 17 for SQL Server)

  • SQLSERVER_ENCRYPT

    Encrypt connection (default: yes)

  • SQLSERVER_DATABASErequired

    Database name

  • SQLSERVER_PASSWORDrequiredsecret

    SQL Server login password

  • MCP_QUERY_TIMEOUT_SECONDS

    Query timeout in seconds (default: 15)

  • SQLSERVER_TRUST_SERVER_CERT

    Trust server certificate (default: no)

Install in one click with Zurek

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