메뉴
Review SQL queries for correctness, performance, and best practices before they reach production. Activate when promoting queries to dashboards, investigating unexpected results, or when a query is slow and needs optimisation.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Create standardized metadata for data assets. Use when documenting new datasets, building data catalogs, improving data discoverability, or creating data dictionaries for teams.
Structure analysis approach before starting work. Use when receiving new analysis requests, breaking down complex questions into steps, or planning iterative analysis workflows.
Comprehensive data quality assessment against business rules, schema constraints, and freshness expectations. Activate when validating production pipelines, onboarding new data sources, or when stakeholders report data quality concerns.
Identify distinct customer or user segments based on behavior, attributes, or value. Activate when you need to answer "who are our best customers?" or "what distinct groups exist in our user base?" and need data-driven profiles to inform strategy.
Create effective, publication-ready data visualizations. Use when choosing chart types, designing presentation visuals, building dashboard charts, or applying visual design best practices to data output.
Create a clear, transparent explanation of analytical methodology for any audience level. Activate when you deliver findings that require the audience to trust the method — A/B tests, attribution models, forecasts, statistical analyses, or anything where "how did you get that?" is a likely question.
| name | query-validation |
| description | Review SQL queries for correctness, performance, and best practices before they reach production. Activate when promoting queries to dashboards, investigating unexpected results, or when a query is slow and needs optimisation. |
scripts/sql_lint.py (uses sqlglot) to catch syntax errors, unsupported functions for the target DB, and style violationsreferences/sql_anti_patterns.md; rate each finding by severity (blocking / major / minor)scripts/explain_plan_parser.py; identify full table scans, missing indexes, and sort spillsscripts/cardinality_estimator.py when schema statistics exist; flag joins with unexpected row multiplicationreferences/engine_specific_guide.md for Snowflake, BigQuery, Postgres, or Redshift-specific behaviour (date functions, window frame defaults, QUALIFY support)assets/query_review_template.md with categorised findings; generate assets/optimization_recommendations.md for performance issuesassets/query_review_template.md (filled) — correctness, performance, style findings categorised by severityassets/optimization_recommendations.md (filled) — prioritised optimisation suggestions with projected impact