कंटेंट पर जाएँ
TakoAPI
स्किल्स पर वापस

employee-skills-importer

inna-demidova द्वारा

Coding Agents & IDEs
434clawskills.sh द्वारा बताए गए डाउनलोड
0व्यूज़
0 लाइकइस स्किल को लाइक करने के लिए साइन इन करें
—अभी तक कोई रेटिंग नहीं
आपकी रेटिंग

संक्षिप्त

Parse employee skills CSV files, identify skill categories and individual skills, look up employee IDs.

विवरण

यह स्किल क्या करती है

Parses employee skills CSV files and generates three idempotent SQL scripts to populate skill_categories, skills, and employee_skills tables in a Supabase database. Handles name fuzzy matching, deduplication, and whitespace normalization automatically.

Generating idempotent scripts with fuzzy name correction and deduplication eliminates the manual work of reconciling CSV names against database records and prevents common constraint violations.

इसे कब इस्तेमाल करें

  • Importing bulk employee skill data from an HR spreadsheet export
  • Updating years_of_experience records without overwriting unrelated rows
  • Syncing a new CSV after onboarding without re-running the full migration
  • Catching name spelling mismatches between CSV exports and the database
  • Generating auditable SQL scripts for DBA review before execution

उदाहरण वर्कफ़्लो

इनपुट

User uploads employee_skills.csv and says: Parse this file and generate SQL insert scripts

एजेंट
  1. 1

    Parse row 2 for skill category names and subsequent rows for individual skill names, mapping each to its column position

  2. 2

    Query Supabase skill_categories, skills, and employees tables to determine what already exists

  3. 3

    Generate 1_insert_categories.sql with ON CONFLICT DO NOTHING for missing categories

  4. 4

    Generate 2_insert_skills.sql with subquery-based category_id lookups for missing skills

  5. 5

    Fuzzy-match CSV employee names against the database, deduplicate employee-skill pairs keeping the highest experience value, generate 3_insert_employee_skills.sql and skipped_employees_report.txt

आउटपुट

Three SQL files ready to execute in order (1 → 2 → 3) plus a report listing auto-corrected names and skipped employees

आवश्यकताएँ

  • Supabase project access with read/write permissions to skill_categories, skills, employees, and employee_skills tables

इंस्टॉलेशन

clawhub install inna-demidova/employee-skills-importer

CLI कमांड चलाएँ, या प्रॉम्प्ट को Claude Code, Cursor, Codex या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।

लिंक