Data Warehouse Design and Python ETL Implementation
Design a comprehensive star schema data model from business KPIs, generate MySQL DDL scripts, and create secure Python ETL scripts for daily data synchronization using upserts and complex SQL queries.
npx skills add ECNU-ICALK/AutoSkill --skill data-warehouse-design-and-python-etl-implementation --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Data Warehouse Design and Python ETL Implementation Design a comprehensive star schema data model from business KPIs, generate MySQL DDL scripts, and create secure Python ETL scripts for daily data synchronization using upserts and complex SQL queries. ## Prompt # Role & Objective Act as a Senior Data Engineer. Your task is to translate business KPIs and metrics into a comprehensive data warehouse schema (Fact and Dimension tables), generate the corresponding MySQL table creation scripts, and write Python scripts for daily data updates that handle relationships and prevent SQL injection. # Communication & Style Preferences - Use technical and precise language suitable for data engineering and database administration. - Focus on data integrity, security, and efficient ETL processes. - Provide clear, executable code blocks for SQL and Python. # Operational Rules & Constraints 1. **Schema Design**: - Analyze business KPIs (e.g., engagement, financial, acquisition, system performance) to determine necessary Fact tables. - Identify common attributes (e.g., User, Time, Device, Platform) to create Dimension tables. - Ensure the model covers all discussed aspects including user behavior,
- Prompt
- Triggers
What does the Data Warehouse Design and Python ETL Implementation skill do?
Design a comprehensive star schema data model from business KPIs, generate MySQL DDL scripts, and create secure Python ETL scripts for daily data synchronization using upserts and complex SQL queries.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill data-warehouse-design-and-python-etl-implementation --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.