sql-business-logic-review SKILL.md skillA

sql-business-logic-review from yeaight7/agent-powerups is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add yeaight7/agent-powerups/sql-business-logic-review@git:20260605.e787b66

Pins git:20260605.e787b66 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
yeaight7/agent-powerups
Path
plugins/data-engineering/skills/sql-business-logic-review/SKILL.md
Versions recorded
2
Latest version
git:20260605.e787b66, committed Jun 5, 2026
First version recorded
May 2, 2026
Size
3,171 bytes
Repository stars
8
License
Apache-2.0

Use when reviewing SQL that affects reporting, metrics, transformations, financial logic, product logic, or stakeholder-facing outputs -- especially when a query still runs fine but its business meaning may have drifted.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

## Purpose

Review SQL as business logic, not just syntax. Detect silent semantic changes and flag places where technically valid SQL can still produce wrong business results.

## When to Use

- Reviewing SQL changes that feed reports, metrics, or financial/product logic
- A query was modified and downstream numbers shifted, or might have
- Output looks plausible but the definition of what is being counted may have changed

## Inputs

- The SQL under review (diff preferred, full query otherwise)
- The intended grain and business definition, before and after the change

## Workflow

1. **Establish the intended grain** before and after the query or change.

2. **Scan for the standard risk patterns:**
   - grain mismatches
   - duplicate rows introduced by joins
   - incorrect join keys
   - left vs inner join behavior changes
   - filters that alter population definitions
   - null handling that changes meaning
   - default values that hide data quality issues
   - aggregation mistakes
   - window functions with unsafe partitions or ordering
   - date logic and timezone assumptions
   - incremental logic that can double count, miss rows, or drift
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add yeaight7/agent-powerups/sql-business-logic-review@sha256:db9058868e2665e1

The line at the top of this page pins the label git:20260605.e787b66, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_efpv7m5krzyzgpvx.svg)](https://markdownregistry.com/a/art_efpv7m5krzyzgpvx)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 2 versions of this file, between May 2, 2026 and Jun 5, 2026, about one every 34 days.

versioncommittedcommitsizeaudit
git:20260605.e787b66 latest2026-06-05 e787b66 3,171 BA view · diff
git:20260502.92e9d4b2026-05-02 92e9d4b 1,701 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (3171 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

yeaight7/agent-powerups · 8 stars · license Apache-2.0 · pushed 2026-09-27 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_efpv7m5krzyzgpvx
GET https://markdownregistry.com/api/v1/resolve?ref=yeaight7/agent-powerups/sql-business-logic-review
GET https://markdownregistry.com/api/v1/blob/db9058868e2665e15a9f152ac5232caa7413c2cc545515b6afe86964ffec54fe

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from yeaight7/agent-powerups

AGENTS.md AGENTS.md file
yeaight7/agent-powerups · AGENTS.md
git:20260606.7ba0c89 · audit A · 8 stars
CLAUDE.md CLAUDE.md file
yeaight7/agent-powerups · CLAUDE.md
git:20260602.7ef7075 · audit A · 8 stars
AGENTS.md@agents-md/dbt-project AGENTS.md file
yeaight7/agent-powerups · agents-md/dbt-project/AGENTS.md
git:20260428.06dc83e · audit A · 8 stars
AGENTS.md@agents-md/marketing-site AGENTS.md file
yeaight7/agent-powerups · agents-md/marketing-site/AGENTS.md
git:20260921.16cf58b · audit A · 8 stars
AGENTS.md@agents-md/ml-project AGENTS.md file
yeaight7/agent-powerups · agents-md/ml-project/AGENTS.md
git:20260428.c8f26bf · audit A · 8 stars
AGENTS.md@agents-md/open-source-maintainer AGENTS.md file
yeaight7/agent-powerups · agents-md/open-source-maintainer/AGENTS.md
git:20260428.259b8b4 · audit A · 8 stars
AGENTS.md@agents-md/python-library AGENTS.md file
yeaight7/agent-powerups · agents-md/python-library/AGENTS.md
git:20260428.ee0647d · audit A · 8 stars
AGENTS.md@agents-md/typescript-app AGENTS.md file
yeaight7/agent-powerups · agents-md/typescript-app/AGENTS.md
git:20260428.8b5127b · audit A · 8 stars
prompt-evaluation-runner SKILL.md skill
yeaight7/agent-powerups · plugins/agent-evaluation-lab/skills/prompt-evaluation-runner/SKILL.md · Use when evaluating prompts, LLM outputs, red-team suites, or model behavior with local eval configs and safe…
git:20260606.f062e44 · audit A · 8 stars
red-team-eval-authoring SKILL.md skill
yeaight7/agent-powerups · plugins/agent-evaluation-lab/skills/red-team-eval-authoring/SKILL.md · Use when creating or reviewing red-team eval plugins, attack templates, grader rubrics, safety fixtures, or model-risk…
git:20260606.7a1fed0 · audit B · 8 stars
skill-evaluation-workbench SKILL.md skill
yeaight7/agent-powerups · plugins/agent-evaluation-lab/skills/skill-evaluation-workbench/SKILL.md · Use when designing, running, debugging, or hardening deterministic eval suites for agent skills, prompts, tool…
git:20260606.7a2d45f · audit A · 8 stars
agent-harness-design SKILL.md skill
yeaight7/agent-powerups · plugins/agentic-systems/skills/agent-harness-design/SKILL.md · Use when designing tool definitions for a new agent or subagent, an agent shows high retry rates, ambiguous tool…
git:20260606.362908d · audit A · 8 stars

Every file in yeaight7/agent-powerups

Browse by kind, by grade A, or by owner.