How to Connect Your DigitalOcean PostgreSQL Database to Indiequery

Last updated: November 21, 2025

Connect your DigitalOcean Managed PostgreSQL database to Indiequery to query and explore data through a web interface. Get your connection details from the DigitalOcean control panel and connect in minutes.

Get Connection Details from DigitalOcean

Log into cloud.digitalocean.com/databases and click on your PostgreSQL database cluster. On the Overview page, find the Connection Details section at the top.

You'll see dropdown menus to select your network type, database, user, and connection format. For Indiequery, choose Public network (not VPC network) and select Connection parameters to see the individual connection details.

DigitalOcean provides these connection parameters:

  • Host - Database hostname ending in .db.ondigitalocean.com
  • Port - Usually 25060 (not the default PostgreSQL port 5432)
  • Database - Your database name (default is defaultdb)
  • User - Your database username (default is doadmin)
  • Password - Click the eye icon to reveal the password

Connect to Indiequery

Navigate to app.indiequery.com and click Add Database Connection. Enter the connection parameters from DigitalOcean:

  1. Host - The hostname from DigitalOcean (ending in .db.ondigitalocean.com)
  2. Port - Enter the port shown (usually 25060)
  3. Database - Your database name (check the dropdown in DigitalOcean)
  4. Username - Your database username
  5. Password - Click the eye icon in DigitalOcean to reveal, then copy
  6. Keep "Require SSL" checked (DigitalOcean requires SSL for all connections)
  7. Name your connection (e.g., "DigitalOcean Production")
  8. Click Add Connection Indiequery tests the connection automatically. If successful, you're ready to query.

Add Indiequery to Trusted Sources

DigitalOcean's Trusted Sources feature restricts database access to specific IP addresses. This is available on all managed database plans and recommended for production databases.

On your database cluster page, click the Settings tab and scroll to the Trusted Sources section. Click Edit or Add trusted sources and add Indiequery's IP address: 91.98.141.61

You can enter it as an individual IP (91.98.141.61) or use CIDR notation (91.98.141.61/32). Click Save when done. Now only whitelisted IPs can connect to your database while internal DigitalOcean resources in the same VPC can still connect using the VPC network connection.

Use Read-Only Nodes for Safer Querying

DigitalOcean lets you create read-only replica nodes that stay synced with your primary database. These nodes are read-only by default, so you can't accidentally write or modify data. Query load also doesn't impact your primary database.

To create a read-only node, go to your database cluster's Settings tab and scroll to Add read-only node. Choose a region (same or different from primary), select a node size, and click Create read-only node. Creation takes a few minutes.

When the status shows Active, go to the Overview page and use the Database/User dropdown to select the read-only node. The connection details will update to show the replica's credentials. Copy these connection parameters (host, port, database, username, password) and use them in Indiequery instead of the primary database connection.

Common Connection Issues

"Connection refused" or "Connection timed out"

Verify you selected "Public network" in DigitalOcean connection details and that Indiequery's IP (91.98.141.61) is in your Trusted Sources list. Confirm your database cluster status shows Online and you're using port 25060, not 5432.

"SSL connection required"

DigitalOcean requires SSL for all connections. Keep the "Require SSL" checkbox checked in Indiequery.

"Authentication failed"

Click the eye icon in DigitalOcean to reveal the password. Passwords are long alphanumeric strings, so copy carefully. Verify you selected the correct database and user in the dropdown.

"Database does not exist"

Check the database name in your connection details. The default database is defaultdb, but you may have created custom databases. Select the correct database in DigitalOcean's Database/User dropdown.

Next Steps

Once connected:

  • Browse database schema and tables
  • Run SQL queries with autocomplete
  • Create visualizations from results
  • Save and reuse queries
  • Build dashboards
  • Share results publicly Navigate to the query editor and start exploring your DigitalOcean database.
← Back to Hosting Integration