PostgreSQL

Schemas, partitions, rich types, designers, and visual EXPLAIN.

Ready

PostgreSQL support covers schemas, partitions, JSONB, arrays, enums, domains, and ranges, with table, trigger, and sequence designers and EXPLAIN plans rendered as a graph.

Capabilities

Connections

Ready

Host, port, database, and credentials, with SSL modes, client certificates, search path, and SSH tunnels.

Schema browser

Ready

Schemas, tables, partitions, views, materialized views, functions, procedures, sequences, types, domains, and extensions.

SQL editor

Ready

Completion, hover, and diagnostics that understand schema-qualified names and CTEs.

Rich types

Ready

UUID, JSONB, arrays, enums, domains, ranges, inet, and tsvector display as readable values.

Visual EXPLAIN

Ready

Plans as a graph with costs, suggestions, and partition pruning.

Designers

Ready

Table, trigger, and sequence designers, plus forms for domains, enums, and procedures.

In the app

ZQLZ grid of a PostgreSQL customers table with citext, enum array, JSONB, and hstore columns — Domains, enum arrays, JSONB, hstore, and ranges in the grid, with types in the inspector.

ZQLZ object list of PostgreSQL tables with owner, partition parent, row estimates, and primary keys — Every table with its owner, partition parent, row estimate, and primary key.

ZQLZ SQL editor with a PostgreSQL CTE, the ->> JSON operator, and a rank() window function — CTEs, JSON operators, and window functions, highlighted and schema-aware.

ZQLZ visual EXPLAIN graph for a PostgreSQL query scanning a single partition of the orders table — The plan graph shows that only one quarterly partition was scanned.

ZQLZ table designer for a PostgreSQL table with domain, enum array, inet, cidr, and tstzrange columns — The table designer keeps PostgreSQL types, defaults, and generated columns intact.

ZQLZ grid of a PostgreSQL table named select with mixed-case and spaced columns and emoji values — Reserved-word table names, mixed-case and spaced columns, and emoji values.

Connecting

Host, port, database, user, and password, with SSL mode (disable through verify-full), client certificates, and an optional SSH tunnel.

← All databases

PostgreSQL

Schemas, partitions, rich types, designers, and visual EXPLAIN.

Download ZQLZ View roadmap

Ready

PostgreSQL support covers schemas, partitions, JSONB, arrays, enums, domains, and ranges, with table, trigger, and sequence designers and EXPLAIN plans rendered as a graph.

Capabilities

Connections

Ready

Host, port, database, and credentials, with SSL modes, client certificates, search path, and SSH tunnels.

Schema browser

Ready

Schemas, tables, partitions, views, materialized views, functions, procedures, sequences, types, domains, and extensions.

SQL editor

Ready

Completion, hover, and diagnostics that understand schema-qualified names and CTEs.

Rich types

Ready

UUID, JSONB, arrays, enums, domains, ranges, inet, and tsvector display as readable values.

Visual EXPLAIN

Ready

Plans as a graph with costs, suggestions, and partition pruning.

Designers

Ready

Table, trigger, and sequence designers, plus forms for domains, enums, and procedures.

In the app

Connecting

Host, port, database, user, and password, with SSL mode (disable through verify-full), client certificates, and an optional SSH tunnel.

← All databases