DATA_SOURCE: duckdb - Ecommerce platform — customers, orders, products, inventory, and marketing. DuckDB backend. Run `python seed.py` to initialise.
CONTEXT: customers - Customer profiles, account status, and lifetime value. Use this context to answer questions about customer acquisition, demographics, activity, and segmentation. (v1.0)
DATASET: main - Primary ecommerce schema
TABLES:
main.customers|Registered customer accounts. Each row is one customer. Columns: id (PK), name, email (unique), phone, city, country, signup_date, active (boolean), lifetime_value (running total of orders).|id:I[PK]|name:S|email:S|phone:S|city:S|country:S|signup_date:D|active:B|lifetime_value:N
