Features

Everything you need to manage PostgreSQL, in one place.

✎ SQL Editor

A powerful multi-tab SQL editor designed for productivity.

✓ Syntax highlighting with CodeMirror
✓ Column autocomplete with alias resolution
✓ Multi-statement execution
✓ EXPLAIN / EXPLAIN ANALYZE
✓ Query history with search
✓ AI-powered SQL review (Pro)
✓ Export results as CSV/JSON
✓ Saved queries library

☰ Visual Query Builder

Build complex SQL queries without writing a single line of code.

✓ Drag-and-drop table selection
✓ Visual JOIN configuration
✓ WHERE clause builder
✓ GROUP BY, HAVING, DISTINCT
✓ Aggregation functions
✓ Subqueries (CTE & inline)
✓ Parameterized output (SQL injection safe)
✓ Undo/Redo support

⚙ ERD Viewer

Visualize your database schema with interactive diagrams.

✓ Auto-layout with force-directed algorithm
✓ Foreign key relationship arrows
✓ Column types and constraints
✓ Multi-schema support
✓ Export as SQL DDL

📊 Analytics & Dashboards

Built-in business intelligence, powered by your PostgreSQL data.

✓ Pivot tables with client-side aggregation
✓ Charts (bar, line, pie, scatter)
✓ Multi-widget dashboards
✓ Saved datasets with SQL sources
✓ Grid layout with drag-resize

📈 Monitoring

Keep your databases healthy with real-time monitoring.

✓ Active connections and queries
✓ Lock detection and analysis
✓ Slow query identification
✓ Table and index usage stats
✓ Historical metric snapshots
✓ Server configuration viewer
✓ Kill/cancel running queries

💾 Backup & Restore

Automated backup management with scheduling and retention.

✓ Scheduled backups (cron)
✓ Manual one-click backup
✓ Retention policies
✓ SQL and custom format
✓ Download and restore
✓ Backup history with status

🔌 Cloud & Connectivity

Connect to any PostgreSQL database, anywhere.

✓ Standard PostgreSQL connections
✓ SSL/TLS with custom certificates
✓ SSH tunnel support
✓ Supabase preset
✓ Neon preset
✓ Multiple saved connections