Design and Manage TimescaleDB Databases Visually with DbSchema

DbSchema lets you design, manage, and document TimescaleDB 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 TimescaleDB database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

Download DbSchema Download TimescaleDB JDBC Driver

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.

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