PostgreSQL

PostgreSQL is QueryDen’s first-class engine. The driver is the upstream tauri-plugin-sql with a local patch that adds support for several types upstream doesn’t emit cleanly: INTERVAL, OID, multidimensional arrays, and a few bytea edge cases.

Connection

The standard PG connection fields apply:

• Host — e.g. db.acme.dev
• Port — default 5432
• Database — the database name
• User / Password — stored in the encrypted vault
• SSL — required / preferred / disabled. Required on managed PG (Supabase, Cloud SQL, RDS) by default.
• SSH tunnel — optional. Real ssh2-backed tunneling; no ssh subprocess.

Cockroach + Supabase

Neither is a separate backend in QueryDen — both speak the PostgreSQL wire protocol and connect through the same driver as Postgres.

• CockroachDB — supported through the PostgreSQL wire protocol. Pick the PostgreSQL engine when adding the connection; CockroachDB-specific behaviours (e.g. its dialect quirks) are handled by the server, not by a separate client driver.
• Supabase — PostgreSQL plus a connection-string helper UI for Supabase’s hosted format. The helper generates the right host/port/SSL fields from a Supabase project URL; the driver underneath is the PostgreSQL one.

Coming soon

• Full type catalog table — every PG type with how QueryDen renders it in the grid.
• Logical replication quickstart.
• psql integration deep-dive (the version-matched embedded client).

If a specific type or feature is missing, open an issue with a minimal reproduction.