Download TimescaleDB JDBC Driver

Download the TimescaleDB JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the TimescaleDB JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to TimescaleDB. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each TimescaleDB driver uses its own syntax — see the connection details below.

The TimescaleDB JDBC driver

TimescaleDB is a PostgreSQL extension that adds time-series capabilities — automatic partitioning by time (hypertables), compression, and continuous aggregates — to the standard PostgreSQL engine. It is widely used for IoT sensor data, financial tick data, DevOps metrics, and observability platforms.

TimescaleDB uses the standard PostgreSQL wire protocol, so DbSchema connects using the PostgreSQL JDBC driver.

The TimescaleDB JDBC URL

• Required File(s): postgresql-nn.jdbc3.jar
• Java Driver Class: org.postgresql.Driver
• JDBC URL: jdbc:postgresql://HOST[:PORT]/DB
• Website: PostgreSQL

If you want to connect to Heroku Postgresql web-based database, please edit the JDBC driver URL ( in Driver Manager dialog ) and append ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory in the end.

Download TimescaleDB JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

Connecting to a Self-Hosted TimescaleDB

TimescaleDB is an extension inside a PostgreSQL server, so reaching it means opening up that PostgreSQL server. A fresh installation accepts connections from its own machine only.

1. Let the server listen on the network. Set listen_addresses = '*' in postgresql.conf, whose location SHOW config_file; reveals. The default localhost accepts loopback connections only, and the parameter is read at start-up, so restart the service.
2. Allow your user to log in from your host. Add a record such as host all all 192.168.1.0/24 scram-sha-256 to pg_hba.conf, then apply it with SELECT pg_reload_conf();.
3. Open port 5432 in the server's firewall. The database listens on port 5432 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
4. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

Connect to the database that has the extension installed — SELECT * FROM pg_extension WHERE extname = 'timescaledb'; confirms it. Hypertables appear as ordinary tables plus their chunk tables, so a TimescaleDB schema reverse engineers like any other PostgreSQL schema.

Timescale Cloud

A managed service has no config files to edit. The service console gives you the host, port and database, and requires TLS.

1. Copy the JDBC URL from the Timescale console. You will find it in the service's connection information panel.
2. Paste the URL into DbSchema. In the Connection Dialog set Connection Mode to Edit the JDBC URL Manually and paste the string you copied. The user and the password are entered in the first tab, not in the URL.

DbSchema and TimescaleDB

TimescaleDB uses the standard PostgreSQL wire protocol, so DbSchema connects using the PostgreSQL JDBC driver and renders hypertables, chunk tables, and continuous aggregate views in the schema diagram.