Employee Skills Importer

This skill automates the process of importing employee skills from CSV files into a Supabase database. It parses the CSV, checks what already exists in the database, and generates idempotent SQL scripts to insert missing data.

Overview

The skill performs a 3-step process:

1. Identify and insert missing skill categories - Extract categories from CSV headers, check database, generate INSERT script
2. Identify and insert missing skills - Extract skills with their categories, check database, generate INSERT script
3. Generate employee_skills INSERT script - Map employees by name, link skills, create final INSERT statements

CSV Format Requirements

The CSV must have:

• Row 1: Empty or metadata (ignored)
• Row 2: Skill category names spanning multiple columns
• Row 3+: Individual skill names (column headers, may span multiple rows due to line breaks)
• Employee data rows: Employee data with First Name, Last Name in first two columns, followed by skill experience values