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
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:
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 IP (46.101.71.122) 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