菜单
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；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/ECNU-ICALK/AutoSkill --skill ride-share-extended-schema-and-kpi-design命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
Manage personal local Agent Skill files as an installable skill manager. Proactively and periodically detect reusable user-specific, team-specific, or broadly reusable skill material during or after meaningful sessions; run non-blocking extraction checks; offer candidate skill titles or accept a user-supplied topic when extraction direction is ambiguous; preserve the appropriate output language; search local and external skill ecosystems for similar skills; score candidates by evidence, recurrence, personal value, and portability; fully draft proposed skills or diffs before asking for approval; then, after explicit user approval, discard, improve, merge, or create `SKILL.md` folders.
布置结构化家庭作业，引导求助者记录现实互动事件、自动思维及情绪反应，并设计简易验证行动（如主动询问、观察反证），用于检验投射性认知偏差。适用于已识别出具体非理性信念（如‘别人肯定不喜欢我’）且情绪稳定者。
结构化8次CBT咨询流程，按评估性会谈→咨询性会谈→巩固性会谈三阶段推进，整合悬搁接地技术与认知行为策略，专用于强迫症伴轻度抑郁状态、具自省力与作业执行力的成年来访者。
正在显示 SKILL.md
基于 SOC 职业分类
| id | d3fa5705-bd5b-4e60-9b05-341b327286ae |
| name | ride_share_extended_schema_and_kpi_design |
| description | 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. |
| version | 0.1.1 |
| tags | ["data-warehouse","star-schema","mysql","kpi-calculation","ride-share","database-design"] |
| triggers | ["create star schema for ride share company","design ride share database with specific rating architecture","generate mysql script for ride share data warehouse","expand star schema design for complex business model","calculate kpi formulas for rideshare data"] |
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.
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.
_Dim for dimensions, _Fact for fact tables).Schema Scope: The schema must support analysis of financial performance, customer/driver experience, operational efficiency, and customer retention.
Dimension Tables: The design must include, but is not limited to:
Driver_DimPassenger_Dim (merges Customer concept)Vehicle_DimTime_DimLocation_DimPaymentType_DimServiceTier_DimPromotion_DimMaintenanceType_DimLocationType_DimRatingStandards_DimFact Tables: The design must include:
Rides_FactDriverShifts_FactVehicleMaintenance_FactCustomerActivity_FactLocation Architecture:
Location_Dim must link to LocationType_Dim to categorize locations (e.g., Airport, Residential, Commercial, Landmark).Rating Architecture (Strict Constraint):
SubjectID design.RatingStandards_Dim table containing RatingStandardID, Description, and MaxScore.Driver_Dim must include RatingScore and RatingStandardID (FK).Passenger_Dim must include RatingScore and RatingStandardID (FK).Rides_Fact must include CustomerRatingScore and DriverRatingScore.Financial Granularity: The table must include a detailed breakdown of trip costs:
SubjectID columns that reference multiple tables.Location_Dim and LocationType_Dim.CREATE TABLE scripts ensuring all constraints (Rating architecture, Location linkage, Financial columns, Partitioning) are met.INSERT scripts for test data.Rides_FactBaseFareDistanceTraveledTimeDurationDynamicPricingFactorMiscFeesPromotionsTotalFareDriverEarningsCustomer Retention:
Passenger_Dim must include FirstRideDateID and LastRideDateID.CustomerActivity_Fact must track IsReturningCustomer.Partitioning: The Rides_Fact table must include partitioning logic (e.g., by year or range) in the creation script to handle large datasets.
SQL Generation Requirements:
CREATE TABLE scripts for all tables with appropriate Primary Keys (PK) and Foreign Keys (FK).INSERT scripts to generate test data for all related Foreign Keys to ensure referential integrity.Metric Formulas: Define formulas for key metrics, explicitly stating the calculation logic and identifying the specific tables and columns involved: