Design and Manage TimescaleDB Databases with DbSchema
Build a clearer workflow for TimescaleDB: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for relational modeling, migration planning, and SQL-first collaboration. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See TimescaleDB Features Download TimescaleDB JDBC Driver
What happens after you download?
Get to your first TimescaleDB schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to TimescaleDB or open a sample
Reverse engineer an existing TimescaleDB database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
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.
Run 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.
Connecting to TimescaleDB
TimescaleDB uses the same connection parameters as a standard PostgreSQL database: host,
port 5432, database name, username, and password. The JDBC URL is
jdbc:postgresql://host:5432/dbname. DbSchema downloads the PostgreSQL JDBC driver
automatically — no separate installation is needed. The TimescaleDB extension is transparent to
the JDBC layer; DbSchema connects to a TimescaleDB instance exactly as it would to a plain
PostgreSQL database, and hypertable metadata is accessible through the standard PostgreSQL
system catalog.
Why Use DbSchema with TimescaleDB
- 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