Give Your AI Access to Approved Database Data
Connect PostgreSQL when your AI assistant needs live business data from approved tables. Use it for catalogs, pricing tiers, availability, locations, or operational data that changes too often for static FAQs.
Connect PostgreSQLSetup in 4 Simple Steps
Create a read-only database user
Use a least-privilege PostgreSQL user with access only to the schemas and tables the AI is allowed to query.
Add the connector
Enter the connection details in OnLeads and verify the database can be reached securely.
Allowlist tables and fields
Choose the tables, columns, and query patterns available to the AI for each widget.
Test sample questions
Run representative chat prompts to confirm answers use the right data and stay within your approved scope.
Deployment checklist
After setup, run a quick verification pass on your live site: open the widget on desktop and mobile, submit a test conversation, and confirm lead data arrives in your dashboard with the expected source and timeline fields.
If this integration syncs with external systems, validate one complete end-to-end flow. For example, confirm appointment data reaches your calendar or that qualified contacts are created in your CRM with the conversation context attached.
Why PostgreSQL Users Choose OnLeads
Live Business Data
Let visitors get answers from current database records instead of stale manually copied help content.
Read-Only by Design
Use read-only credentials and table allowlists so the AI can retrieve approved data without modifying your database.
Useful for Complex Catalogs
PostgreSQL works well for large product catalogs, pricing matrices, location data, availability records, and custom business objects.
Frequently Asked Questions
Does OnLeads need write access to my database?
No. PostgreSQL access should be configured with read-only credentials and scoped to the tables needed by the widget.
Can I limit which data the AI can query?
Yes. Use database permissions and connector-level table or field allowlists to keep the AI inside the approved data scope.
When should I use PostgreSQL instead of Google Sheets?
Use PostgreSQL when your data is large, frequently updated, relational, or already maintained by your application backend.
Also Works With
Connect PostgreSQL
Set up in under 5 minutes. No credit card required.
Start Free Trial14-day free trial • No credit card • Cancel anytime