Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.

  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. 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 Azure Data Studio.

  6. In the SERVERS page, click New Connection.

  7. In the Connection Details dialog, navigate to Connection type, and select PostgreSQL. Fill in the fields using the server name, database, user name, port, and password for your Timescale service. For more information about these settings, see the connection details section.

  8. Click Advanced.

  9. In the Port field, type the port number, and click OK.


    If you configured your Timescale service to connect using SSL mode, then set SSL mode to Verify-Full, and in the SSL root certificate filename field, type the location of the SSL root CA certificate to use.

  10. Click Connect.

    Connecting to Timescale using Azure Data Studio

This table provides the description and example values for the fields in the Connection Details dialog.

SettingExample valueDescription
Server namelocalhost,, <REMOTE_HOST> fully qualified server name. The host name of your Timescale service.
Authentication typePasswordThe authentication type to log in with
User namepostgres, tsdbadminThe user name you want to log in with. Use tsdbadmin for Timescale services
PasswordpasswordThe password for the account you are logging in with
Remember passwordCheckCheck this box if you don't want to enter the password each time you connect.
Database name<Default>, tsdbThis 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.
Server group<Default>This option lets you assign this connection to a specific server group you create.
Name (optional)leave blankThis option lets you specify a friendly name for your server


Found an issue on this page?

Report an issue!