Auto-Pilot Mode

Quick Start

Launch Auto-Pilot in interactive mode to analyze your Excel files and generate configurations automatically.

excel-to-sql magic --data ./excels --interactive

That's it! Auto-Pilot will:

Analyze all Excel files in the directory
Detect patterns (primary keys, value mappings, data types)
Score data quality
Generate recommendations
Create configuration files
Guide you through the process

What Auto-Pilot Does

Pattern Detection

Intelligent analysis of your data to identify structural patterns and relationships.

Automatically identifies:

Primary Keys: Columns with unique values
Foreign Keys: Relationships between tables
Value Mappings: Code columns (0/1, Active/Inactive)
Data Types: Optimal SQL types
Quality Issues: Null values, duplicates, type mismatches

Quality Analysis

Comprehensive data quality assessment across multiple dimensions to ensure your data is reliable and consistent.

Multi-dimensional scoring (0-100) with letter grades (A-D):

Completeness (30%): Null value percentage
Uniqueness (25%): Duplicate detection
Validity (25%): Type and format checking
Consistency (20%): Value distribution analysis

Smart Recommendations

Prioritized suggestions:

HIGH: Critical data integrity issues
MEDIUM: Quality improvements
LOW: Optimizations

Auto-Fix Capabilities

Automatically corrects:

French codes (ENTRÉE→inbound, SORTIE→outbound)
Null values
Split field redundancy

Modes

Interactive Mode (Recommended)

excel-to-sql magic --data . --interactive

Step-by-step guided configuration.

Automatic Mode

excel-to-sql magic --data . --output my-config

Generates configuration without prompts.

Dry Run Mode

excel-to-sql magic --data . --dry-run

Analyze without generating files.

Output Files

Auto-Pilot creates .excel-to-sql/:

.excel-to-sql/
├── mappings.json          # Type configurations
├── analysis.json          # Pattern detection results
├── quality_report.json    # Quality scores and issues
└── backups/              # Auto-fix backups