/w=3840,quality=90,fit=scale-down){kind=logo}
postgresNode
Jump to:
About
This node automates data synchronization from a PostgreSQL database by fetching rows from a specified PostgreSQL table at scheduled intervals. It supports row vectorization and RAG (Retrieval-Augmented Generation) by vectorizing and indexing contextual data found within each row.
What can I build?
- Automate the regular fetching and synchronization of rows from specified PostgreSQL database table.
- Support the vectorization and indexing of PostgreSQL rows to provide context for RAG flows.
Available Functionality
Batch Trigger
✅ Fetch a PostgreSQL table on a scheduled interval. This is the first step in flows that vectorize and store contextual data found in each row of a PostgreSQL table to support subsequent RAG requests. Note: only Tables and Materialized Views are compatible with this trigger function.
Event Trigger
❌ When a PostgreSQL record is inserted / updated / deleted
❌ When a PostgreSQL table is created / updated / deleted
Actions
❌ Add / update / delete a row in a linked PostgreSQL table
❌ Create / update / delete a linked PostgreSQL table
How to Setup
Doc: https://lamatic.ai/docs/integrations/github
How to Setup
Doc: https://lamatic.ai/docs/integrations/github
