📊
Performance Monitoring NEW in 2.0
Slow Queries, Live Activity (with one-click Kill), Locks (blocking tree, wait time), Index Health (unused, redundant, scan hot-spots). MySQL, Redshift, and DynamoDB — without CloudWatch.
🔍
Where the query is fired from NEW in 2.0
Drill into any slow-query digest to see the top user@host firing it plus recent raw samples with full SQL_TEXT — answers "which service is hammering this query" in one click.
⚡
Step-aware Autocomplete NEW in 2.0
Different completions for SELECT, FROM, WHERE, and after-column positions. `WHERE order_` now suggests columns from `order_details`, not random tables. MySQL keywords, functions, operators, cross-DB.
🛡
Production Safety NEW in 2.0
Tiered confirmation modal: DROP/TRUNCATE require typing the connection name; DELETE/UPDATE/ALTER show a statement preview. Server-side query cancel via KILL QUERY. Local audit trail.
⚡
Fast Startup
Opens in under 2 seconds. Native app, not Electron. Only 18MB installed.
📝
Monaco SQL Editor
VS Code-quality editing with autocomplete, syntax highlighting, multi-cursor, and SQL formatting.
🔒
Encrypted Credentials
AES-256-GCM encryption. Keys stored in OS keychain. No plaintext passwords on disk.
📊
EXPLAIN Visualization
Color-coded query plans for MySQL and Redshift. Spot slow queries at a glance.
📄
Multi-Tab & Multi-Connection
Work across multiple databases simultaneously. Each tab can connect to a different server.
🔍
Command Palette
Cmd+K to access any action instantly. Run queries, format SQL, switch connections.
💾
Query History & Saved Queries
Auto-saved history with search and favorites. Named queries with parameter support.
🔧
Table Designer
Visual CREATE and ALTER TABLE. Index manager. No need to write DDL by hand.
🌐
SSH Tunnels
Connect to databases behind firewalls. Built-in SSH tunnel with key auth support.
🔗
Cross-Schema Queries
Run JOINs and queries across multiple schemas in a single connection. Autocomplete resolves tables across schemas automatically.
💾
Backup & Restore
One-click logical backups of tables, schemas, or full databases — saved locally to your laptop. Restore into any connection without leaving the app.
