NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Databases

mssql-readonly-mcp

io.github.oguzhanpisgin/mssql-readonly-mcp · v0.1.1

Read-only MCP server for on-premises SQL Server: one plain SELECT, startup login check, audit log.

Source code Set it up

Connect Runs on your machine

Terminal
claude mcp add mssql-readonly-mcp -e MSSQL_CONNECTION_STRING=<MSSQL_CONNECTION_STRING> -e MSSQL_MCP_AUDIT_LOG=<MSSQL_MCP_AUDIT_LOG> -- https://github.com/oguzhanpisgin/mssql-readonly-mcp/releases/download/v0.1.1/mssql-readonly-mcp-0.1.1-win-x64.mcpb
claude_desktop_config.json
{
  "mcpServers": {
    "mssql-readonly-mcp": {
      "command": "https://github.com/oguzhanpisgin/mssql-readonly-mcp/releases/download/v0.1.1/mssql-readonly-mcp-0.1.1-win-x64.mcpb",
      "args": [],
      "env": {
        "MSSQL_CONNECTION_STRING": "<MSSQL_CONNECTION_STRING>",
        "MSSQL_MCP_AUDIT_LOG": "<MSSQL_MCP_AUDIT_LOG>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "mssql-readonly-mcp": {
      "command": "https://github.com/oguzhanpisgin/mssql-readonly-mcp/releases/download/v0.1.1/mssql-readonly-mcp-0.1.1-win-x64.mcpb",
      "args": [],
      "env": {
        "MSSQL_CONNECTION_STRING": "<MSSQL_CONNECTION_STRING>",
        "MSSQL_MCP_AUDIT_LOG": "<MSSQL_MCP_AUDIT_LOG>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mssql-readonly-mcp": {
      "type": "stdio",
      "command": "https://github.com/oguzhanpisgin/mssql-readonly-mcp/releases/download/v0.1.1/mssql-readonly-mcp-0.1.1-win-x64.mcpb",
      "args": [],
      "env": {
        "MSSQL_CONNECTION_STRING": "<MSSQL_CONNECTION_STRING>",
        "MSSQL_MCP_AUDIT_LOG": "<MSSQL_MCP_AUDIT_LOG>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
MSSQL_CONNECTION_STRING
Required, secret		SQL Server connection string. Use a login that passes check-login (see the README, "Create and check the read-only login"). The server adds ApplicationIntent=ReadOnly and Application Name=mssql-readonly-mcp.
MSSQL_MCP_AUDIT_LOG
Required		Path of the audit file, created with its folder if missing. One server process writes a file at a time; on Windows a second process on the same path writes a sibling file (docs/audit-log.md).

Details

Packagehttps://github.com/oguzhanpisgin/mssql-readonly-mcp/releases/download/v0.1.1/[email protected] (MCPB, stdio)
Packagehttps://github.com/oguzhanpisgin/mssql-readonly-mcp/releases/download/v0.1.1/[email protected] (MCPB, stdio)
Packagehttps://github.com/oguzhanpisgin/mssql-readonly-mcp/releases/download/v0.1.1/[email protected] (MCPB, stdio)
First published13 Nov 2026
Last updated13 Nov 2026
Registry nameio.github.oguzhanpisgin/mssql-readonly-mcp

More databases servers See all

  • Faostat Mcp Server

    UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.

  • VibeScale

    Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

  • Imf Mcp Server

    Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

  • Apex DB

    Vehicle specifications, emissions, and powertrain data with source provenance.

  • TrialBase DB

    Clinical trials across multiple registries with identifiers and source links.

  • PatchLabs

    Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.