Postgres: Create Table and Insert Sample Data

This n8n workflow serves as a practical example for using the Postgres node to perform database operations. It starts with a manual trigger, executes a SQL query to create a simple table named 'test' with columns 'id' (INT, primary key) and 'name' (VARCHAR(255)), prepares sample data using a Set node (id and name='n8n'), and finally inserts the data into the table.

The benefits include rapid prototyping of database schemas, easy testing of Postgres connections, and seamless integration into larger workflows for data management. It's particularly useful for developers setting up initial database structures without manual SQL execution tools.

Use cases span IT and development scenarios such as initializing user tables for apps, seeding demo data for testing, or automating DB setup in CI/CD pipelines. With n8n's credentials management, it securely handles Docker-hosted Postgres instances, making it extensible for production environments.