> ## Documentation Index
> Fetch the complete documentation index at: https://vexidata.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Timescale

> Connect your Timescale Cloud PostgreSQL database to VexiData.

## Prerequisites

* A [Timescale Cloud](https://console.cloud.timescale.com) account with a service
* A [VexiData](https://vexidata.com) account

## Connect Timescale to VexiData

<Steps>
  <Step title="Get your connection details">
    1. Log in to the [Timescale Console](https://console.cloud.timescale.com)
    2. Select your service
    3. Click the **Connection info** tab
    4. Copy the **Service URL** or individual parameters:

    | Parameter    | Example                                        |
    | ------------ | ---------------------------------------------- |
    | **Host**     | `abc123xyz.us-east-1.tsdb.cloud.timescale.com` |
    | **Port**     | `30133` (varies per service)                   |
    | **Database** | `tsdb`                                         |
    | **Username** | `tsdbadmin`                                    |
    | **Password** | Your service password                          |

    <Note>
      Timescale assigns a **non-standard port** to each service. Copy the exact port from the Connection info tab.
    </Note>

    If you've forgotten your password, click **Forgot your password?** in the Connection info tab to set a new one.
  </Step>

  <Step title="Add the connection in VexiData">
    1. Go to [Data Sources](https://vexidata.com/data-sources) in VexiData
    2. Click **PostgreSQL** to open the connection form
    3. Fill in the details:

    | Field            | Value                                                             |
    | ---------------- | ----------------------------------------------------------------- |
    | **Display Name** | A name to identify this connection (e.g., "Timescale Production") |
    | **Host**         | Your service hostname                                             |
    | **Port**         | Your service port (e.g., `30133`)                                 |
    | **Database**     | `tsdb` (or your database name)                                    |
    | **Schema**       | `public` (default)                                                |
    | **Username**     | `tsdbadmin`                                                       |
    | **Password**     | Your service password                                             |
  </Step>

  <Step title="Test and save">
    Click **Test & Save Connection**. VexiData will verify it can reach your database. Once connected, your schema will be analyzed automatically.
  </Step>
</Steps>

<Info>
  Timescale allows connections from all IPs by default. You only need to add VexiData's IP (`46.101.71.122`) if you've configured an IP allowlist in your service settings.
</Info>

## Troubleshooting

<AccordionGroup>
  <Accordion title="Connection timed out">
    * Verify you're using the correct **non-standard port** from the Connection info tab — not `5432`
    * If you've configured an IP allowlist, make sure VexiData's IPs are included
    * Check that your service is running in the Timescale Console
  </Accordion>

  <Accordion title="Authentication failed">
    * Double-check your credentials from the **Connection info** tab
    * Reset your password using the **Forgot your password?** option if needed
  </Accordion>

  <Accordion title="No tables visible after connecting">
    * Confirm your tables are in the `public` schema. Timescale hypertables are typically in `public`
    * Check that your user has `SELECT` permissions on the tables
  </Accordion>
</AccordionGroup>