Database

io.github.rog0xPublished by GitHub account rog0xv1.0.1Updated Oct 24, 2026

SQL formatting, schema visualization, migration generation

VerifiedSTDIODesktop onlyDatabasesDeveloper Tools

Overview

AI-generated overview

Local MCP server that gives an assistant SQL text tools: formatting, plain-English explanation, schema analysis, query building and migration generation.

What you can do
  • Format and prettify SQL queries for MySQL, PostgreSQL and SQLite
  • Explain a query in plain English, listing tables, columns, conditions and optimization tips
  • Parse CREATE TABLE statements into tables, columns, constraints, keys and indexes, and draw an ER diagram in Mermaid
  • Build SQL from natural-language descriptions, including filters, aggregation, joins, ordering and pagination
  • Compare old and new schemas and generate up and down ALTER TABLE migrations
When to use it
Useful when you work with SQL as text and want help tidying queries, understanding unfamiliar SQL, documenting a schema, drafting queries from a description, or producing migration statements between two schema versions, without connecting to a live database.
Requirements
Runs as a local Node.js process installed from the npm package; the README describes installing dependencies, building, and pointing a desktop client at the built entry file. No database connection, account, API key or environment variable is declared.
Before you install
It only analyzes SQL text and does not connect to a database, so generated queries and migrations are suggestions that should be reviewed before being run against real data. Desktop client only; no web execution.

Installation

In SourceWeft

  1. Open Database in the dashboard and add it to a workspace.
  2. Enable the server for the chats that should use its tools.

Desktop only via STDIO. STDIO servers start a local process, so they need the SourceWeft desktop host.

Other MCP clients

Follow the launch instructions in the repository.

README

mcp-database-tools

MCP server providing SQL and database tools for AI agents. All analysis is performed on SQL text — no actual database connection required.

Tools

sql_format

Format and prettify SQL queries with proper indentation, uppercased keywords, and aligned columns. Supports MySQL, PostgreSQL, and SQLite syntax.

sql_explain

Take a SQL query and explain what it does in plain English, step by step. Identifies query type, tables, columns, conditions, and provides optimization tips.

schema_analyze

Parse CREATE TABLE statements to extract tables, columns, types, constraints, foreign keys, and indexes. Generates an ER diagram in Mermaid format.

query_build

Build SQL queries from natural language descriptions. Supports common patterns like filtering by date, aggregation, joins, ordering, and pagination.

migration_generate

Compare two schemas (old vs new CREATE TABLE statements) and generate ALTER TABLE migration statements. Produces both up (forward) and down (rollback) migrations.

Installation

bash
npm installnpm run build

Usage

With Claude Desktop

Add to your Claude Desktop config (claude_desktop_config.json):

json
{  "mcpServers": {    "database-tools": {      "command": "node",      "args": ["path/to/mcp-database-tools/dist/index.js"]    }  }}

Standalone

bash
npm start

Development

bash
npm run build    # Compile TypeScriptnpm start        # Run the server

License

MIT

Source: README.md at commit 1d00864

Tools

0
SourceWeft has not started this package in its sandbox yet, so its tools are not known.

Version history

1
  1. v1.0.1LatestSep 16, 2026

Score

50% of the applicable checks met

How complete this listing is, computed from the registry entry, the endpoint and public sources. Not a rating of the server and not a statement that it is safe or working today: reachability is a dated check, and no installs or reviews go into the score.

  • Reached in the last 30 days25 pts

    Keep the endpoint answering the MCP handshake; SourceWeft probes it every 30 days.

  • Auth declared10 pts

    Declare the credential headers in the registry entry, or keep the endpoint answering the probe so its auth can be classified.

  • Tools listed15 pts

    Answer tools/list without a credential, or ship a package that starts in a sandbox without one.

  • DescriptionRequired15 pts
  • Logo10 pts
  • Documentation15 pts
  • License10 pts