ORG Chart

SKILL.md

# Org Chart Generator - Skill Documentation

## Overview

Upload CSV/Excel files, AI automatically parses organizational hierarchy, one-click generate organization charts.

## Trigger Words

- org chart
- organization chart
- generate chart
- upload employee data
- CSV to org chart

## Features

### P0 Features (V1 Required)

1. **CSV/Excel Upload & Parsing**
   - Supports .csv, .xlsx, .xls formats
   - Auto-recognizes name, title, manager columns
   - Supports various column name variants (name/employee, title/position, manager/supervisor)

2. **Auto Layout Algorithm**
   - Tree-based layout
   - Auto-center parent nodes
   - Handles multi-level structures

3. **PNG Export**
   - 150 DPI high-definition output
   - Adaptive canvas size
   - Rounded corner node design

4. **Data Preview Table**
   - Pre-parsing preview
   - Supports manual correction
   - Export corrected data

## Input Requirements

File format: CSV or Excel (.xlsx/.xls)

Required columns:
- name (employee name)
- title (job title)
- manager (supervisor name, references another employee's name)

Manager column contains the name of the superior. Leave blank for top-level employees.

## Output

PNG format organization chart, PNG file path.

## Pricing

- Standard: $0.01 USDT per generation
- Pro: $0.05 USDT per generation with unlimited exports

## Tech Stack

- Python
- pandas (data parsing)
- openpyxl (Excel reading)
- Matplotlib (chart rendering)

## Security

- All paths use /tmp/org-chart/
- No home directory access
- File path validation prevents injection