Skip to main content
Glama
KifoPL

Raw SQL MCP

by KifoPL

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.

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.

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

Related MCP server: sql-explorer-mcp

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

[!INFO] 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

A
license - permissive license
-
quality - not tested
A
maintenance

Maintenance

Maintainers
Response time
0dRelease cycle
2Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • F
    license
    -
    quality
    D
    maintenance
    A versatile MCP server that connects to multiple relational databases (MySQL, PostgreSQL, Oracle, SQL Server, SQLite) and enables secure read-only SQL query execution and metadata access.
    Last updated
    4
  • A
    license
    -
    quality
    F
    maintenance
    Read-only MCP server for SQL databases (SQL Server, Postgres, SQLite) with multi-server support and three-layer safety using AST validation and linting.
    Last updated
    MIT
  • A
    license
    A
    quality
    C
    maintenance
    A lightweight MCP server for relational databases, enabling dynamic connections to PostgreSQL and MySQL, SQL execution, and transaction control.
    Last updated
    7
    73
    1
    MIT
  • F
    license
    A
    quality
    C
    maintenance
    Production-oriented MCP server for Microsoft SQL Server, enabling query execution, database discovery, schema introspection, and metadata inspection via MCP clients.
    Last updated
    6
    3

View all related MCP servers

Related MCP Connectors

  • MCP server for managing Prisma Postgres.

  • Read-only MCP server for ClassQuill, a tutoring-business-management platform.

  • MCP server for interacting with the Supabase platform

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/KifoPL/RawSqlMcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server