MySQL · supported engine

The MySQL workbench, end to end.

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

Live · click to inspect

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. 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
-- ✓ Proposal: composite (user_id, created_at)

ALTER TABLE orders
  ADD INDEX idx_user_created (user_id, created_at);
MySQL surface

What Mongrel ships for MySQL.

Visual query builder

Build SELECTs, JOINs, and aggregations 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, drop, and rebuild indexes from the UI. See cardinality, usage, and the queries that would benefit.

Schema sync & drift

Compare schemas, generate reversible migrations, detect drift between environments.

ER diagrams & relationships

Auto-generated ER diagrams from foreign keys. Click a relationship to drill into rows, audit constraints.

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 data between MySQL and any other engine — schema-aware.

Connect MySQL in 30 seconds.

7-day trial. macOS, Windows, Linux. No credit card.