Generate production database schemas from Excel and CSV with OpenAI and LangChain

Overview

This workflow automatically converts CSV or Excel files into a production-ready database schema using AI and rule-based validation.

It analyzes uploaded data, detects column types, relationships, and data quality, then generates a normalized schema. The output includes SQL DDL scripts, ERD diagrams, a data dictionary, and a load plan.

This eliminates manual schema design and accelerates database setup from raw data.

---

How It Works

1. File Upload (Webhook) - Accepts CSV or XLSX files via webhook endpoint - Initializes workflow configuration (thresholds, retry limits)

2. File Extraction - Detects file format (CSV or Excel) - Extracts rows into structured JSON - Merges extracted datasets