What problem does it solve? Bulk-loading CSV data into a PostgreSQL or Supabase database is error-prone: encoding issues, type mismatches, duplicate keys, and NULL violations can corrupt production tables. This Skill provides a safe, staged import workflow that validates data before it ever touches the target table. ## Core Features & Use Cases - Staging Table Import: Loads CSV data into a temporary staging table with PostgreSQL COPY, keeping the target table untouched until validation passes. - Pre-Merge Validation: Runs checks for NULL values, duplicate keys, and type-conversion failures before merging. - Idempotent UPSERT Merge: Merges staged rows with ON CONFLICT DO UPDATE so re-running the import never creates duplicates. - Use Case: You receive a 500MB customer export CSV and need it in your Supabase database. The Skill validates the file, loads it to staging, checks for bad rows, and merges it idempotently — with guidance for splitting large files into batches. ## Quick Start Ask the agent to import your CSV file into a specific PostgreSQL table, for example: load the file customers.csv into the customers table using the staged COPY workflow.
