DBeaver is a free and open source database tool that is available for Microsoft Windows, Apple macOS, and many Linux versions. DBeaver provides a powerful SQL editor, administration features, ability to migrate data and schema, and the ability to monitor database connection sessions. You can connect to Timescale hosted on your local machine or on a remote server or a Timescale service.

  1. Sign in to the Timescale portal.

  2. In the Services tab, find the service you want to connect to, and check it is marked as Running.

  3. Click the name of the service you want to connect to, and take a note of the Host, Port, Database name, and Username.

  4. OptionalIf you do not know the password for the service, navigate to the Operations tab, and click Reset password. You can choose your own password for the service, or allow Timescale to generate a secure password for you. Take a note of your new password.

  5. Start DBeaver.

  6. In the Database menu, click New Database Connection.

  7. In the Connect to a database window, search for TimescaleDB.

  8. Select TimescaleDB and click Next to continue.

  9. In the Main tab type the details for your connection, including the Host, Port,Database, Username and Password. For more information about these settings, see the connection settings section.


    If you configured your Timescale service to connect using SSL mode, then in the SSL tab enable Use SSL, set SSL mode to verify-full, and in the CA Certificate field, type the location of the SSL root CA certificate to use.

  10. Click the Test Connection button to check if the connection is successful.

  11. Click the Finish button to connect to the database server. The server is listed in the Database Navigator pane.

    Connecting to Timescale using DBeaver

This table provides the description and example values for the fields that appear in the Main tab of Connection settings.

SettingExample valueDescription
Hostlocalhost, postgresql.example.com, <REMOTE_HOST>.tsdb.cloud.timescale.comThe fully qualified server name. The host name of your Timescale service.
Port5432The port number of the TimescaleDB server, Timescale service.
Usernamepostgres, tsdbadminThe user name you want to log in with. Use tsdbadmin for Timescale services
PasswordpasswordThe password for the database user you are connecting to.
Save password locallyCheckCheck this box if you don't want to enter the password each time you connect.
DatabasetsdbThis option connects to the default database. The database name for a Timescale service is tsdb. You can also specify the name of the database to connect to.


Found an issue on this page?

Report an issue!