CrateDb Data Management Automation

Data Analysts: Those looking to quickly set up a database table in CrateDB for data storage and analysis.
Developers: Individuals needing a manual trigger to execute SQL commands without extensive coding.
Business Users: Users who want to automate data entry processes without deep technical knowledge.
Database Administrators: Professionals who require a simple solution for managing database operations and schema creation.

This workflow addresses the challenge of manually creating database tables and inserting initial data in CrateDB.
It simplifies the process, allowing users to execute SQL commands with a single click, thus saving time and reducing errors in database management.

Step 1: The workflow starts with a manual trigger when the user clicks 'execute'.
Step 2: The CrateDB node is activated to execute a SQL command that creates a new table named test with columns id and name.
Step 3: Following the table creation, a Set node is used to define initial values for the id and name columns, setting id to 0 and name to 'n8n'.
Step 4: Finally, the second CrateDB node inserts these values into the previously created test table, completing the workflow.