Create CrateDB Table and Insert Sample Data - n8n Workflow | Neura Market
Create CrateDB Table and Insert Sample Data
Demonstrates creating a table in CrateDB with SQL and inserting a sample row using n8n's CrateDB nodes. Ideal for quick database setup automation.
This workflow serves as a companion example for CrateDB node documentation in n8n. It starts with a manual trigger, executes a SQL query to create a simple table named 'test' with columns 'id' (INT) and 'name' (STRING), sets sample data (id: 0, name: 'n8n'), and inserts it into the table.
Benefits include rapid prototyping of database schemas and data insertion without manual SQL clients, ensuring consistency in automated environments. It's lightweight, always outputs data from key nodes, and u
Platform
n8n
Category
Business Operations & ERPs
Price
$6.99
Creator
Matt Buds
CrateDB
Database
SQL
Table Creation
Data Insertion
Automation
n8n
Development
ETL
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.