Agent skill

SQL To Business Logic

by nimrodfisher in nimrodfisher/data-analytics-skills

Translate SQL queries into plain language business logic. An agent skill from nimrodfisher/data-analytics-skills.

MITAuto-check passedDatabases

Install SQL To Business Logic

skills CLI
$ npx skills add nimrodfisher/data-analytics-skills --skill sql-to-business-logic -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install nimrodfisher/data-analytics-skills sql-to-business-logic --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/nimrodfisher/data-analytics-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/02-documentation-knowledge/sql-to-business-logic .claude/skills/sql-to-business-logic && rm -rf skills-src

Use ~/.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/

Facts

Skill name
sql-to-business-logic
GitHub stars
470
Token cost
~636 tokens
SKILL.md length
317 words
Files
4 (incl. scripts, references, assets)
Skills in repo
31
Repo updated
First seen
Licence
MIT

At a glance

Translate SQL queries into plain language business logic. An agent skill from nimrodfisher/data-analytics-skills.

  • Works in 6 steps: Receive the query and context — obtain… → Translate the FROM/JOIN structure —… → Translate WHERE filters — list each… → …
  • Documenting queries
  • Runs Python scripts from its folder
  • Explaining analysis to non-technical stakeholders

What it does

SQL To Business Logic is an agent skill from nimrodfisher/data-analytics-skills. Translate SQL queries into plain language business logic. Use when documenting queries, explaining analysis to non-technical stakeholders, code reviewing for correctness, or building a query catalog.

Its SKILL.md is about 640 tokens, which your agent loads only when the skill is triggered. The skill folder holds 6 other files, including scripts, reference files and assets (for example `assets/query_documentation_template.md`, `references/sql_pattern_library.md` and `scripts/sql_explainer.py`).

It sits in Databases, covering SQL, Plain language and style rules and Translation. 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

  • Documenting queries
  • Explaining analysis to non-technical stakeholders
  • Code reviewing for correctness
  • Building a query catalog

Example prompts

  • “/sql-to-business-logic”

Requirements

  • Python 3

Workflow steps

6 steps, taken from the first numbered list in SKILL.md.

  1. Receive the query and context — obtain the SQL and the business question it answers. Also collect any schema notes (what the key tables…
  2. Translate the FROM/JOIN structure — describe in plain language which data sources are combined and what type of join is used (inner keeps…
  3. Translate WHERE filters — list each filter condition as a business rule in plain language (e.g., status = 'completed' → "only includes…
  4. Explain GROUP BY and aggregations — describe what each aggregation computes and at what grain. Use scripts/sql_explainer.py to automate a…
  5. Summarise output columns — for each output column, state its business meaning and any edge cases (nulls, rounding, currency units).
  6. Flag issues and write validation questions — identify potential problems (implicit null propagation, unexpected fan-out, hardcoded dates)…

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 1 file 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

SQL To Business Logic loads about 636 tokens when it runs, and up to ~1.5k if it reads all its reference files. Until then it costs about 55 tokens; SKILL.md has 317 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~55
When it runs · the whole SKILL.md, loaded when a task matches
~636
With references · SKILL.md plus every file in references/, read only if the agent opens them
~1.5k

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). 317 words, ~636 tokens.

Download SKILL.mdSave it as .claude/skills/sql-to-business-logic/SKILL.md (or your agent's skills folder). This skill also uses 3 other files; get the full folder from GitHub.
name
sql-to-business-logic
description
Translate SQL queries into plain language business logic. Use when documenting queries, explaining analysis to non-technical stakeholders, code reviewing for correctness, or building a query catalog.

SQL to Business Logic Translator

When to use

  • A stakeholder asks "what exactly does this query calculate?"
  • Documenting a query library or a dbt model for non-technical readers
  • Reviewing a query for correctness by comparing its logic to the business requirement
  • Onboarding new analysts to existing SQL patterns
  • Translating legacy undocumented queries before refactoring

Process

  1. Receive the query and context — obtain the SQL and the business question it answers. Also collect any schema notes (what the key tables and columns represent in business terms).
  2. Translate the FROM/JOIN structure — describe in plain language which data sources are combined and what type of join is used (inner keeps only matches; left keeps all rows from the left side). Note if the join type seems inconsistent with the stated purpose.
  3. Translate WHERE filters — list each filter condition as a business rule in plain language (e.g., status = 'completed' → "only includes orders that have been paid and fulfilled").
  4. Explain GROUP BY and aggregations — describe what each aggregation computes and at what grain. Use scripts/sql_explainer.py to automate a first-pass structural parse.
  5. Summarise output columns — for each output column, state its business meaning and any edge cases (nulls, rounding, currency units).
  6. Flag issues and write validation questions — identify potential problems (implicit null propagation, unexpected fan-out, hardcoded dates). Generate 3–5 questions the query author should confirm. Use assets/query_documentation_template.md to record the full translation.

Inputs the skill needs

  • The complete SQL query (SELECT through ORDER BY)
  • The business question the query is intended to answer
  • Table and column descriptions (or a data catalog entry)
  • Any business rules for key status values, date handling, or currency
  • The intended output: who reads the result and for what decision

Output

  • scripts/sql_explainer.py — parses a SQL query and generates a structured plain-language explanation
  • assets/query_documentation_template.md — completed translation covering purpose, step-by-step logic, output columns, business rules, and validation questions
  • Optionally: a flowchart representation of the query logic

© 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 3 other files (scripts, references, assets) in 02-documentation-knowledge/sql-to-business-logic of nimrodfisher/data-analytics-skills.

  • SKILL.md
  • assets/query_documentation_template.md
  • references/sql_pattern_library.md
  • scripts/sql_explainer.py

Open the folder on GitHubat commit 9449d36

Compare with similar skills

SQL To Business Logic 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.

SQL To Business Logic compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
SQL To Business Logic this skillnimrodfisher/data-analytics-skills470—~636Automated safety check: PassMIT
SQL Translatorcriptogus/agent-evolve-network288—~735Automated safety check: PassCC-BY-SA-4.0
511 Frameworks Micronaut Jdbcjabrena/plinth447—~872Automated safety check: PassApache-2.0
SQL Explainerzhuyansen/agent-skills-hub413—~191Automated safety check: PassMIT
SQL Explainermergisi/awesome-openclaw-agents4k—~300Automated safety check: PassMIT
SQL TranslationMicrock/ordinary-claude-skills404—~1.3kAutomated safety check: PassCustom licence

Similar skills

  • SQL Translator

    criptogus/agent-evolve-network

    Translates a plain-English question into a single, safe, read-only SQL query against a known schema, with assumptions made explicit.

    288 GitHub stars~735 tokensUpdated 2 days ago
    DatabasesAuto-check passed
  • A skill your agent uses when you need programmatic JDBC in Micronaut — pooled DataSource, parameterized SQL, io.micronaut.transaction.annotation.Transactional, batching, and domain exception…

    447 GitHub stars~872 tokensUpdated 3 days ago
    DatabasesAuto-check passed
  • SQL Explainer

    zhuyansen/agent-skills-hub

    Explain what a SQL query does in plain language and point out joins that may multiply rows.

    413 GitHub stars~191 tokensUpdated yesterday
    DatabasesAuto-check passed
  • SQL Explainer

    mergisi/awesome-openclaw-agents

    Paste a SQL query and get a plain English explanation of what it does.

    4k GitHub stars~300 tokensUpdated 14 days ago
    DatabasesAuto-check passed
  • SQL Translation

    Microck/ordinary-claude-skills

    Guide for adding SQL function translations to dbplyr backends.

    404 GitHub stars~1.3k tokensUpdated 1 mo ago
    DatabasesAuto-check passed
  • Forge Codegen Crud

    yaomindong1996/forge-admin

    Generate or review Forge project code-generation output for CRUD modules.

    126 GitHub stars~1.3k tokensUpdated today
    Documents & OfficeAuto-check passed

More from nimrodfisher/data-analytics-skills

All 31 skills in this repo
  • Ab Test Analysis

    nimrodfisher/data-analytics-skills

    Rigorous A/B test statistical analysis. An agent skill from nimrodfisher/data-analytics-skills.

    470 GitHub stars~708 tokensUpdated 15 days ago
    Auto-check passed
  • Analysis Assumptions Log

    nimrodfisher/data-analytics-skills

    Track and document analytical assumptions and decisions. An agent skill from nimrodfisher/data-analytics-skills.

    470 GitHub stars~578 tokensUpdated 15 days ago
    Auto-check passed
  • Analysis QA Checklist

    nimrodfisher/data-analytics-skills

    Pre-delivery quality assurance for analysis work. An agent skill from nimrodfisher/data-analytics-skills.

    470 GitHub stars~470 tokensUpdated 15 days ago
    Auto-check passed
  • Business Metrics Calculator

    nimrodfisher/data-analytics-skills

    Standard business metric calculation with industry benchmarks.

    470 GitHub stars~668 tokensUpdated 15 days ago
    Auto-check passed
  • Cohort Analysis

    nimrodfisher/data-analytics-skills

    Time-based cohort analysis with retention and behaviour tracking.

    470 GitHub stars~660 tokensUpdated 15 days ago
    Auto-check passed
  • Context Packager

    nimrodfisher/data-analytics-skills

    Efficiently package context for AI-assisted analysis. An agent skill from nimrodfisher/data-analytics-skills.

    470 GitHub stars~500 tokensUpdated 15 days ago
    Auto-check passed

Works with

Questions about SQL To Business Logic

What does SQL To Business Logic do?

Translate SQL queries into plain language business logic. An agent skill from nimrodfisher/data-analytics-skills. SQL To Business Logic is an agent skill from nimrodfisher/data-analytics-skills. Translate SQL queries into plain language business logic.

When should I use SQL To Business Logic?

SQL To Business Logic fits situations like: documenting queries; explaining analysis to non-technical stakeholders; code reviewing for correctness; building a query catalog.

How do I install SQL To Business Logic in Claude Code?

Run `npx skills add nimrodfisher/data-analytics-skills --skill sql-to-business-logic -a claude-code`. Or copy the skill folder (02-documentation-knowledge/sql-to-business-logic in nimrodfisher/data-analytics-skills) into .claude/skills/sql-to-business-logic in your project. Claude Code loads it when a task matches its description.

How do I install SQL To Business Logic in Codex?

Run `npx skills add nimrodfisher/data-analytics-skills --skill sql-to-business-logic -a codex`. Or copy the skill folder (02-documentation-knowledge/sql-to-business-logic in nimrodfisher/data-analytics-skills) into .agents/skills/sql-to-business-logic in your project. Codex loads it when a task matches its description.

Can I use SQL To Business Logic 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 sql-to-business-logic -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/sql-to-business-logic, .gemini/skills/sql-to-business-logic, .github/skills/sql-to-business-logic and .opencode/skills/sql-to-business-logic in your project.

What does SQL To Business Logic need to run?

Going by SKILL.md and its folder, SQL To Business Logic needs Python for the scripts in its folder. Our summary lists: Python 3.

Does SQL To Business Logic 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 SQL To Business Logic 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 SQL To Business Logic use?

SQL To Business Logic 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 SQL To Business Logic use?

About 636 tokens (SKILL.md is roughly 2.5k 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 904 tokens, read only when the agent opens those files.

What are the alternatives to SQL To Business Logic?

Skills that share tags, products or a category with SQL To Business Logic: SQL Translator (criptogus/agent-evolve-network, 288 stars), 511 Frameworks Micronaut Jdbc (jabrena/plinth, 447 stars), SQL Explainer (zhuyansen/agent-skills-hub, 413 stars) and SQL Explainer (mergisi/awesome-openclaw-agents, 4k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains SQL To Business Logic?

nimrodfisher (a GitHub user) maintains it in nimrodfisher/data-analytics-skills, which has 470 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.