TimescaleDB Hypertables, Mapped Visually

DbSchema gives TimescaleDB teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for relational modeling, migration planning, and SQL-first collaboration, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See TimescaleDB Features Download TimescaleDB JDBC Driver · All drivers

Visualize TimescaleDB Hypertables Alongside Regular Tables

TimescaleDB extends PostgreSQL with hypertables — tables that are automatically partitioned by time under the hood — along with continuous aggregates and time-bucket functions for efficient time-series analysis. Because TimescaleDB is fully PostgreSQL-compatible at the protocol and SQL level, DbSchema connects using the standard PostgreSQL JDBC driver. Hypertables appear in the diagram canvas alongside ordinary PostgreSQL tables, and the complete PostgreSQL type system, foreign key relationships, and index metadata are all available for inspection.

The free Community edition covers this reverse engineering workflow end to end — schema discovery, diagram layout, and visual table editing. Pro layers in an offline design model with Git integration, schema comparison and migration script generation, and interactive HTML5 documentation export, with a 15-day Pro trial included in the same download.

Run TimescaleDB Time-Series SQL with Full PostgreSQL Syntax Support

TimescaleDB extends standard PostgreSQL with time-series functions including time_bucket, first, and last. DbSchema's SQL editor accepts the full PostgreSQL syntax and lets you write, run, and iterate on time-series queries against hypertables directly — no separate psql session or third-party client required.

Download DbSchema Free See TimescaleDB Features

Explore Hypertable and Continuous Aggregate Data

Continuous aggregates in TimescaleDB are materialized views refreshed on a schedule. The data explorer lets you page through both raw hypertable rows and the contents of continuous aggregate views — practical for verifying that a scheduled refresh completed correctly or for spot-checking recent measurements.

Auto-Document Your TimescaleDB Schema

DbSchema generates structured HTML documentation for the entire database schema, covering hypertables, regular tables, continuous aggregate views, column types, and foreign key relationships. Annotate columns with descriptions in the model and those notes are included in the export — useful for onboarding engineers to time-series data pipelines.

Set Up the TimescaleDB Connection in DbSchema

Because TimescaleDB is a PostgreSQL extension, the connection uses the same parameters you would use for any PostgreSQL database:

1. Install DbSchema — no signup is required for the download.
2. Create a new connection and choose PostgreSQL as the database type; DbSchema downloads the PostgreSQL JDBC driver automatically, so no separate installation is needed.
3. Enter the host, the default port 5432, the database name, username, and password, matching the JDBC URL jdbc:postgresql://host:5432/dbname.
4. Connect — the TimescaleDB extension is transparent to the JDBC layer, so DbSchema reads hypertable metadata through the standard PostgreSQL system catalog exactly as it would for a plain PostgreSQL instance.

What TimescaleDB Users Gain from DbSchema

• Visualize hypertables, regular tables, and continuous aggregates in one diagram
• Run TimescaleDB SQL including time_bucket, first, and last functions
• Inspect hypertable chunk metadata via the standard schema view
• Document schemas and share with data engineers unfamiliar with TimescaleDB internals
• Compare schema definitions across staging and production databases to catch drift

Your hypertables deserve the same visual clarity as the rest of your schema. Download DbSchema for free and diagram your TimescaleDB time-series data alongside every other table in minutes.