Skip to main content

​
Prerequisites

  • An Aiven account with a PostgreSQL, MySQL, or MariaDB service
  • A VexiData account

​
Connect Aiven to VexiData

1

Get your connection details

  1. Log in to the Aiven Console
  2. Select your service
  3. On the Overview page, find the connection details at the top
ParameterExample
Hostpg-abc123.aivencloud.com
Port20985 (varies per service)
Databasedefaultdb
Usernameavnadmin
PasswordYour service password
Aiven assigns a non-standard port to each service. Make sure you copy the exact port — it won’t be 5432 or 3306.
2

Add the connection in VexiData

  1. Go to Data Sources in VexiData
  2. Click PostgreSQL, MySQL, or MariaDB depending on your service type
  3. Fill in the details:
FieldValue
Display NameA name to identify this connection (e.g., “Aiven Production”)
HostYour service hostname (e.g., pg-abc123.aivencloud.com)
PortYour service port (e.g., 20985)
Databasedefaultdb (or your database name)
Schemapublic (PostgreSQL only)
Usernameavnadmin (or your user)
PasswordYour service password
3

Test and save

Click Test & Save Connection. VexiData will verify it can reach your database. Once connected, your schema will be analyzed automatically.
Aiven allows connections from all IPs by default. You only need to add VexiData’s IPs (139.59.53.167 and 165.22.217.42) if you’ve configured a custom IP allowlist in your service settings.

​
Troubleshooting

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