Vertica Schemas Visualized for Analytics Teams

DbSchema renders Vertica's logical layer — tables, views, sequences, and their relationships — as ER diagrams, and gives analytics engineers a desktop workbench for designing, comparing, and querying the columnar warehouse.

See table relationships and view dependencies per schema
Edit entities on the canvas and review the generated Vertica DDL
Run window functions and time-series aggregations without vsql
Keep a browsable schema reference that needs no cluster login

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema visualizing a Vertica analytical schema as an ER diagram

Trusted by teams at

Projections Optimize the Storage
and Bury the Logical Model

Vertica physically stores each table as projections — sorted, segmented, multiplied for performance. Powerful for scans, but as projections accumulate, the question "how do these tables actually relate?" gets harder to answer from the catalog.

DbSchema keeps the logical layer in front of you: entities, relationships, and view dependencies on a diagram, unobscured by the physical design underneath.

Model, Compare & Query
the Columnar Warehouse

Schema work for analytics engineers who would rather not live in vsql.

Reverse engineer a Vertica logical schema into an ER diagram

The Logical Layer, Reverse Engineered

Connect to any node — Vertica routes the session — and import tables, views, and sequences from each schema into a navigable diagram.

Compare Vertica environments and generate migration DDL

Environments That Stay in Step

Diff the model against development and production clusters, review each difference, and generate the migration DDL that closes the gap.

Run analytical Vertica SQL from the DbSchema editor

Analytical SQL, Desktop Comfort

Window functions, time-series aggregations, approximate queries — authored with syntax highlighting and tabulated results instead of a terminal pager.

Design on the Model,
Not on the Cluster

Your Vertica schema lives in a DbSchema model file as well as on the cluster — and the file is where experiments, reviews, and sign-offs belong.

No Cluster Required

Draft new fact and dimension tables while disconnected from every environment.

Pull-Request the Schema

Commit the model beside the ELT code and let reviewers see schema diffs in context.

Inspect generated Vertica DDL before running it

DDL in Plain Sight

Each canvas edit maps to statements you read before they run anywhere.

Promote reviewed changes across Vertica environments

Promote With Intent

Apply the identical reviewed change to test and production, each on its own approval.

Vertica Connection Basics

Register the Vertica JDBC driver from the Vertica client drivers download page in DbSchema's driver manager, then connect to port 5433 — the JDBC URL is jdbc:vertica://host:5433/dbname. The node's firewall must allow inbound TCP on 5433 from your workstation; in multi-node clusters any node works, since Vertica routes the session internally.

Setup reference: the Vertica JDBC driver page.