Database guides & compatibility matrix
Practical connection specifics — bundled Oracle Instant Client, openGauss sha256 relay, DuckDB Parquet streaming, ClickHouse HTTP mutations — plus the full 18-server smoke-test ledger.
Connection notes for relational and analytical engines #
DataOmni ships seven native relational drivers (PostgreSQL, MySQL, SQLite, SQL Server, Oracle, DuckDB, and ClickHouse) plus dedicated connection presets and dialect adaptations for MariaDB, TiDB, OceanBase, CockroachDB, and openGauss.
| Engine | Connection & dialect specifics |
|---|---|
| Oracle (19c / 21c / 23ai) | Oracle Instant Client (Basic Light) is bundled inside every installer (Linux .deb/.rpm pulls libaio). Put the Easy Connect Service Name (e.g. FREEPDB1) in Database; encrypt via SSH tunnel; terminate PL/SQL blocks with a standalone / line; empty grid strings follow Oracle semantics and store NULL. |
| PostgreSQL, CockroachDB & openGauss | Full PG 16/17 support including schema diff, ER codegen, and pg_dump. CockroachDB defaults to port 26257 + Prefer TLS. openGauss accounts using default sha256 password storage authenticate seamlessly via DataOmni's built-in local PBKDF2-HMAC-SHA1 relay while keeping TLS intact. |
| MySQL, MariaDB, TiDB & OceanBase | New MySQL connections default to Require TLS — switch to Disable or Prefer TLS for local unencrypted Docker servers or MySQL 5.7 (no ECDHE ciphers). For OceanBase (MySQL mode), select MySQL on port 2881 with username formatted as user@tenant (e.g. root@test). |
| SQL Server (2019 / 2022) | Pure-Rust TDS over rustls (defaults to Prefer TLS for self-signed certs). Supports SSMS GO batch separators, estimated and actual SHOWPLAN_XML trees, and live @@TRANCOUNT state tracking. |
| SQLite & DuckDB 2.0 | Open local files (.db, .sqlite, .duckdb, .ddb) or :memory: directly, including Windows paths > 260 characters. DuckDB bundles parquet and json extensions so SELECT * FROM 'events.parquet' streams without loading the whole file; disconnect in DataOmni before opening the same .duckdb file in another process. |
| ClickHouse | Connects over HTTP (8123 plain / 8443 TLS, not native port 9000). Supports EXPLAIN indexes = 1 granule inspection and guarded single-row MergeTree edits verified via _part and _part_offset before and after mutation. |
Dedicated workspaces beyond SQL tables #
Instead of pretending documents, keys, graphs, or inverted indices are flat SQL tables, DataOmni switches into a tailored workspace when you connect to MongoDB, Redis, Neo4j, or Elasticsearch / OpenSearch:
- MongoDB (7.0 / 8.0 / Atlas SRV): browse collections, filter and aggregate with mongosh object syntax, edit documents in Extended JSON while preserving ObjectId / Decimal128 / Date types, inspect sampled field schemas, and run mongodump backups.
- Redis (7.x / Valkey / Sentinel / Cluster): cursor-based SCAN keyspace browser (never fires KEYS *), dedicated editors for string, hash, list, set, zset, and stream types, live Pub/Sub subscription tabs, and command console.
- Neo4j (5.x / 2025+ Bolt 4.4–5.8): interactive force-directed node/relationship canvas, property table view, Cypher parameter binding, and visual PROFILE / EXPLAIN operator trees.
- Elasticsearch 8.x & OpenSearch 2.x: multi-request REST console (GET /path + JSON body), index health/mappings/aliases explorer, visual query builder, and bulk/delete confirmation guardrails.
Live-database smoke test compatibility matrix #
Every entry below is backed by automated integration tests against real database instances in src-tauri/tests/*_smoke.rs. Counts report passed / skipped / fixture-unsupported cases:
| Server | Tested | Connection type | Status | Smoke (P/S/F) | Verified behavior & known gaps |
|---|---|---|---|---|---|
| PostgreSQL | 16 | PostgreSQL | Supported | 39/0/0 | Full SQL workbench, actual execution plans (EXPLAIN ANALYZE), bind parameters, schema diff, pg_dump backup. |
| MySQL | 8.4 | MySQL | Supported | 42/0/0 | Multi-result CALL support, JSON editor, TLS verification, schema diff, mysqldump backup. |
| MySQL 5.7 | 5.7.44 | MySQL | Usable, with gaps | 27+3/0/0* | TLS must be set to Disable (no ECDHE ciphers in 5.7); column renames restate definitions via CHANGE COLUMN. |
| SQLite | Bundled | SQLite | Supported | 18/0/0 | Built in, Windows >260-char paths supported, VACUUM INTO live backup, schema diff and ORM codegen. |
| MariaDB | 11.4 | MySQL | Supported | 43/0/0 | Dedicated preset in connection form; JSON columns are LONGTEXT aliases and edit as text. |
| TiDB | 8.5 | MySQL | Supported | 40/0/2* | Parses EXPLAIN FORMAT='tidb_json'; warns when DROP is non-transactional; splits combined column + table renames. |
| SQL Server | 2022 | SQL Server | Supported | 33/0/0 | SSMS-compatible GO batching, multiple result sets, estimated & actual XML execution plans, schema diff & codegen. |
| Oracle | 23ai Free (23.26) | Oracle (bundled OCI) | Supported | 29/1/0 | Instant Client bundled; connect by Service Name or SID; server-side cancel; use SSH tunnel when encryption is needed. |
| DuckDB | 2.0.0 (built in) | DuckDB | Supported | 19/0/0 | Streams Parquet/JSON without loading whole files into RAM; Windows long paths supported; EXPORT DATABASE backup. |
| OceanBase | 4.4.2 CE (MySQL) | MySQL | Usable, with gaps | 39/0/3* | Parses OceanBase CHILD_n JSON plans; inspect SQL preview before altering columns that use expression defaults. |
| CockroachDB | 25.2 | PostgreSQL | Usable, with gaps | 39/0/0 | Reads triggers via SHOW CREATE TRIGGER; parses EXPLAIN (VERBOSE) & EXPLAIN ANALYZE; runs schema changes per statement. |
| openGauss | 5.0.3 (PG mode) | PostgreSQL | Usable, with gaps | 40/0/0 | Local protocol relay authenticates default sha256-password users seamlessly over configured TLS. |
| ClickHouse | 25.8 | ClickHouse (HTTP) | Usable, with gaps | 17/0/0 | HTTP/HTTPS interface; single-row MergeTree edits pin _part block + _part_offset because ClickHouse has no row locks. |
| MongoDB | 8.0 | MongoDB | Usable, with gaps | 34/0/0 | Dedicated workspace with mongosh filter/edit syntax, aggregations, db.runCommand console, SRV (Atlas), TLS & X.509. |
| Redis | 7.4 | Redis | Supported | 14/0/0 | Standalone, Sentinel, and Cluster; SCAN browsing, 6 data type editors, JSON & pickle decoding, redis-cli console. |
| Neo4j | 5.26 LTS / 2026.09 | Neo4j (Bolt 5) | Usable, with gaps | 10/0/0 | Cypher editor, interactive graph view, visual node & relationship editing, EXPLAIN and PROFILE plans. |
| Elasticsearch | 8.19 / 9.5 | HTTP / API Key | Usable, with gaps | 7/0/0 | Kibana Dev Tools console, hits/ES|QL/SQL/aggregation tables, mapping viewer, optimistic-concurrency document edits. |
| OpenSearch | 3.8 | Elasticsearch | Usable, with gaps | 6/1/0 | Shares the Elasticsearch workspace over basic auth + TLS (no API key auth; read-only accounts cannot list tree). |