Turn Your Exasol Warehouse into a Visual Schema Model

DbSchema connects to Exasol over JDBC and imports standard schemas together with the virtual schemas that project S3, Hive, or other databases — then turns the warehouse into ER diagrams, documentation, and reviewed DDL.

Import standard and virtual schemas into one navigable diagram

Query the in-memory engine from a schema-aware SQL editor

Publish HTML documentation the analytics team opens in a browser

Design changes offline and hand the DDL to peer review

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

The Warehouse Answers in Seconds
Explaining It Takes Days

An Exasol cluster accumulates structure fast: native tables for the marts, plus virtual schemas projecting S3 buckets, Hive tables, and remote databases through the same SQL interface. Which dashboard reads physical data and which reads external sources is knowledge that tends to live in one engineer's head.

DbSchema imports both schema types into a single model — diagrammed, documented, and versioned alongside your ETL code.

Model, Query & Document
the Exasol Warehouse from One Tool

Structure first, queries second, documentation for free.

Reverse engineer Exasol standard and virtual schemas into an ER diagram

Virtual Schemas Included, Not Ignored

Connect to the cluster and DbSchema lays out tables, keys, and relationships from every schema — including the virtual ones over external sources — as one ER diagram.

Write Exasol analytical SQL in the DbSchema SQL editor

Analytical SQL With the Schema in Sight

Write window functions and Exasol-specific aggregations with table and column autocompletion, run them against the in-memory engine, and export the results grid.

Generate HTML documentation for an Exasol data warehouse

Warehouse Docs Nobody Maintains by Hand

One click exports interactive HTML5 documentation — searchable diagrams, comments, hover details — that analysts read in a browser instead of querying system tables.

Warehouse DDL That Goes
Through Code Review

The design model is a file in your repository: branch it, diff it, and pull-request schema changes like the ETL code around them. After approval, DbSchema compares the model against the cluster and generates the Exasol DDL you read before it runs.

Exasol Connection Facts

Register the Exasol JDBC driver — downloaded from the Exasol download portal — in DbSchema's driver manager, then connect on the default port 8563 with a URL of the form jdbc:exa:host:8563. For EXACloud or self-hosted deployments with TLS enabled, use the cluster's primary IP address as the host.

On non-production environments with self-signed certificates, appending ;validateservercertificate=0 to the URL suppresses certificate validation errors during initial setup. Once connected, DbSchema pulls in standard and virtual schemas alike. Setup details are on the Exasol JDBC driver page.

Cookie preferences

Turn Your Exasol Warehouse into a Visual Schema Model

The Warehouse Answers in SecondsExplaining It Takes Days

Model, Query & Documentthe Exasol Warehouse from One Tool