SQL Pro
davila7/claude-code-templates
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques.
SQL query review for correctness, performance, and best practices.
Install Query Validation
$ npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install nimrodfisher/data-analytics-skills query-validation --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/01-data-quality-validation/query-validation .claude/skills/query-validation && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "query-validation" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/query-validation into .claude/skills/query-validation/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-validation", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/query-validationType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install nimrodfisher/data-analytics-skills query-validation --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .agents/skills && cp -r skills-src/01-data-quality-validation/query-validation .agents/skills/query-validation && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "query-validation" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/query-validation into .agents/skills/query-validation/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-validation", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install nimrodfisher/data-analytics-skills query-validation --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/01-data-quality-validation/query-validation .cursor/skills/query-validation && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "query-validation" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/query-validation into .cursor/skills/query-validation/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-validation", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/nimrodfisher/data-analytics-skills.git --path 01-data-quality-validation/query-validation--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install nimrodfisher/data-analytics-skills query-validation --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/01-data-quality-validation/query-validation .gemini/skills/query-validation && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "query-validation" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/query-validation into .gemini/skills/query-validation/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-validation", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install nimrodfisher/data-analytics-skills query-validationInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .github/skills && cp -r skills-src/01-data-quality-validation/query-validation .github/skills/query-validation && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "query-validation" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/query-validation into .github/skills/query-validation/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-validation", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install nimrodfisher/data-analytics-skills query-validation --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/01-data-quality-validation/query-validation .opencode/skills/query-validation && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "query-validation" agent skill from https://github.com/nimrodfisher/data-analytics-skills/tree/main/01-data-quality-validation/query-validation into .opencode/skills/query-validation/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-validation", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
query-validation- GitHub stars
- 465
- Token cost
- ~551 tokens
- SKILL.md length
- 236 words
- Files
- 8 (incl. scripts, references, assets)
- Skills in repo
- 31
- Repo updated
- First seen
- Licence
- MIT
At a glance
SQL query review for correctness, performance, and best practices.
- Works in 6 steps: Lint the query — run scripts/sql_lint.py… → Review anti-patterns — compare the query… → Parse the explain plan — if an EXPLAIN… → …
- Tasks that involve SQL
- Runs Python scripts from its folder
- Tasks that involve Data warehousing
What it does
Query Validation is an agent skill from nimrodfisher/data-analytics-skills. SQL query review for correctness, performance, and best practices. Activate when a query needs review before production use, shows unexpected results, or runs too slowly.
Its SKILL.md is about 550 tokens, which your agent loads only when the skill is triggered. The skill folder holds 10 other files, including scripts, reference files and assets (for example `assets/optimization_recommendations.md`, `assets/query_review_template.md` and `references/engine_specific_guide.md`).
It sits in Databases, covering SQL, Data warehousing and Data cleaning. It works with SQL. The repository describes itself as: A comprehensive list of Claude & Codex skills for a wide range of data analytics tasks. The licence is MIT.
When your agent uses it
- Tasks that involve SQL
- Tasks that involve Data warehousing
- Tasks that involve Data cleaning
Example prompts
- “/query-validation”
Requirements
- Python 3
Workflow steps
6 steps, taken from the first numbered list in SKILL.md.
- Lint the query — run scripts/sql_lint.py (sqlglot-based) to catch syntax errors, unsupported functions for the target engine, and style…
- Review anti-patterns — compare the query structure against references/sql_anti_patterns.md. Flag any present anti-patterns with a severity…
- Parse the explain plan — if an EXPLAIN or query profile output is available, run scripts/explain_plan_parser.py to extract slow steps…
- Estimate cardinality — run scripts/cardinality_estimator.py if schema stats are available to flag joins that might fan-out unexpectedly.
- Check engine-specific behaviour — consult references/engine_specific_guide.md for the target engine (Snowflake / BigQuery / Postgres /…
- Produce review output — fill in assets/query_review_template.md with findings; for any performance issues found, complete…
What it can do on your machine
Read from SKILL.md and the folder at commit 9449d36. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Ships 3 files in scripts/ (Python), which the agent can run.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Query Validation loads about 551 tokens when it runs, and up to ~2.8k if it reads all its reference files. Until then it costs about 47 tokens; SKILL.md has 236 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.
SKILL.md
The full file from nimrodfisher/data-analytics-skills at commit 9449d36, republished under its MIT licence (© nimrodfisher). 236 words, ~551 tokens.
Download SKILL.mdSave it as
.claude/skills/query-validation/SKILL.md (or your agent's skills folder). This skill also uses 7 other files; get the full folder from GitHub.- name
- query-validation
- description
- SQL query review for correctness, performance, and best practices. Activate when a query needs review before production use, shows unexpected results, or runs too slowly.
When to use
- A SQL query is about to be promoted to a production dashboard or report
- A query is returning surprising or incorrect results
- A query is running slowly and needs performance review
- You want to catch anti-patterns (implicit conversions, SELECT *, unbounded CTEs) before they cause incidents
Process
- Lint the query — run
scripts/sql_lint.py(sqlglot-based) to catch syntax errors, unsupported functions for the target engine, and style violations. Fix hard errors before continuing. - Review anti-patterns — compare the query structure against
references/sql_anti_patterns.md. Flag any present anti-patterns with a severity rating. - Parse the explain plan — if an EXPLAIN or query profile output is available, run
scripts/explain_plan_parser.pyto extract slow steps (full table scans, missing indexes, high row estimates). - Estimate cardinality — run
scripts/cardinality_estimator.pyif schema stats are available to flag joins that might fan-out unexpectedly. - Check engine-specific behaviour — consult
references/engine_specific_guide.mdfor the target engine (Snowflake / BigQuery / Postgres / Redshift) to verify date functions, window behaviour, and clustering assumptions. - Produce review output — fill in
assets/query_review_template.mdwith findings; for any performance issues found, completeassets/optimization_recommendations.md.
Inputs the skill needs
- Required: the SQL query text
- Required: target database engine (Snowflake / BigQuery / Postgres / Redshift / other)
- Optional: relevant table schemas (column names, types, approximate row counts)
- Optional: EXPLAIN / query profile output
- Optional: expected business logic — what should the query calculate?
Output
assets/query_review_template.md(filled) — categorised findings: correctness, performance, styleassets/optimization_recommendations.md(filled, if issues found) — ranked rewrite suggestions with expected impact
© nimrodfisher, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
SKILL.md and 7 other files (scripts, references, assets) in 01-data-quality-validation/query-validation of nimrodfisher/data-analytics-skills.
- SKILL.md
- assets/optimization_recommendations.md
- assets/query_review_template.md
- references/engine_specific_guide.md
- references/sql_anti_patterns.md
- scripts/cardinality_estimator.py
- scripts/explain_plan_parser.py
- scripts/sql_lint.py
Open the folder on GitHubat commit 9449d36
Compare with similar skills
Query Validation next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Query Validation this skillnimrodfisher/data-analytics-skills | 465 | — | ~551 | Automated safety check: Pass | MIT | |
| SQL Prodavila7/claude-code-templates | 32k | 9 repos | ~1.9k | Automated safety check: Pass | MIT | |
| Analyzing Dataastronomer/agents | 451 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | |
| Databricks Dbsqldatabricks/databricks-agent-skills | 345 | 1 repos | ~2.8k | Automated safety check: Pass | Custom licence | |
| Pytorch Clickhousepytorch/test-infra | 113 | — | ~2.8k | Automated safety check: Pass | Custom licence | |
| Snowflake Developmentsickn33/agentic-awesome-skills | 47k | 2 repos | ~2.1k | Automated safety check: Pass | MIT |
Similar skills
Analyzing Data
astronomer/agents
Queries the data warehouse with SQL and answers business questions about data.
- Official
Databricks Dbsql
databricks/databricks-agent-skills
Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities.
Pytorch Clickhouse
pytorch/test-infra
Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database.
Snowflake Development
sickn33/agentic-awesome-skills
Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt…
Snowflake Development
alirezarezvani/claude-skills
A skill your agent uses when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python…
More from nimrodfisher/data-analytics-skills
All 31 skills in this repoAb Test Analysis
nimrodfisher/data-analytics-skills
Rigorous A/B test statistical analysis. An agent skill from nimrodfisher/data-analytics-skills.
Analysis Assumptions Log
nimrodfisher/data-analytics-skills
Track and document analytical assumptions and decisions. An agent skill from nimrodfisher/data-analytics-skills.
Analysis QA Checklist
nimrodfisher/data-analytics-skills
Pre-delivery quality assurance for analysis work. An agent skill from nimrodfisher/data-analytics-skills.
Business Metrics Calculator
nimrodfisher/data-analytics-skills
Standard business metric calculation with industry benchmarks.
Cohort Analysis
nimrodfisher/data-analytics-skills
Time-based cohort analysis with retention and behaviour tracking.
Context Packager
nimrodfisher/data-analytics-skills
Efficiently package context for AI-assisted analysis. An agent skill from nimrodfisher/data-analytics-skills.
Related
Works with
Categories
Questions about Query Validation
What does Query Validation do?
SQL query review for correctness, performance, and best practices. Query Validation is an agent skill from nimrodfisher/data-analytics-skills. SQL query review for correctness, performance, and best practices.
When should I use Query Validation?
Query Validation fits situations like: tasks that involve SQL; tasks that involve Data warehousing; tasks that involve Data cleaning.
How do I install Query Validation in Claude Code?
Run `npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a claude-code`. Or copy the skill folder (01-data-quality-validation/query-validation in nimrodfisher/data-analytics-skills) into .claude/skills/query-validation in your project. Claude Code loads it when a task matches its description.
How do I install Query Validation in Codex?
Run `npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a codex`. Or copy the skill folder (01-data-quality-validation/query-validation in nimrodfisher/data-analytics-skills) into .agents/skills/query-validation in your project. Codex loads it when a task matches its description.
Can I use Query Validation in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add nimrodfisher/data-analytics-skills --skill query-validation -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/query-validation, .gemini/skills/query-validation, .github/skills/query-validation and .opencode/skills/query-validation in your project.
What does Query Validation need to run?
Going by SKILL.md and its folder, Query Validation needs Python for the scripts in its folder. Our summary lists: Python 3.
Does Query Validation access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Query Validation safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
What licence does Query Validation use?
Query Validation is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Query Validation use?
About 551 tokens (SKILL.md is roughly 2.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 2.3k tokens, read only when the agent opens those files.
What are the alternatives to Query Validation?
Skills that share tags, products or a category with Query Validation: SQL Pro (davila7/claude-code-templates, 32k stars), Analyzing Data (astronomer/agents, 451 stars), Databricks Dbsql (databricks/databricks-agent-skills, 345 stars) and Pytorch Clickhouse (pytorch/test-infra, 113 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Query Validation?
nimrodfisher (a GitHub user) maintains it in nimrodfisher/data-analytics-skills, which has 465 GitHub stars. The repository holds 31 skills in this directory. The repository was last updated on September 25, 2026.
Source: nimrodfisher/data-analytics-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.