employee-performance-analytics-hr — Claude Code skill: HR analytics
This skill turns an employee CSV into department KPIs, per-person efficiency scores and charts. Useful when you need to read a workforce export without building pivot tables by hand.
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a claude-codeWhat employee-performance-analytics-hr does
The pipeline runs in four steps: load the CSV into SQLite, run SQL queries for the metrics, analyse with Python, export reports and charts. Three views do the work. department_kpis gives average rating, task totals and absence rate per department. employee_summary aggregates each person's tasks, hours and efficiency. daily_productivity tracks tasks, hours and rating by day and department. Output lands in outputs/ as CSV files plus a charts/ folder.
Your CSV needs the columns employee_id, name, department, role, date, tasks_completed, hours_worked, rating, projects, absences. The loader src/create_db.py asserts on the required ones and stops if any is missing, so an export from another system has to be reshaped first. Then src/analyze_performance.py takes the database, src/queries.sql and an output directory.
Dependencies come from requirements.txt: pandas, matplotlib, seaborn, numpy. SQLite is built into Python, so it needs no separate install. Charts are drawn with seaborn — skip it and the SQL metrics still compute, but the visualisations won't render.
What it helps with
- compute average rating and task totals per department
- spot high-efficiency employees with few absences
- track daily productivity by department
- export CSV reports and charts from one command
- validate the input CSV schema before loading
Example prompts for the agent
- load employees.csv into SQLite and compute department KPIs
- plot average rating by department from hr.db
- build the employee efficiency summary and save it to outputs
How to install employee-performance-analytics-hr
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a claude-code2Manually: put the files in place
~/.claude/skills/employee-performance-analytics-hr/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/employee-performance-analytics-hr/
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a codex2Manually: put the files in place
.agents/skills/employee-performance-analytics-hr/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a cursor2Manually: put the files in place
.cursor/skills/employee-performance-analytics-hr/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install reason-machines/data-skills employee-performance-analytics-hr2Manually: put the files in place
.github/skills/employee-performance-analytics-hr/SKILL.md1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a gemini-cli2Platform CLI
gemini skills install https://github.com/reason-machines/data-skills --path skills/employee-performance-analytics-hrManually: put the files in place
.devin/skills/employee-performance-analytics-hr/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about employee-performance-analytics-hr
How do I install employee-performance-analytics-hr in Claude?
Run npx skills add reason-machines/data-skills --skill employee-performance-analytics-hr -a claude-code. The skill file then sits at ~/.claude/skills/employee-performance-analytics-hr/SKILL.md.
What does employee-performance-analytics-hr do?
It aggregates department and employee KPIs through SQL views in SQLite, then plots them with pandas and seaborn. You get CSV reports and chart images in the outputs directory.
What data does the skill expect?
A CSV with employee_id, name, department, role, date, tasks_completed, hours_worked, rating, projects and absences. The loader checks the required columns and halts if one is absent.
