Execute qualquer Skill no Manus
com um clique

Execute qualquer Skill no Manus com um clique

query-validation

Estrelas3

Forks3

Atualizado14 de junho de 2026 às 05:06

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.

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Executar no Manus

Fonte

ryudkiss-hue

ryudkiss-hue/nyc_data

Abrir repositório GitHub Ver repositórios do creator

Download

Executar no Manus

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Desenvolvedores de softwareInformática e Matemática·SOC 15-1252

Explorador de arquivos

8 arquivos

SKILL.md

readonly

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.

When to use

Promoting a query to a production dashboard or scheduled report
Results look wrong or unexpected — validating logic before escalating
A query is slow and needs performance investigation
Preventing anti-patterns from causing production incidents
Code review for an analyst's or engineer's SQL

Process

Syntax & style check — run scripts/sql_lint.py (uses sqlglot) to catch syntax errors, unsupported functions for the target DB, and style violations
Anti-pattern detection — compare against references/sql_anti_patterns.md; rate each finding by severity (blocking / major / minor)
Execution plan analysis — parse EXPLAIN or query profile output via scripts/explain_plan_parser.py; identify full table scans, missing indexes, and sort spills
Cardinality estimation — run scripts/cardinality_estimator.py when schema statistics exist; flag joins with unexpected row multiplication
Engine-specific validation — cross-reference references/engine_specific_guide.md for Snowflake, BigQuery, Postgres, or Redshift-specific behaviour (date functions, window frame defaults, QUALIFY support)
Produce deliverables — populate assets/query_review_template.md with categorised findings; generate assets/optimization_recommendations.md for performance issues

Inputs the skill needs

Required: SQL text
Required: target database engine (Snowflake / BigQuery / Postgres / Redshift / other)
Should provide: table schemas and approximate row counts
Should provide: EXPLAIN or query profile output if the query has already run
Optional: business logic the query is meant to implement
Optional: performance target (e.g. must run under 30 s on prod)

Output

assets/query_review_template.md (filled) — correctness, performance, style findings categorised by severity
assets/optimization_recommendations.md (filled) — prioritised optimisation suggestions with projected impact

Mais deste repositório

mesmo repositório

data-catalog-entry

ryudkiss-hue/nyc_data

Create standardized metadata for data assets. Use when documenting new datasets, building data catalogs, improving data discoverability, or creating data dictionaries for teams.

2026-06-173

analysis-planning

ryudkiss-hue/nyc_data

Structure analysis approach before starting work. Use when receiving new analysis requests, breaking down complex questions into steps, or planning iterative analysis workflows.

2026-06-173

data-quality-audit

ryudkiss-hue/nyc_data

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.

2026-06-143

segmentation-analysis

ryudkiss-hue/nyc_data

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.

2026-06-143

visualization-builder

ryudkiss-hue/nyc_data

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.

2026-06-143

methodology-explainer

ryudkiss-hue/nyc_data

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.

2026-06-143

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.

When to use

Promoting a query to a production dashboard or scheduled report
Results look wrong or unexpected — validating logic before escalating
A query is slow and needs performance investigation
Preventing anti-patterns from causing production incidents
Code review for an analyst's or engineer's SQL

Process

Syntax & style check — run scripts/sql_lint.py (uses sqlglot) to catch syntax errors, unsupported functions for the target DB, and style violations
Anti-pattern detection — compare against references/sql_anti_patterns.md; rate each finding by severity (blocking / major / minor)
Execution plan analysis — parse EXPLAIN or query profile output via scripts/explain_plan_parser.py; identify full table scans, missing indexes, and sort spills
Cardinality estimation — run scripts/cardinality_estimator.py when schema statistics exist; flag joins with unexpected row multiplication
Engine-specific validation — cross-reference references/engine_specific_guide.md for Snowflake, BigQuery, Postgres, or Redshift-specific behaviour (date functions, window frame defaults, QUALIFY support)
Produce deliverables — populate assets/query_review_template.md with categorised findings; generate assets/optimization_recommendations.md for performance issues

Inputs the skill needs

Required: SQL text
Required: target database engine (Snowflake / BigQuery / Postgres / Redshift / other)
Should provide: table schemas and approximate row counts
Should provide: EXPLAIN or query profile output if the query has already run
Optional: business logic the query is meant to implement
Optional: performance target (e.g. must run under 30 s on prod)

Output

assets/query_review_template.md (filled) — correctness, performance, style findings categorised by severity
assets/optimization_recommendations.md (filled) — prioritised optimisation suggestions with projected impact