ide99

The fast, local-first PostgreSQL IDE.
28 MB native desktop app. EXPLAIN plan diff, JSONB tree editor, blocking chains, migrations, pgvector, MCP server for AI agents.

Download · Docs · Discussions · Why ide99

ide99.io (English) · ide99.ru (Русский)

Why ide99

PostgreSQL IDEs are either heavy (DBeaver, DataGrip), dated (pgAdmin), or closed and paid. ide99 is a native ~28 MB desktop app built around the things Postgres developers do every day: explain slow queries, edit JSONB, untangle locks, ship migrations, work with pgvector — and let AI agents work with a real database safely.

Install

Prebuilt binaries for macOS, Linux and Windows on the latest release.

Verify any download with the SHA256 checksum on the release page.

Trust & signing status

Builds are currently unsigned; EV code-signing is on the roadmap. Until then:

• macOS — install the .pkg; subsequent launches are clean. From the .dmg, right-click the app on first launch and pick Open.
• Windows — SmartScreen may flag the installer. Click More info → Run anyway, or use the portable .zip.
• Linux — AppImage / .deb / .rpm are unsigned but reproducible; verify SHA256.

ide99 is local-first: connections, credentials and query history live in <data_dir>/ide99/ on your machine. No cloud proxy, no telemetry by default. See SECURITY.md for the full threat model.

Package managers

Homebrew, winget, scoop, AUR and Flathub channels are planned.

Build from source

git clone https://github.com/exzvor/ide99.git
cd ide99
npm install
npm run tauri dev

Requires Node.js 20+ and Rust stable (rustup). Tauri prerequisites for your OS: tauri.app/start/prerequisites.

Production bundle:

npm run tauri build

Output lands in src-tauri/target/release/bundle/ — .dmg / .pkg on macOS, .deb / .AppImage / .rpm on Linux, .exe on Windows.

Useful scripts:

npm run typecheck            # tsc --noEmit
npm run lint                 # biome check .
npm run test                 # vitest unit tests
cd src-tauri && cargo test
cd src-tauri && cargo clippy -- -D warnings

Connect an AI agent (MCP)

ide99 exposes a Model Context Protocol server so Claude Code, Cursor, Windsurf and Cline can read the active connection, the current query and the last result — and propose SQL or EXPLAIN analyses in context. The agent never sees your credentials.

Enable: Settings → AI / MCP → Enable MCP server. The Connect your agent button generates the JSON snippet for ~/.claude/mcp_servers.json or ~/.cursor/mcp.json.

On first connect each client passes an in-IDE authorize flow with explicit scope (Allow, Allow read-only, Allow with write access, Deny). Write calls (run_query_write, apply_migration) additionally require a per-call confirm with SQL preview. Every call is appended to <data_dir>/mcp-audit.log.

Full guide: ide99.io/docs.

All features

• PostgreSQL-aware autocomplete (CTEs, window functions, JSONB operators, pg_catalog)
• Monaco-based SQL editor with multi-cursor, snippets, format
• Parameter binding and saved query history
• Virtualised result grid — 50M+ rows at 60 fps
• Multi-tab persistence across sessions

• EXPLAIN visualiser with tree view and plan diff (embedded pev2)
• Health Screen — bloat, slow queries, missing & unused indexes, one-click fixes
• Live Ops dashboard — sessions, blocking chains (DAG)
• pg_stat_statements integration

• ERD + Visual Schema Editor (bidirectional GUI ↔ SQL)
• Object editors: tables, views, materialised views, functions, procedures
• Native migrations with Squawk lint
• Backup / Restore workflows

• pgvector — vector search, index tuning, recall analysis
• PostGIS — spatial query helpers and map preview
• TimescaleDB, pg_partman, pg_stat_statements, pg_repack

• MCP server with scoped permissions and audit log
• JSONB tree editor with path autocomplete
• Instant DB (free beta) — on-demand throwaway PostgreSQL instances for prototyping, migration dry-runs and extension probes

Built on

Tauri 2.0 · Rust · React 18 · TypeScript · Monaco · pev2 · tokio-postgres · Radix UI · Tailwind v4 · Zustand

Contributing & community

• Discussions — feature requests, EXPLAIN puzzles, MCP setups
• Issues — bugs with concrete reproductions
• CONTRIBUTING.md — dev setup, coding conventions, PR flow
• SECURITY.md — responsible disclosure
• CODE_OF_CONDUCT.md
• CHANGELOG.md

Localised in English and Russian out of the box.

License

Apache License 2.0 — free to use, modify and distribute, commercially and otherwise.