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. You can also connect to Timescale, and Managed Service for TimescaleDB services.
- Download and install DBeaver.
Sign in to the Timescale portal.
Servicestab, find the service you want to connect to, and check it is marked as
Click the name of the service you want to connect to, and take a note of the
Database name, and
- 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.
New Database Connection.
Connect to a databasewindow, search for
Maintab type the details for your connection, including the
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
Use SSL, set
verify-full, and in the
CA Certificatefield, type the location of the SSL root CA certificate to use.
Test Connectionbutton to check if the connection is successful.
Finishbutton to connect to the database server. The server is listed in the
This table provides the description and example values for the fields that
appear in the
Main tab of
|Host||localhost, postgresql.example.com, <REMOTE_HOST>.tsdb.cloud.timescale.com, <REMOTE_HOST>.timescaledb.io||The fully qualified server name. The host name of your Timescale service or Managed Service for TimescaleDB service.|
|Port||5432||The port number of the TimescaleDB server, Timescale service or Managed Service for TimescaleDB service.|
|Username||postgres, tsdbadmin||The user name you want to log in with. Use |
|Password||password||The password for the database user you are connecting to.|
|Save password locally||Check||Check this box if you don't want to enter the password each time you connect.|
|Database||tsdb, defaultdb||This option connects to the default database. The database name for a Timescale service is |
Found an issue on this page?Report an issue!