RawSqlMcp 0.1.0

.NET 10.0 This package targets .NET 10.0. The package is compatible with this framework or higher. 
{
  "inputs": [
    {
      "type": "promptString",
      "id": "RawSqlMcp__Databases__Default__Provider",
      "description": "Database provider. Values: sqlserver, sqlite, postgres, postgresql, mysql, mariadb."
    },
    {
      "type": "promptString",
      "id": "RawSqlMcp__Databases__Default__ConnectionString",
      "description": "Connection string for the named database.",
      "password": true
    },
    {
      "type": "promptString",
      "id": "RawSqlMcp__ConnectionStrings__Default",
      "description": "Obsolete. Use provider and connection string database settings instead.",
      "password": true
    }
  ],
  "servers": {
    "RawSqlMcp": {
      "type": "stdio",
      "command": "dnx",
      "args": ["RawSqlMcp@0.1.0", "--yes"],
      "env": {
        "RawSqlMcp__Databases__Default__Provider": "${input:RawSqlMcp__Databases__Default__Provider}",
        "RawSqlMcp__Databases__Default__ConnectionString": "${input:RawSqlMcp__Databases__Default__ConnectionString}",
        "RawSqlMcp__ConnectionStrings__Default": "${input:RawSqlMcp__ConnectionStrings__Default}"
      }
    }
  }
}
This package contains an MCP Server. The server can be used in VS Code by copying the generated JSON to your VS Code workspace's .vscode/mcp.json settings file. 
dotnet tool install --global RawSqlMcp --version 0.1.0
This package contains a .NET tool you can call from the shell/command line. 
dotnet new tool-manifest
                    


                            if you are setting up this repo
                        

                    

                
dotnet tool install --local RawSqlMcp --version 0.1.0
This package contains a .NET tool you can call from the shell/command line. 
#tool dotnet:?package=RawSqlMcp&version=0.1.0
                    


                    

                
nuke :add-package RawSqlMcp --version 0.1.0

Raw SQL MCP

CI NuGet Latest release

Raw SQL MCP is a STDIO MCP server for executing raw SQL against SQL Server, SQLite, PostgreSQL, MySQL, and MariaDB.

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.

Install and run demo

Installation

Run the server with dnx:

dnx RawSqlMcp

For a specific version:

dnx RawSqlMcp@0.0.2

Package: RawSqlMcp on NuGet

Configuration

Databases are configured with environment variables under RawSqlMcp__Databases__.

SQLite:

export RawSqlMcp__Databases__Local__Provider="sqlite"
export RawSqlMcp__Databases__Local__ConnectionString="Data Source=/absolute/path/app.db"

PostgreSQL:

export RawSqlMcp__Databases__Reporting__Provider="postgres"
export RawSqlMcp__Databases__Reporting__ConnectionString="Host=localhost;Port=5432;Database=reporting;Username=postgres;Password=postgres"

MySQL/MariaDB:

export RawSqlMcp__Databases__Shop__Provider="mysql"
export RawSqlMcp__Databases__Shop__ConnectionString="Server=localhost;Port=3306;Database=shop;User ID=mysql;Password=mysql"

SQL Server:

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

Optional command timeout, in seconds:

export RawSqlMcp__CommandTimeout=30

The legacy RawSqlMcp__ConnectionStrings__Default="..." format is obsolete. It still works for compatibility and is interpreted as SQL Server.

Usage

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

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

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

Short end-to-end demo

Product Compatible and additional computed target framework versions.
.NET net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last Updated
0.1.0 0 6/26/2026
0.0.7 0 6/26/2026
0.0.6 0 6/26/2026
0.0.5 0 6/26/2026
0.0.4 0 6/26/2026
0.0.3 0 6/26/2026
0.0.2 0 6/26/2026