Skip to main content

​
Prerequisites

​
Internal vs external connections

Render provides two connection URLs for each database:
External URLInternal URL
Host*.render-postgres.com*.render.internal
Accessible fromAnywhere on the internetOnly Render services in the same region
Use forExternal tools like VexiDataYour Render-hosted applications
VexiData requires the External URL. The internal URL (.render.internal) is only reachable from services running inside Render’s network.

​
Connect Render to VexiData

1

Get your Render connection details

  1. Log in to your Render Dashboard
  2. Click PostgreSQL in the left sidebar
  3. Select the database you want to connect
  4. On the database’s Info page, scroll to the Connections section
  5. Find the External Database URL and copy the individual parameters:
ParameterExample
Hostdpg-abc123-a.oregon-postgres.render.com
Port5432
Databasemyapp_db
Usernamemyapp_db_user
PasswordYour database password
You can also copy the full External Database URL and extract the parameters from it. The format is: postgresql://USER:PASSWORD@HOST:5432/DATABASE
2

Add the connection in VexiData

  1. Go to Data Sources in VexiData
  2. Click PostgreSQL to open the connection form
  3. Fill in the details:
FieldValue
Display NameA name to identify this connection (e.g., “Render Production”)
HostYour external hostname (e.g., dpg-abc123-a.oregon-postgres.render.com)
Port5432
DatabaseYour database name
Schemapublic (default — change if your tables are in a different schema)
UsernameYour database username
PasswordYour database 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.

​
Connection pooling with PgBouncer

If your database is approaching its connection limit, Render offers built-in PgBouncer connection pooling. When enabled, you’ll get a separate pooler connection string. To use the pooler with VexiData, copy the External URL from the connection pool (not the database directly) and use those credentials in VexiData instead.

​
Troubleshooting

  • Make sure you’re using the External connection URL, not the Internal one. Internal URLs (.render.internal) are only accessible from within Render’s network
  • Check that your database is in an Available state in the Render dashboard
  • Render free-tier databases expire after 90 days — verify your database hasn’t been deleted
  • Double-check your username and password from the database’s Info page in Render
  • Render generates credentials automatically — make sure you copied them from the dashboard, not from your application’s environment variables (which may be outdated)
  • Confirm your tables are in the public schema. If they’re in a custom schema, update the Schema field in VexiData
  • Check that your database user has SELECT permissions on the tables you want to query
  • Render databases have connection limits based on your plan. Consider enabling PgBouncer connection pooling in your Render database settings
  • Use the pooler’s external URL in VexiData instead of the direct database URL