RawSqlMcp

Raw SQL MCP

Raw SQL MCP is a STDIO MCP server for executing raw SQL against SQL Server.

[!IMPORTANT] Use it carefully. The server does not protect you from destructive queries, expensive queries, SQL injection, missing pagination, or unsafe data exposure. Always review and approve queries before running them.

Installation

Run the server with dnx:

dnx RawSqlMcp

For a specific version:

dnx RawSqlMcp@0.0.2

Package: RawSqlMcp on NuGet

Configuration

Connection strings are configured with environment variables under RawSqlMcp__ConnectionStrings__.

Configure the default SQL Server connection string:

export RawSqlMcp__ConnectionStrings__Default="Server=localhost,1433;Database=master;User Id=sa;Password=Your_password123;TrustServerCertificate=True"

Add more named databases by changing the final segment:

export RawSqlMcp__ConnectionStrings__Reporting="Server=localhost,1433;Database=Reporting;User Id=sa;Password=Your_password123;TrustServerCertificate=True"

Optional command timeout, in seconds:

export RawSqlMcp__CommandTimeout=30

Usage

Register the server in an MCP client as a STDIO server:

{
  "servers": {
    "raw-sql-mcp": {
      "command": "dnx",
      "args": ["RawSqlMcp"],
      "env": {
        "RawSqlMcp__ConnectionStrings__Default": "Server=localhost,1433;Database=master;User Id=sa;Password=Your_password123;TrustServerCertificate=True"
      }
    }
  }
}

The server exposes tools for listing configured database names, reading SQL Server schema metadata, and executing raw, parameterized, and scalar SQL queries.