Design and Manage Exasol Databases Visually with DbSchema

DbSchema lets you design, manage, and document Exasol databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the Exasol database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download Exasol JDBC Driver

Visualizing Exasol Schemas and Virtual Schemas

Exasol is an in-memory columnar database engineered for extreme analytical query throughput. It supports both standard schemas and virtual schemas — virtual schemas provide a read-only projection over external data sources such as Amazon S3, Hive, or relational databases, exposed through the same SQL interface as native tables. DbSchema connects to Exasol via JDBC and renders both schema types as ER diagrams, giving analytics engineers a unified view of physical and virtual table structures alongside their relationships, without switching between the Exasol client and other documentation tools.

Design Exasol Schemas in the Visual Editor

DbSchema's diagram editor lets you create and edit Exasol tables, select column types suited to Exasol's analytical SQL dialect, and define constraints and relationships on the canvas. The editor generates Exasol-compatible DDL that can be applied directly or exported as a migration script for peer review.

Designing an Exasol data warehouse schema visually in DbSchema

Write and Execute Exasol SQL

The SQL editor in DbSchema supports Exasol's SQL syntax with highlighting and result display in a tabular grid. Write analytical queries — including Exasol-specific functions and window operations — and execute them directly against the in-memory engine to take advantage of its sub-second response times for large aggregations.

Writing and running Exasol analytical SQL in the DbSchema SQL editor

Explore and Validate Table Data

The data explorer lets you browse Exasol table contents row by row, apply column filters, and paginate through results without writing a query. Use this to verify ETL pipeline output, audit data quality after batch loads, or inspect the contents of virtual schema tables backed by external sources.

Browsing Exasol table data interactively in the DbSchema data explorer

Connecting DbSchema to Exasol

Exasol's default JDBC port is 8563. Download the Exasol JDBC driver from the Exasol download portal and register it via DbSchema's driver manager. The JDBC URL format is jdbc:exa:host:8563. For EXACloud or self-hosted deployments with TLS enabled, use the cluster's primary IP address. On non-production environments using self-signed certificates, append ;validateservercertificate=0 to suppress certificate validation errors during initial setup.

Why Teams Use DbSchema with Exasol

  • Visualize both physical schemas and virtual schemas in a unified ER diagram
  • Write Exasol SQL with syntax support and execute against the in-memory engine
  • Explore and validate table data interactively without a separate query client
  • Document the Exasol data warehouse schema for analytics team reference
  • Design schema changes visually and generate Exasol-compatible DDL for deployment