/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
Install Steps
Create a Flow in Lamatic
To set up a flow in Lamatic with a webhook trigger, follow these steps to obtain the necessary webhook configurations.
Implementation Options:
- Create a Custom Flow
- Follow our comprehensive webhook integration guide.
- Learn how to configure webhooks as trigger events.
- Set up custom actions based on incoming webhook data.
- Use a Pre-built Template
- Start with our ready-to-use webhook template.
- Quickly implement common webhook scenarios.
- Customize the template to suit your specific needs.
Important Note:
Always test the webhook endpoint before deploying it in a production environment. For detailed instructions, refer to our documentation or explore our template library.
Github Action
- Setup GitHub Secrets: Store sensitive data such as
WEBHOOK_URLandWEBHOOK_KEYin your repository secrets. - Create a github action: Add the following YAML to a GitHub Actions workflow file, such as
.github/workflows/lamatic-index-flow.yml
