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

• Download and install Azure Data Studio.
• Install the PostgreSQL extension for Azure Data Studio.

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 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 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.

   

Settings in the Connection Details

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