Quickstart & connection setup
Go from download to a verified database connection in two minutes — with OS keychain storage, SSH jump-host verification, and preview-before-commit SQL guardrails.
Install and launch on macOS, Windows, or Linux #
Every installer ships as a single native Tauri 2 desktop application with Oracle Instant Client (Basic Light), DuckDB 2.0, and SQLite compiled or bundled inside. No Java runtime, Node.js runtime, or cloud account is required.
| Platform | Package | First-launch & credential notes |
|---|---|---|
| macOS 12+ (Apple Silicon) | DataOmni_<ver>_aarch64.dmg | Drag DataOmni.app to /Applications. Because builds currently use ad-hoc signing with Hardened Runtime, click "Open Anyway" once in System Settings -> Privacy & Security, or clear the quarantine attribute below. |
| Windows 10 / 11 (x64) | .exe (per-user NSIS) or .msi | Click "More info" -> "Run anyway" once if Windows SmartScreen prompts. Passwords are stored in Windows Credential Manager; SQLite and DuckDB file paths exceeding 260 characters work out of the box. |
| Linux x86_64 (glibc 2.34+) | .deb or .rpm | Ubuntu 22.04+ and Fedora 42+. Saving passwords requires an unlocked Secret Service (such as gnome-keyring or KWallet); without one, uncheck "Save password" for session-only connections. |
xattr -dr com.apple.quarantine /Applications/DataOmni.app
Where credentials and local data live #
DataOmni never writes database passwords, SSH passphrases, or AI API keys to disk in plaintext. Connection profiles store only non-secret metadata (host, port, database name, TLS mode, environment) plus an opaque reference to your operating system credential store.
| Artifact | macOS | Linux | Windows |
|---|---|---|---|
| connections.json (no secrets) | ~/Library/Application Support/com.dataomni.app/ | ~/.config/com.dataomni.app/ | %APPDATA%\com.dataomni.app\ |
| Passwords & SSH passphrases | macOS Keychain | Secret Service (gnome-keyring) | Windows Credential Manager |
| Diagnostic & CLI audit logs | ~/Library/Logs/com.dataomni.app/ | ~/.local/share/com.dataomni.app/logs/ | %LOCALAPPDATA%\com.dataomni.app\logs\ |
macOS Keychain prompt after app upgrades
Until Apple Developer ID signing is active, macOS treats a newly upgraded build as a distinct binary identity and prompts once per saved credential. Enter your login password and click "Always Allow" so both the GUI and CLI/MCP share access.
TLS verification tiers and SSH jump hosts #
All network TLS connections run through rustls so verification rules behave identically across macOS, Windows, and Linux. When connecting through a bastion host, enable "Connect via SSH tunnel" to forward traffic directly in-process without spawning external ssh processes.
| Mode | Encryption | Certificate check | When to pick |
|---|---|---|---|
| Disable | Plaintext | None | Local Docker containers or legacy MySQL 5.7 instances without ECDHE ciphers. |
| Prefer TLS | Opportunistic | None | Encrypts if the server offers TLS, falls back to plaintext otherwise (default on SQL Server / TiDB / CockroachDB). |
| Require TLS | Mandatory | None | Rejects plaintext fallback while accepting self-signed server certificates (default on MySQL). |
| Verify CA | Mandatory | Issuer CA | Verifies the certificate chain against system roots or your custom CA PEM file. |
| Verify Full | Mandatory | Issuer CA + Hostname | Production-grade verification of both the CA chain and server DNS/IP SAN. |
- Mutual TLS (mTLS): supply both Client Certificate Path and Client Private Key Path together (database X.509 pair, distinct from your SSH key).
- Strict SSH host-key verification: jump hosts are checked against ~/.ssh/known_hosts (%USERPROFILE%\.ssh\known_hosts on Windows). Unknown or changed host keys are refused and print the SHA256 fingerprint — ssh into a new bastion once first to trust its key.
- Layered diagnostics: click "Diagnose" in the connection form to isolate DNS resolution failures, refused TCP ports, TUN-proxy immediate drops, TLS alerts, or authentication errors.
Environment badges, queued SQL preview, and shortcuts #
Mark every profile as Development, Test, Staging, or Production. Staging and Production display persistent amber and red badges across the sidebar, SQL tabs, and table grids, and enforce stricter confirmation dialogs before DROP, TRUNCATE, FLUSHDB, or UPDATE/DELETE without WHERE.
-
Edit cells in the grid without immediate network writes
Modify cells, insert rows, or mark deletions in Table Data or editable query results. Changes accumulate in a local pending queue — clicking out of a cell never silently fires an UPDATE.
-
Inspect exact parameterized SQL
Open the pending changes preview to review the generated INSERT, UPDATE, and DELETE statements. Original column values are bound into WHERE so concurrent edits by teammates are detected.
-
Commit in one verified transaction
On Commit, DataOmni runs the batch inside a single transaction and checks that every statement affects exactly 1 row. Any mismatch triggers an automatic ROLLBACK and preserves your queued edits.
| Action | macOS | Windows / Linux |
|---|---|---|
| Command palette (connections, tables, actions) | Cmd + K | Ctrl + K |
| Execute current statement or selection | Cmd + Enter | Ctrl + Enter |
| New query tab / Close current tab | Cmd + T / Cmd + W | Ctrl + T / Ctrl + W |
| Close application window | Cmd + Shift + W | Ctrl + Shift + W |
| Toggle object browser sidebar | Cmd + B | Ctrl + B |