A MySQL GUI and visual query workbench.
Visual query builder, EXPLAIN and profiling, schema sync, ER diagrams, index management, FK drill-down, and an opt-in AI assistant that proposes instead of executing.
Supports MySQL · MariaDB · TiDB · compatible forks
The plan Mongrel would build for your query.
Click any node below to see cost, row estimates, and what Mongrel would suggest. Same view you get inside the workbench.
// Index Scan · orders_idx_user_created
Reads orders_idx_user_created. 18,402 rows via range scan on user_id + created_at. AI-suggested composite index applied.
-- orders · prod-orders-3 SELECT o.id, o.total, o.status, u.email AS customer_email FROM orders o JOIN users u ON u.id = o.user_id WHERE o.created_at > '2026-06-01' AND o.status = 'paid' ORDER BY o.created_at DESC LIMIT 20; -- 412ms · 18,402 rows scanned -- ✓ AI proposal: composite (user_id, created_at) ALTER TABLE orders ADD INDEX idx_user_created (user_id, created_at);
What Mongrel ships for MySQL.
Visual query builder
Build SELECTs and JOINs visually. Output is real SQL - both sides stay editable.
EXPLAIN & profiling
Run EXPLAIN or EXPLAIN ANALYZE. Inspect cost-per-step, row estimates vs actuals, and index hits.
Index management
Create and drop indexes from the UI. See type, columns, and cardinality - plus per-query warnings when an index is missing.
Schema sync & drift
Compare schemas, generate the sync DDL, detect drift between environments.
ER diagrams & relationships
Auto-generated ER diagrams from foreign keys. Edit tables, columns, and FKs on the canvas, then forward-engineer the changes.
FK drill-down & dedupe
Click any foreign-key cell to jump to the referenced row. Built-in dedupe helpers by column.
AI explain & rewrite
Paste a query and an EXPLAIN. The assistant rewrites it, proposes indexes, shows the predicted EXPLAIN.
User & grant tools
Browse users, roles, and grants. Server status panels, process lists, logs, activity monitoring.
Import, export, copy
CSV, JSON, SQL dumps. Copy structure and data between MySQL, MariaDB, and TiDB connections.