adamrpostjr/sqlmate-mcp

sqlmate-mcp

Zero-config SQL database MCP server with a browser GUI for Claude Code.

Connect Claude to your MySQL, MariaDB, SQLite, MSSQL, or PostgreSQL databases. sqlmate-mcp reads your existing .env or a .sqlmaterc config, exposes your databases as MCP tools, and opens a live browser GUI so you can browse, edit, and run SQL alongside your AI assistant.

---

Features

• Zero config — reads DB_* vars or DATABASE_URL straight from your project's .env
• Multi-connection — manage MySQL, MariaDB, SQLite, MSSQL, and PostgreSQL from a single server
• 8 MCP tools — list/add connections, list tables, describe a table, dump the full schema graph, run read queries, EXPLAIN a query, run writes
• Schema intelligence — get_schema returns every table with its columns, primary keys, foreign keys, and indexes in one call
• Query plans — explain_query returns the execution plan (plan-only by default, so it never runs your statement; opt into analyze for real timing on reads)
• Write safety — risky operations (DELETE/UPDATE without WHERE, DROP, TRUNCATE) require explicit confirmation
• Browser GUI — paginated data grid, inline cell editing, row delete, schema view, SQL editor with EXPLAIN + timing
• ERD visualizer — an interactive entity-relationship diagram per connection, with foreign-key edges and click-to-open tables
• Unified multi-project dashboard — open several projects in Claude Code at once and see them all in one GUI, grouped by project, each connection labeled with its host/database
• Live agent feed — watch every MCP tool call stream in real time in the browser
• No native builds — SQLite uses Node.js's built-in node:sqlite (no node-gyp)

---

Requirements

• Node.js ≥ 22.5

---

Setup

1. Install

npm install -g