#Database support matrix
JustyBase presents one workspace shell, but a capability is only available when the selected dialect provider advertises it. The matrix below is the public product focus; Partial means the common path works but some database-specific operations are limited.
| Database | Runtime / authentication | Parser, completion, LSP | Metadata / search | DDL / explain | Import, export, maintenance | Boundary |
|---|---|---|---|---|---|---|
| Netezza | Bundled JavaScript driver; host/port/database/user/password; VS Code Secrets; raw TCP tunnel over HTTPS/WSS | First-class parser, CST semantics, NZPLSQL, LSP, quality, semantic tokens | Full lazy catalog/cache, source search, DDL, profiles; parsed dependencies, reverse lookup and bounded object/column impact analysis | DDL, EXPLAIN, plan analysis, query flow; deterministic metadata/EXPLAIN performance advisor; Object Designer native distribution/organization and guarded NZPLSQL routine surfaces | XLSB/XLSX/CSV/compressed CSV/JSON/XML/SQL/Markdown/Parquet; GROOM, stats, skew, sessions, security | Production/core; TCP tunnel uses named relay targets |
| Db2 | Preview companion runtime; platform-specific driver package; raw TCP tunnel over HTTPS/WSS | Dialect authoring, completion, metadata-aware LSP; depth varies by statement | Catalog browsing, columns, DDL, compare | DDL, explain graph, and Db2-specific structural tooling | Spreadsheet/text import-export; RUNSTATS, REORG, dedicated Index Designer and Partition Manager |
Preview; runtime setup required; tunnel uses named relay targets |
| MS SQL Server | Preview companion runtime and mssql driver; raw TCP tunnel over HTTPS/WSS |
Dialect parser profile, completion, formatting, diagnostics | Metadata, object/column browsing, DDL | Explain/parser support depends on provider surface | Provider-specific import/export and maintenance operations | Preview; partial by feature; tunnel uses named relay targets |
| Oracle | Preview companion runtime; raw TCP tunnel over HTTPS/WSS | Oracle parser profile, completion, formatting, diagnostics | Metadata, DDL, object search | Explain and tuning provider paths where available | Provider-specific import/export and maintenance operations | Preview; partial by feature; tunnel requires Host/Port/Service Name |
| PostgreSQL | Preview companion runtime; raw TCP tunnel over HTTPS/WSS | PostgreSQL parser profile, completion, formatting, diagnostics | Metadata, DDL, object search | Explain, partitions, indexes, and maintenance paths where implemented; Alter Table Designer and Index Designer | Provider-specific import/export and maintenance operations | Preview; partial by feature; tunnel uses named relay targets |
| MySQL | Preview companion runtime (8.0+ scope); raw TCP tunnel over HTTPS/WSS |
MySQL parser profile, completion, formatting, diagnostics | Metadata, DDL, object search, index/partition catalog views | Explain, Alter Table Designer, Index Designer, and method-specific Partition Manager | Provider-specific import/export and guarded table-structure operations | Preview; MariaDB and advanced partition restructuring outside scope; tunnel uses named relay targets |
| ClickHouse | Preview companion runtime over HTTP/HTTPS; user/password authentication; raw TCP tunnel over HTTPS/WSS | ClickHouse parser profile with PREWHERE, ARRAY JOIN, QUALIFY, LIMIT BY, WITH FILL, DDL options, completion, formatting, diagnostics | system.databases, system.tables, system.columns, object/source search |
SHOW CREATE TABLE, cache DDL, textual EXPLAIN, MergeTree sorting/partition metadata |
Shared CSV/clipboard import, streaming results, query cancellation, sessions/query kill, OPTIMIZE TABLE, partition inspection | Preview; self-hosted and ClickHouse Cloud; no relational indexes/procedures; HTTPS tunnels use TLS Server Name |
| Snowflake | Preview companion runtime using snowflake-sdk; password, OAuth, or key-pair configuration |
Snowflake SQL authoring, completion, formatting, diagnostics | Databases, schemas, tables, views, procedures, functions, sequences, stages, streams, tasks, file formats, warehouses | GET_DDL, EXPLAIN USING JSON, recent-query profile inspection, and clustering-key designer surface |
Stage-oriented import/export guidance, stream/task drafts, shared result workflows | Preview; warehouse credits and account privileges apply |
| Vertica | Preview companion runtime using vertica-nodejs; TLS and session options |
Vertica SQL authoring, completion, snippets, diagnostics | v_catalog/v_monitor metadata, object and source search |
DDL, explain graph, tuning, projections and skew inspection | Import previews, statistics/purge helpers, session monitoring, shared result workflows | Preview; runtime setup and privileges required |
| Access | Preview Access reader/session plus local embedded runtime | File SQL authoring and local completion; not a warehouse dialect | MDB/ACCDB tables, columns, DDL boundary | File/session operations; no warehouse session model | Access file import/edit/export plus local result workflows | Preview; file/runtime boundary |
| Files / DuckDB / SQLite | Preview local DuckDB or SQLite runtime; no server credential required | File SQL dialects, local completion and formatting | Lazy local catalogs and source profiles | Local DDL, explain, integrity/maintenance varies by runtime; reusable designer builders and capability rules are shared, while available panels are owned by desktop/companion adapters | CSV/TSV, XLSX/XLSB, Parquet, Avro, Access; result export | Preview desktop/local; file sources can be read-only; no TCP tunnel |
#Status interpretation
Parser support does not imply identical SQL acceptance. Metadata support does not imply every catalog object is visible to the connected user. Explain/tuning and maintenance are explicitly provider-specific. A disabled context-menu action is usually a capability boundary or privilege check.
#Runtime selection
Install the core extension for Netezza and the companion extension/runtime required by the selected database. Keep native runtime installation and version checks out of the workspace secrets. Optional extensions remain short Marketplace pages; this matrix is the canonical capability description.
For the shared raw TCP tunnel deployment, including the FastAPI relay, named target allowlist, reverse-proxy configuration, and live database checks, see the global database tunnel guide.
#How to report a parity gap
Include database kind, version, connection mode, a minimal SQL/object example, expected behavior, and whether metadata was refreshed. Do not attach credentials or production data. The parser guide and import/export guide explain common platform boundaries.
#Generated source inventory
The Pages build records every advertised DatabaseKind found in the shared contract. A listed companion is a repository and packaging inventory claim, not a promise of identical depth: Snowflake, Vertica, and the other optional runtimes remain Preview until their common dialect contract and live validation meet the promotion criteria in the quality roadmap.
| DatabaseKind | Runtime family |
|---|
Netezza analysis scope and evidence limitations are documented in Dependencies and impact analysis and Netezza Performance Advisor.