A fast, native PostgreSQL IDE built with Go and Fyne.
- SQL Editor with context-aware autocomplete (tables, columns, aliases, dot notation)
- Schema Browser with lazy-loaded tree: schemas, tables, columns, indexes, constraints, triggers, functions
- Query Results with alternating row stripes, bold headers, and streaming for large result sets (50k row cap)
- EXPLAIN ANALYZE visualization via embedded pev2 — opens in browser with one click or Ctrl+E
- Export results to CSV, TSV, or XLSX
- Transaction Management — Begin, Commit, Rollback with visual indicators
- Query History — persistent, searchable, click to re-use
- File Editor — browse directories, edit files, virtualized viewer for large files
- Function Viewer — click any function to see its full
CREATE OR REPLACEdefinition, with "Open in Terminal" to edit - Import Connections from JSON (single object or array)
- Multiple Tabs — terminals and file editors side by side
- Dark/Light Theme — M3-inspired color system with JetBrains Mono
| Shortcut | Action |
|---|---|
| Ctrl+Enter | Run query |
| Ctrl+E | EXPLAIN ANALYZE |
| Ctrl+T | New terminal |
| Ctrl+W | Close tab |
| Ctrl+S | Save file |
sudo apt install -y gcc libgl1-mesa-dev xorg-dev libxcursor-dev libxrandr-dev libxinerama-dev libxi-dev libxxf86vm-devsudo dnf install -y gcc mesa-libGL-devel libXcursor-devel libXrandr-devel libXinerama-devel libXi-devel libXxf86vm-develXcode command line tools only — no extra packages needed:
xcode-select --installgo build -o helios .
./heliosRequires Go 1.24+.
To quickly populate Helios with connections, use the import button (download icon in the sidebar) and select a JSON file. An example is included:
# Import the example connections after launching Helios:
# Sidebar → click the ↓ import icon → select examples/connections.jsonThe JSON format supports a single object or an array:
[
{"name": "my-db", "host": "localhost", "port": 5432, "user": "postgres", "password": "secret", "dbname": "mydb", "sslmode": "disable"}
]See examples/connections.json for a full example.
MIT
