PostgreSQL Connector
Free
Integrations
Connect directly to PostgreSQL databases and sync tables
Ready to Simplify Your Work?
Install your first app in 30 seconds. No credit card required.
Cookie Preferences
We use essential cookies for security and access. Optional cookies stay off unless you choose them, and embedded dashboards run in essential-only mode.
How It Works
1
Configure Connection: Enter host, port, database, and credentials
2
Test Connection: Verify connectivity before saving
3
Browse Schema: See available tables and views
4
Create Virtual Entity: Map a table to a Nixa entity
5
Sync Data: Data flows in automatically on schedule
Connection Options
Connect to databases your way:
Standard Connection — : Host, port, database, username, password
Connection String — : Paste a full PostgreSQL connection URI
SSL/TLS — : Secure connections with certificate validation
Read-Only Mode — : Optional read-only enforcement for safety
Schema Discovery
The connector reads your database structure:
Automatic Detection — : Discovers tables, views, and columns
Type Mapping — : Maps PostgreSQL types to Nixa field types
Primary Keys — : Identifies primary keys for record matching
Relationships — : Detects foreign key relationships
Sync Features
Keep your data fresh:
Scheduled Sync — : Automatic updates on a schedule
Incremental Sync — : Only sync changed records using timestamps
Full Refresh — : Complete re-sync when needed
Custom Queries — : Write SQL for complex data extraction
Security
Your database credentials are protected:
Encrypted Storage — : Credentials encrypted at rest
IP Whitelisting — : Works with firewall rules
Connection Pooling — : Efficient resource usage
Perfect For
Legacy Integration — : Connect to existing systems
Data Warehousing — : Pull from reporting databases
Cross-System Sync — : Share data between platforms
Analytics — : Use external data in Nixa dashboards
Screenshots
Integrations