query-validation
SQL query review and validation for correctness, performance, and best practices. Use when reviewing queries for logical errors, optimizing query performance, checking for SQL anti-patterns, or validating business logic implementation in SQL.
Install
npx skillscat add nimrodfisher/data-analytics-skills/query-validation Install via the SkillsCat registry.
SKILL.md
Query Validation
Quick Start
Review SQL queries for correctness, performance, and adherence to best practices.
Context Requirements
- SQL Query: The query to validate
- Database Type: PostgreSQL, MySQL, Snowflake, BigQuery, Redshift, etc.
- Schema Information: Relevant table structures
- Business Logic (optional): What the query should calculate
- Performance Context (optional): Expected row counts, current runtime
Context Gathering
For query input:
"Please provide:
- The SQL query to validate
- What database system you're using (PostgreSQL, Snowflake, etc.)
- Relevant table schemas (or I can help you extract them)"
For schema:
"To validate joins and column references, I need table schemas. You can provide:
Option 1 - Quick:
Just the tables/columns used in the query
Option 2 - Comprehensive:
Categories
Install
npx skillscat add nimrodfisher/data-analytics-skills/query-validation Install via the SkillsCat registry.