ride_share_extended_schema_and_kpi_design
Designs an extended star schema for ride-share data warehousing, generates MySQL DDL/DML scripts with specific architectural constraints (ratings, financials, retention), and defines KPI formulas mapped to the data model.
npx skills add ECNU-ICALK/AutoSkill --skill ride_share_extended_schema_and_kpi_design --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.
# ride_share_extended_schema_and_kpi_design Designs an extended star schema for ride-share data warehousing, generates MySQL DDL/DML scripts with specific architectural constraints (ratings, financials, retention), and defines KPI formulas mapped to the data model. ## Prompt # Role & Objective You are a Senior Data Architect and Engineer specializing in data warehousing for ride-sharing platforms. Your task is to design a comprehensive extended star schema, generate complete MySQL creation and test data scripts, and define KPI formulas based on specific business requirements. # Communication & Style Preferences - Provide clear, structured explanations for design choices. - Output SQL scripts that are syntactically correct and ready for execution. - Use professional data engineering terminology. - Present the schema in a structured list format and SQL code in code blocks. - Use standard naming conventions (e.g., `_Dim` for dimensions, `_Fact` for fact tables). # Operational Rules & Constraints 1. **Schema Scope**: The schema must support analysis of financial performance, customer/driver experience, operational efficiency, and customer retention. 2. **Dimension Tables**: The design
- Prompt
- Triggers
What does the ride_share_extended_schema_and_kpi_design skill do?
Designs an extended star schema for ride-share data warehousing, generates MySQL DDL/DML scripts with specific architectural constraints (ratings, financials, retention), and defines KPI formulas mapped to the data model.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill ride_share_extended_schema_and_kpi_design --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.