Test PostgreSQL connection
Connect to PostgreSQL and return the current database, user, schema, server time, and version.
Connector library
PostgreSQL connector.
Connect directly to PostgreSQL for tenant rows and website knowledge chunks with keyword or pgvector search.
Connector download
Download PostgreSQL
Versioned ZIP for your CXFabric tenant.
Use this connector in a flow
- Register the ZIP in your tenant, or add a new version if the connector is already installed.
- Create or select a credential if the action requires one.
- In a Draft flow, add an available action, choose its version, connect it, and map inputs.
- Test the step and flow; review output and failures before activation.
See readme.md in the ZIP for settings and limitations.
- Version
- 0.3.0.1
- Release
- 2026-10-25
- Package
- Implemented source
- Schema credentials
- Basic auth
- Connection settings
- Database, Fallback Password, Fallback Username, Host, Port, PostgreSQL Connection URL, SSL Mode
- Package size
- 14 KB
- SHA-256
d4811fd296150de6ad53ca9b420f7b7b728ac682082d46ea7ec118526c2ee927- Notes
- Read release notes
Included in this version
Included actions
Implemented in v0.3.0.1. Use a separate flow trigger; no webhook trigger is included.
Create tenant row
Insert a tenant row with parameterized values and optionally ignore or update an existing tenant ID conflict.
Get tenant row
Retrieve one tenant row by its tenant ID.
Update tenant row
Update selected columns on one tenant row using parameterized values.
Delete tenant row
Delete one tenant row by its tenant ID and return the deleted row.
Upsert knowledge chunks
Upsert prepared chunks from one or more scraped pages in one database statement.
Replace page knowledge chunks
Transactionally upsert prepared chunks for one page and remove stale chunks for that page.
Search knowledge chunks
Search one tenant collection by PostgreSQL full-text search or exact pgvector cosine similarity.
Vendor API
API and access
Implementation considerations
- Confirm network access, credentials, least-privilege roles, schema ownership, query limits, and transaction behavior.
- Use parameterized queries and explicit allowlists for database operations.
- Do not expose raw database credentials inside workflow code, prompts, or logs.
Related connectors
More in Data, Storage & Cloud APIs
Support
Need help with PostgreSQL?
Tell us what you need to connect or change.