Simple workflow to manually trigger and run SQL queries on Postgres databases for quick data retrieval and analysis.
This workflow demonstrates the basic use of n8n's Postgres node by manually triggering an execution and running a custom SQL query, such as 'SELECT * FROM sometable;'. It serves as a companion example for Postgres node documentation, allowing users to test database connectivity and query execution effortlessly.
Benefits include rapid prototyping of database interactions without complex setups, time savings on repetitive queries, and seamless integration into larger automations. It's lightweight
Platform
n8n
Category
HR Management
Price
$4.99
Creator
Fred Garcia
postgres
sql
database
query
manual trigger
data extraction
automation
n8n
HRMS
HCM
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.