Client demo · AI Voice Data Engineering
AetherPipe
Speak a command. Files load into PostgreSQL, bad data is rejected, history is tracked with SCD, and anyone can ask questions in plain English. Rules engine is active — add GROQ_API_KEY to backend/.env (free at console.groq.com).
Live PostgreSQL
—
customers loaded
Connecting…
Rejected: 0
Before → After
0 → 0
Customers in warehouse
Last change
+0
Delta customers
Rejected
0 → 0
+0 last action
Last action
—
No actions yet
Auto inbox watcher
Drop a CSV/Excel into inbox/ — it loads automatically. Status: OFF
No auto-loads yet. Drop a file into inbox/ to try.
1. Load
Bring 10 clean customers into PostgreSQL
Source data lands in the warehouse
2. Quality
Valid / invalid / missing checked automatically
Bad data is blocked before it hurts reporting
3. Append
New batches keep adding every day
Pipeline grows without reloading everything
4. SCD
Track customer changes (Type 1 / 2 / 3)
History stays trustworthy for analytics
5. Ask
Voice or plain English → SQL answers
Business users get answers without writing SQL
LoadDrop files in a folder
→
QualitySecurity check at the gate
→
AppendNew pages in the book
→
SCDKeep the change history
→
AskTalk to your data
Manual controls
Use these if you want to drive the demo step-by-step.
Try: "Load 10 customers" · "Load increment" · "How many customers?"
SCD — how customer changes are stored
Type 1
Overwrite — no history
Like editing a cell in Excel
Type 2
Full history rows
Best for analytics / audits
Type 3
Previous + current columns
Limited history, simple
Ask the warehouse
Client-friendly: no SQL needed. Uses rule-based NL→SQL with a SELECT-only allowlist.
AI visualizations
Auto insights from PostgreSQL — updated after every load / demo step.
Load data to see AI insights.
Customers by city
No data yet
Customers by segment
No data yet
Trusted customers
0
Rejected rows
0
Cities
0
Segments
0
Architecture (how it works)
Simple client view of the pipeline — from voice/files to PostgreSQL, quality, SCD, and AI insights.
InputsVoice / UICSV · Excelinbox/ watcher
→
AetherPipe APIIntent AIValidateClean · Load
→
Quality gateValid → loadInvalid / missing→ rejected table
→
PostgreSQLcustomerscustomers_rejectedSCD dim tables
→
OutputsAsk AI (SQL)Charts · insightsDemo report
SCD Type 1 overwrite current value
SCD Type 2 keep full history rows
SCD Type 3 keep previous + current columns
PostgreSQL location
Not connected