• SQL editor — Syntax highlighting, formatting, snippets, multi-statement execution
• MongoDB editor — Autocomplete (collections, methods, operators), real-time JSON linter, aggregation pipeline validation with stage classification and examples
• QoreQuery — Type-safe multi-dialect query builder (JOINs, subqueries, aggregates, CAST, COALESCE, LIKE/ILIKE) targeting PostgreSQL, MySQL, SQLite, DuckDB and SQL Server
• Query library — Folders, tags, JSON import/export, reusable queries
• ER diagram — Interactive schema graph with isolate/focus workflows [Pro]
• Visual DDL editor — Full CREATE and ALTER TABLE from the UI: columns, foreign keys, indexes, check constraints with live driver-specific SQL preview
• Explain Plan visualization — Interactive execution plan tree with cost highlighting (PostgreSQL, MySQL, SQL Server)
• Visual data diff — Side-by-side comparison of table/query results [Pro]
• Global full-text search — Search values across all tables and columns
• Foreign key peek + virtual relations — Navigation even without native FK constraints
• Routines, procedures, triggers & events — List, create and edit stored objects with SQL templates

• High-performance data grid — Virtualization, server-side filtering/sorting, pagination, infinite scroll, column pinning
• Advanced column filters — contains, regex, greater than, between and more across every driver
• Inline editing — Edit rows directly in SQL and NoSQL datasets
• Bulk edit — Multi-row column updates from the grid with live SQL preview (≤ 5 rows in Core, more in Pro)
• Time Travel — Browse the history of any row with a visual timeline, diff between any two points, preview Rollback SQL before reverting [Pro]
• Blob/binary viewer — Hex / base64 / image preview (PNG, JPEG, GIF, SVG, BMP, ICO) with copy-as-data-URI
• CSV import — Automatic separator/encoding detection, column mapping, preview before import
• Transaction management — Toggle autocommit, explicit Commit/Rollback, active transaction indicator
• Export pipeline — CSV, JSON, SQL, HTML, self-contained HTML (+ XLSX/Parquet in Pro)
• Cross-database federation — Query and join across active connections via DuckDB
• Sandbox mode — Isolated local changes with migration generation
• Backup & restore — Visual wrappers around pg_dump, mysqldump, mongodump and sqlite3 .dump, with streaming logs, cancel mid-run and tool-path overrides
• Query result cache — Recent table navigation served instantly from a local cache, auto-invalidated when you change data through QoreDB
• Plugin system — Install declarative plugins contributing SQL snippet packs, connection templates and color themes — no code execution

• Data Contracts — Declarative YAML assertions (12 rule types: NOT NULL %, regex, range, unique, FK integrity, custom SQL) executed as generated SQL, with a health dashboard, notebook cell and post-mutation alert hook [Pro]
• Instant Data API — Expose saved queries as read-only REST endpoints on 127.0.0.1, with Bearer auth, rate limiting, OpenAPI 3.1 generation and one-shot token regeneration [Pro]

• Executable documents mixing SQL/Mongo and Markdown cells, connected to a live database
• Parameterized variables ($customer_id, {{date_from}}) with typed inputs
• Run All / Run From Here with stop-on-error
• Inter-cell references and Chart cells (bar, line, pie, scatter) [Pro]
• Import from .sql / .md, export to Markdown or standalone HTML
• .qnb file format, Git-diffable

• MongoDB — Bulk write/find, aggregation pipeline validation, regex and text search, native index management UI
• Redis — Create, edit and delete keys and values across all Redis types from the UI, with Lua script evaluation

• Secure vault — Native OS keychain storage (Argon2) + optional app lock
• SSH tunneling — Native OpenSSH client with proxy jump support
• SQL Server Windows authentication — NTLM (username/password) and SSPI/Kerberos (integrated, no credentials)
• Environment safety — Dev/Staging/Prod guards, dangerous query detection, read-only mode
• Query rate limiting — Per-connection guardrail against accidental runaway query loops, plus a filesystem capability allow-list
• Universal Query Interceptor — Central hooks for safety, audit and profiling
• Audit logging — Sensitive content redaction in logs, stable SHA-256 query fingerprint per entry, JSONL/CSV export from the full retained trail
• Connection resilience — Automatic reconnection, health monitoring, smart keep-alive
• Background job manager — Async execution for long-running tasks with error recovery

• Workspaces — Group connections, queries, notebooks and history per project
• Multi-tab workspace — Drag-and-drop reorder, pinned tabs, persistent context across connection switches
• Tab groups — Tabs grouped by connection, collapsible, per-tab context menu
• Session restore — Tabs and their state persist on app restart
• Global search — Cmd/Ctrl + K across connections, history, commands, library
• Breadcrumb navigation — Connection > Database > Schema > Table clickable path
• Dark / light theme
• Customizable keyboard shortcuts — Every binding editable from Settings, click-to-rebind, conflict detection, cross-OS chords, reset per shortcut or globally
• 9 languages — English, French, Spanish, German, Portuguese (BR), Russian, Japanese, Korean, Chinese (Simplified)

• Contextual query generation and error correction
• Schema-aware suggestions
• Bring your own key (OpenAI, Anthropic, …)

• ~25% faster on real workloads (Apple Silicon) thanks to per-column decoders, MessagePack streaming between Rust and the frontend, batch streaming, expanded LRU caches, and the mimalloc allocator
• Lazy loading — heavy frontend modules load on demand for faster startup

sudo apt-get update
sudo apt-get install -y \
  pkg-config \
  libglib2.0-dev \
  libgtk-3-dev \
  libwebkit2gtk-4.1-dev \
  libayatana-appindicator3-dev \
  librsvg2-dev