PostgreSQL · supported engine

A PostgreSQL GUI and database workbench.

Native SQL with browsing and editing, lint and explain, role and grant inspection, extension and pgvector value support, backups, import/export, and migrations.

Included with Mongrel Try free for 7 days

Supports PostgreSQL 14+ · pgvector · compatible forks

The planner's best friend

The plan Mongrel would build for your query.

Click any node below to see cost, row estimates, and where the time goes. 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)
-- fix: B-tree on orders(created_at), created below

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, their attributes, and per-object privileges from the admin surface. Run GRANT and REVOKE through the write-gated SQL editor.

Extension inventory

List installed extensions with versions, owning schemas, and descriptions - straight from pg_extension.

pgvector values

Dense vector, halfvec, and sparsevec columns decode into readable values in the results grid - no raw byte blobs.

Backups & restore

Logical archive dumps and restores with table-level object selection. Scheduled runs with optional AES-256 encrypted archives.

Import & export

CSV, JSON, JSON Lines, and SQL INSERT statements. Copy data between PostgreSQL servers - schema-aware.

Migrations & drift

Apply versioned SQL migration files with dry-run and rollback companions, and snapshot schemas to detect drift early.

AI query assistant

Chat about a query or its plan, or generate dialect-aware PostgreSQL SQL from natural language with live schema context.

Connect PostgreSQL in 30 seconds.

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

Download Mongrel