@rog0x/mcp-database-tools

What is @rog0x/mcp-database-tools?

An MCP server that provides SQL and database tools for AI agents. All analysis is performed on SQL text only — no actual database connection is required. It offers tools for formatting, explaining, analyzing, building, and migrating SQL.

How to use @rog0x/mcp-database-tools?

Install via npm install && npm run build. Then configure in Claude Desktop by adding the server to your claude_desktop_config.json with the command node and args pointing to the built dist/index.js. You can also run it standalone with npm start.

Key features of @rog0x/mcp-database-tools

• Format and prettify SQL queries with proper indentation and uppercased keywords
• Explain SQL queries in plain English, step by step, with optimization tips
• Analyze CREATE TABLE statements to extract schema and generate Mermaid ER diagrams
• Build SQL queries from natural language descriptions
• Compare two schemas and generate ALTER TABLE migration statements (up and down)

Use cases of @rog0x/mcp-database-tools

• AI agents that need to format or explain complex SQL queries
• Generating SQL from natural language requests for rapid prototyping
• Analyzing and visualizing database schemas without connecting to a live database
• Creating migration scripts between different schema versions

FAQ from @rog0x/mcp-database-tools

Does this server connect to a real database?

No, all analysis is performed on SQL text only. No actual database connection is required.

What SQL dialects are supported?

The tools support MySQL, PostgreSQL, and SQLite syntax.

How do I use these tools with Claude Desktop?

Add the server to your claude_desktop_config.json following the example in the README. The AI can then invoke the tools.

What output does schema_analyze produce?

It generates an ER diagram in Mermaid format based on the provided CREATE TABLE statements.

Can I run the server without Claude Desktop?

Yes, you can run it standalone using npm start.