Prerequisites
Understanding Neon connection modes
Neon offers two ways to connect — with or without connection pooling. The difference is in the hostname:| Pooled Connection | Direct Connection | |
|---|---|---|
| Host | ep-[name]-[id]-pooler.[region].aws.neon.tech | ep-[name]-[id].[region].aws.neon.tech |
| Port | 5432 | 5432 |
| Best for | Short-lived, on-demand connections | Persistent, long-running connections |
| How to identify | Host contains -pooler | Host does not contain -pooler |
Connect Neon to VexiData
Get your Neon connection details
- Log in to your Neon Console
- Select the project you want to connect
- In the Dashboard, find the Connection Details widget
- Select the Branch and Database you want to connect (Neon projects can have multiple branches)
- Make sure Pooled connection is toggled on (recommended)
- Switch to the Parameters only view to see the individual values:
| Parameter | Example |
|---|---|
| Host | ep-cool-forest-123456-pooler.us-east-2.aws.neon.tech |
| Port | 5432 |
| Database | neondb |
| Username | neondb_owner |
| Password | Your database password |
If you don’t see the password, click Show password or Reset password in the Connection Details widget. You can also find connection strings under Project Settings > Connection String.
Whitelist VexiData's IP addresses (if needed)
If your Neon project has IP Allow enabled (available on paid plans), add VexiData’s IP addresses to your trusted list:
139.59.53.167165.22.217.42
By default, Neon allows connections from all IP addresses. You only need this step if you have explicitly enabled IP Allow.
Add the connection in VexiData
- Go to Data Sources in VexiData
- Click PostgreSQL to open the connection form
- Fill in the details:
| Field | Value |
|---|---|
| Display Name | A name to identify this connection (e.g., “Neon Production”) |
| Host | ep-[name]-[id]-pooler.[region].aws.neon.tech |
| Port | 5432 |
| Database | neondb (or your database name) |
| Schema | public (default — change if your tables are in a different schema) |
| Username | Your Neon database username |
| Password | Your database password |
Neon branches
Neon supports database branching — each branch has its own connection string. When connecting to VexiData, make sure you select the correct branch in the Neon Connection Details widget before copying credentials. If you want to connect multiple branches (e.g., production and staging), create a separate data source in VexiData for each one.Troubleshooting
Connection timed out
Connection timed out
- Verify that VexiData’s IP addresses are added to your IP Allow list if the feature is enabled
- Check that you’re using the correct host — pooled connections include
-poolerin the hostname - Neon computes auto-suspend after inactivity. The first connection after suspension may take a few seconds to wake up — try again if it times out
Authentication failed
Authentication failed
- Double-check your username and password in the Neon Console under Connection Details
- If you’ve forgotten your password, reset it from the Neon Console
- Make sure you’re connecting to the correct branch — each branch has its own credentials
No tables visible after connecting
No tables visible after connecting
- Confirm your tables are in the
publicschema. If they’re in a custom schema, update the Schema field in VexiData - Check that you selected the correct Database and Branch when copying credentials from Neon
Connection drops or is slow
Connection drops or is slow
- Neon’s free tier has compute limits and auto-suspends after 5 minutes of inactivity. The cold start when waking up can cause brief delays
- Consider upgrading to a paid Neon plan for always-on compute and better performance