mcp-database-tools
Generates ER diagrams in Mermaid format during schema analysis, enabling visual representation of database structures.
Provides SQL tools (formatting, explanation, schema analysis, query building, migration generation) that support MySQL syntax.
Provides SQL tools (formatting, explanation, schema analysis, query building, migration generation) that support PostgreSQL syntax.
Provides SQL tools (formatting, explanation, schema analysis, query building, migration generation) that support SQLite syntax.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mcp-database-tools Explain what this SQL query does: SELECT * FROM orders WHERE status = 'pending'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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.
Related MCP server: MCP Data Analyst
Installation
npm install
npm run buildUsage
With Claude Desktop
Add to your Claude Desktop config (claude_desktop_config.json):
{
"mcpServers": {
"database-tools": {
"command": "node",
"args": ["path/to/mcp-database-tools/dist/index.js"]
}
}
}Standalone
npm startDevelopment
npm run build # Compile TypeScript
npm start # Run the serverLicense
MIT
Available Tools
5 toolsmigration_generateA
Compare two schemas (old vs new CREATE TABLE statements) and generate ALTER TABLE migration statements with both up and down migrations.
Inputs: new_schema (required), old_schema (required), dialect.
query_buildC
Build SQL queries from natural language descriptions. Example: "get all users who signed up this month and have at least 3 orders" generates the corresponding SQL.
Inputs: description (required), dialect, schema_hint.
schema_analyzeA
Parse CREATE TABLE statements to extract tables, columns, types, constraints, foreign keys, and indexes. Generates an ER diagram in Mermaid format.
Inputs: sql (required).
sql_explainA
Take a SQL query and explain what it does in plain English, step by step. Identifies tables, columns, conditions, and provides optimization tips.
Inputs: sql (required).
sql_formatA
Format and prettify SQL queries with proper indentation, uppercased keywords, and aligned columns. Supports MySQL, PostgreSQL, and SQLite syntax.
Inputs: sql (required), dialect, uppercase, indent_size, +1 more.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 5 tools
Each tool addresses a distinct aspect of database work: formatting, natural language query building, explaining SQL, schema analysis, and migration generation. No two tools overlap in purpose, making selection unambiguous.
All tool names follow a consistent '<domain>_<action>' pattern (e.g., sql_format, schema_analyze), with noun-first ordering and snake_case throughout. This creates a predictable and readable convention.
With 5 tools, the set is concise and well-scoped for a database utility server. Each tool covers a core workflow (format, build, explain, analyze, migrate) without redundancy or bloat.
The tool set covers the full lifecycle of SQL development: creating/formatting queries, building from natural language, understanding, analyzing schema, and generating schema migrations. No critical gaps are apparent for the stated purpose.
Related MCP Connectors
Query Postgres, MySQL, SQL Server, Oracle, BigQuery, ClickHouse and Redshift from your AI client.
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
Deterministic safety, correctness & cost gate that vets Postgres SQL before your AI agent runs it.
Related MCP Servers
- AlicenseNot gradedqualityAmaintenanceEnables AI assistants to query databases using natural language, with automatic schema discovery and SQL compilation.453 npm3,236Apache 2.0
- AlicenseNot gradedqualityDmaintenanceEnables natural language querying of SQL databases using AI, supporting multiple database types and automatic schema discovery.1MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to interact with PostgreSQL or MySQL databases using natural language. Supports SQL queries, schema discovery, and pre-built aggregations without writing SQL.35 npmMIT
- FlicenseNot gradedqualityAmaintenanceEnables LLM agents to connect to multiple database types, retrieve normalized schemas, and execute optimized SQL queries through a unified API.-