Skip to content
Search ⌘K
Get started

Connect to Tiger Data

Connect to Tiger Cloud, self-hosted TimescaleDB, or MST using any PostgreSQL client

To connect to your service or self-hosted TimescaleDB instance, you need at least the following:

  • Hostname
  • Port
  • Username
  • Password
  • Database name

Once you have these, connect using any PostgreSQL client. Find the connection methods and details for your product:

Connect to your Tiger Cloud service in any of these ways:

  • Data view or SQL editor in Tiger Console: run queries in your browser, with no local client required.
  • psql or any other PostgreSQL client: use the connection details below with psql, or any PostgreSQL-compatible client or SQL editor.

Retrieve the connection details for your Tiger Cloud service:

  • In <service name>-credentials.txt:

    All connection details are supplied in the configuration file you download when you create a new service.

  • In Tiger Console:

    Open the Services page and select your service. The connection details, except the password, are available in Service info > Connection info > More details. If necessary, click Forgot your password? to get a new one.

    Service connection details in Tiger Console

Find your project and service ID

Section titled “Find your project and service ID”

To retrieve the connection details for your Tiger Cloud project and Tiger Cloud service:

  1. Retrieve your project ID

    In Tiger Console, click the arrows next to the project name in the top left. The project ID is under the project name.

    Retrieving the project ID in Tiger Console
  2. Retrieve your service ID

    Click the dots next to the service, then click Copy next to the service ID.

    Retrieving the service ID in Tiger Console

Create client credentials

Section titled “Create client credentials”

You use client credentials to obtain access tokens outside of the user context.

To retrieve the connection details for your Tiger Cloud project for programmatic usage such as Terraform or the Tiger Cloud REST API:

  1. Open the settings for your project

    In Tiger Console, click Settings.

  2. Create client credentials

    1. Click Create credentials, then copy Public key and Secret key locally.

      Creating client credentials in Tiger Console

      This is the only time you see the Secret key. After this, only the Public key is visible in this page.

    2. Click Done.