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

# Aiven

> Connect your Aiven PostgreSQL, MySQL, or MariaDB database to VexiData.

## Prerequisites

* An [Aiven](https://console.aiven.io) account with a PostgreSQL, MySQL, or MariaDB service
* A [VexiData](https://vexidata.com) account

## Connect Aiven to VexiData

<Steps>
  <Step title="Get your connection details">
    1. Log in to the [Aiven Console](https://console.aiven.io)
    2. Select your service
    3. On the **Overview** page, find the connection details at the top

    | Parameter    | Example                      |
    | ------------ | ---------------------------- |
    | **Host**     | `pg-abc123.aivencloud.com`   |
    | **Port**     | `20985` (varies per service) |
    | **Database** | `defaultdb`                  |
    | **Username** | `avnadmin`                   |
    | **Password** | Your service password        |

    <Note>
      Aiven assigns a **non-standard port** to each service. Make sure you copy the exact port — it won't be `5432` or `3306`.
    </Note>
  </Step>

  <Step title="Add the connection in VexiData">
    1. Go to [Data Sources](https://vexidata.com/data-sources) in VexiData
    2. Click **PostgreSQL**, **MySQL**, or **MariaDB** depending on your service type
    3. Fill in the details:

    | Field            | Value                                                         |
    | ---------------- | ------------------------------------------------------------- |
    | **Display Name** | A name to identify this connection (e.g., "Aiven Production") |
    | **Host**         | Your service hostname (e.g., `pg-abc123.aivencloud.com`)      |
    | **Port**         | Your service port (e.g., `20985`)                             |
    | **Database**     | `defaultdb` (or your database name)                           |
    | **Schema**       | `public` (PostgreSQL only)                                    |
    | **Username**     | `avnadmin` (or your user)                                     |
    | **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>
  Aiven allows connections from all IPs by default. You only need to add VexiData's IP (`46.101.71.122`) if you've configured a custom 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 Aiven Console — not `5432` or `3306`
    * If you've configured an IP allowlist, make sure VexiData's IPs are included
    * Check that your service is running in the Aiven Console
  </Accordion>

  <Accordion title="Authentication failed">
    * Double-check your username and password from the service **Overview** page
    * The default username is `avnadmin`. If you created a custom user, make sure it has access to the database
  </Accordion>

  <Accordion title="No tables visible after connecting">
    * The default database is `defaultdb`. If your tables are in a different database, update the **Database** field
    * For PostgreSQL, confirm your tables are in the `public` schema
  </Accordion>
</AccordionGroup>