Connect to DigitalOcean
Learn how to connect your DigitalOcean Managed PostgreSQL database to VexiData for natural language querying and dashboard creation.
Connect your DigitalOcean Managed PostgreSQL database to VexiData for natural language querying and dashboard creation. Connection takes about 2 minutes.
Connect DigitalOcean to VexiData
Click to play video
Prerequisites
- A VexiData account (free tier available)Create account
- A DigitalOcean account with a Managed PostgreSQL databaseDigitalOcean Databases
- Access to your DigitalOcean database credentials
Connection Steps#
Log in to DigitalOcean
Access your DigitalOcean account at cloud.digitalocean.com and navigate to the Databases section from the left sidebar.
Select Your Database
In the database listing, select the PostgreSQL database you want to connect with VexiData. If you don't have a database yet, create a new one.
Get Connection Details
From the Connection Details section, gather the following information:
• Host Address: Your database hostname (e.g., db-postgresql-xxx.ondigitalocean.com)
• Port: Usually 25060 for managed databases
• Username: Your database username (default is doadmin)
• Password: Your database password
• Database Name: The name of your database (default is defaultdb)
Add Trusted Sources
If Trusted Sources is enabled in your database settings, add VexiData's IP addresses:
• 139.59.53.167
• 165.22.217.42
Go to your database settings > Trusted Sources > Add both IP addresses.
Connect in VexiData
In VexiData, go to Data Sources from the menu, then select PostgreSQL under the Add New Data Source section.
Display Name: My DigitalOcean Database
Host: db-postgresql-xxx.ondigitalocean.com
Port: 25060
Database: defaultdb
Username: doadmin
Password: your_database_passwordTest and Save
Click Test & Save Connection. Once successful, you can start querying your DigitalOcean data!