QuestDB: Create Table and Insert Sample Data

This n8n workflow demonstrates basic database operations in QuestDB. It starts with a manual trigger, executes a SQL query to create a table named 'test' with columns 'id' (INT) and 'name' (STRING). Next, it uses a Set node to prepare sample data (name: 'Tanay', id as number), and finally inserts this data into the table using another QuestDB node.

Benefits include rapid prototyping of database schemas, automated initial data population, and error-free setup for development environments. It saves time by handling CREATE TABLE and INSERT in one execution, reducing manual SQL scripting errors.

Use cases: Testing QuestDB connections in n8n, initializing tables for time-series data apps, demo workflows for IT teams, or as a template for production data ingestion pipelines. Extend it by adding dynamic data sources or loops for bulk inserts.