Connect to PostgreSQL
Connect your PostgreSQL database to VexiData for natural language querying and dashboard creation.
Connect your PostgreSQL database to VexiData for natural language querying and dashboard creation. Connection takes about 2 minutes.
Prerequisites
- A VexiData account (free tier available)Create account
- PostgreSQL database (version 12 or higher)
- Database credentials: hostname, port, database name, username, and password
- Network access from VexiData to your database (port 5432 open)
Connection Steps#
Navigate to Data Sources
From your VexiData dashboard, click on Data Sources in the menu.
Select PostgreSQL
Under the Add New Data Source section, click on PostgreSQL to open the connection dialog. VexiData supports PostgreSQL versions 12, 13, 14, 15, and 16.
Enter Connection Details
Fill in your PostgreSQL connection information. Here's what each field means:
Display Name: My Production Database (any name you choose)
Host: your-database-host.com or IP address
Port: 5432 (default PostgreSQL port)
Database: your_database_name
Username: vexidata_readonly
Password: your_secure_passwordConfigure SSL (Recommended)
For production databases, enable SSL for encrypted connections. VexiData supports require and verify-full SSL modes. Most cloud providers (AWS RDS, Azure, Google Cloud SQL) have SSL enabled by default.
Test Connection
Click the Test Connection button to verify VexiData can reach your database. If successful, you'll see a green checkmark. If the test fails, check the troubleshooting section below.
Save and Start Querying
Once the test passes, click Save Connection. VexiData will automatically detect your schema (tables, columns, and relationships). You can now start asking questions in natural language like "Show me sales from last month" or "What are my top customers?"