PostgreSQL · supported engine

The PostgreSQL workbench, end to end.

Native SQL with browsing and editing, lint and explain, roles and grants administration, extensions and pgvector workflows, backups, import/export, and migrations.

Included with Mongrel Try free for 7 days

Supports PostgreSQL 12+ · pgvector · 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.

// Seq Scan · orders

Full sequential scan of 80,000 rows with filter created_at > '2026-06-01'. 61,598 rows discarded — the hot spot.

-- 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;

-- 418ms · 80,000 rows scanned (Seq Scan)
-- ✓ Proposal: B-tree on orders(created_at)

CREATE INDEX CONCURRENTLY orders_created_idx
  ON orders (created_at);

PostgreSQL surface

What Mongrel ships for PostgreSQL.

SQL editor & browsing

Typed SQL with schema-aware completion, table and view browsing, row editing, and multi-statement scripts.

EXPLAIN & lint

Run EXPLAIN or EXPLAIN ANALYZE. Inspect plan trees, cost vs actual rows, and lint queries before they run.

Roles & grants

Browse roles, memberships, and per-object privileges. Issue GRANT and REVOKE from the UI with a full audit trail.

Extensions manager

Install, upgrade, and inspect extensions. See which schemas own them and which objects they provide.

pgvector workflows

Create and tune vector columns, ivfflat and HNSW indexes, and run similarity searches with distance previews.

Backups & restore

Logical dumps and restores per database, schema, or table. Scheduled runs with encrypted archives.

Import & export

CSV, JSON, and SQL dumps. Copy data between PostgreSQL and any other engine — schema-aware.

Schema sync & migrations

Compare schemas across environments, generate reversible migrations, and detect drift early.

AI explain & rewrite

Paste a query and its plan. The assistant rewrites it, proposes indexes, and shows the predicted EXPLAIN.

Connect PostgreSQL in 30 seconds.

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

Download Mongrel