What is ide99
ide99 is a desktop client for PostgreSQL. One installer for macOS, Windows, and Linux — nothing extra: SQL editor, grid, EXPLAIN, JSONB editor, Health screen, and a Live Ops panel. Everything runs locally, no cloud account.
What sets ide99 apart from DBeaver, DataGrip, pgAdmin
ide99 is built for PostgreSQL only. That means:
- Deep work with what only Postgres has: JSONB tree, EXPLAIN visualization, lock graph, pgvector, PostGIS, hypertables, pg_partman.
- No universal table view and generic Run button across 30 databases — instead, UX designed for Postgres-specific tasks.
- Lighter footprint: native binary on Rust + Tauri, ~30 MB, ~200 MB idle memory.
- Faster: virtualized grid handles 50 million rows without hitches; cold start ~2 seconds.
What's inside
| Feature |
What it does |
| SQL editor |
Monaco with autocomplete, formatting, multi-cursor |
| Grid |
Virtualized table; editing, filter, sort |
| JSONB editor |
View and edit jsonb as tree, text, or table |
| EXPLAIN visualizer |
Plan tree with heatmap, side-by-side diff, auto-insights |
| Health screen |
Bloat, unused indexes, slow queries — and an "apply" button |
| Live Ops |
Active sessions, lock graph, replication slots |
| AI via MCP |
Plug in Claude Code, Cursor, Windsurf — every action confirmed |
| Power Packs |
pgvector, PostGIS, pg_partman, pg_repack, TimescaleDB |
Who it's for
- Backend developers who write SQL daily.
- Analysts and data engineers who need a fast grid and EXPLAIN.
- DBAs who care about live state (locks, replication, slow queries).
- Teams where local-first matters: data never leaves the machine.
Next