Connect to TimescaleDB using Azure Data Studio

Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux. You can connect to TimescaleDB hosted on your local machine or on a remote server. You can also connect to Timescale Cloud, and Managed Service for TimescaleDB services.

Before you begin

Connecting to on-premise TimescaleDB using Azure Data Studio

  1. Start Azure Data Studio.

  2. In the SERVERS page, click New Connection.

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

  4. Click Advanced.

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

  6. Click Connect.

    Connecting to TimescaleDB using Azure Data Studio

Connecting to Timescale Cloud with Azure Data Studio

  1. Sign in to the Timescale Cloud 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 Cloud 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 TimescaleDB Cloud 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.

    note

    If you configured your Timescale Cloud 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 Cloud using Azure Data Studio

Connecting to Managed Service for TimescaleDB with Azure Data Studio

important

To ensure a secure network access to your Managed Service for TimescaleDB service, make sure you add the IP address of the machine running Azure Data Studio to the Allowed IP Addresses. For more information about network security in Managed Service for TimescaleDB, see the security section.

  1. Sign in to the Managed Service for TimescaleDB 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 see the connection information. Take a note of the Host, Port, Database Name, User, and Password.

  4. Start Azure Data Studio.

  5. In the SERVERS page, click New Connection.

  6. 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 Managed Service for TimescaleDB service. For more information about these settings, see the connection details section.

  7. Click Advanced.

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

  9. Click Connect.

    Connecting to Managed Service for TimescaleDB using Azure Data
Studio

Settings in the Connection Details

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

SettingExample valueDescription
Server namelocalhost, postgresql.example.com, <REMOTE_HOST>.tsdb.cloud.timescale.com, <REMOTE_HOST>.timescaledb.ioThe fully qualified server name. The host name of your Timescale Cloud service or Managed Service for TimescaleDB service.
Authentication typePasswordThe authentication type to log in with
User namepostgres, tsdbadminThe user name you want to log in with. Use tsdbadmin for Timescale Cloud service and Managed Service for TimescaleDB service
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>, tsdb, defaultdbThis option connnects to the default database. The database name for Timescale Cloud service is tsdb and for Managed Service for TimescaleDB service is defaultdb. 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