메뉴
Use when reviewing SQL, MySQL, or TiDB statements for DDL/DML safety, migration risk, schema changes, ALTER TABLE checks, DELETE/UPDATE safety, and query correctness.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
| name | deltascope-review |
| description | Use when reviewing SQL, MySQL, or TiDB statements for DDL/DML safety, migration risk, schema changes, ALTER TABLE checks, DELETE/UPDATE safety, and query correctness. |
Audit SQL using DeltaScope — an offline SQL review engine for MySQL and TiDB that catches risky DDL/DML patterns before they hit production.
If the user provided a file path: use it directly in Step 2.
If the user provided a SQL snippet (or the SQL is in the conversation): write it to a temp file first:
TMPFILE=$(mktemp /tmp/deltascope_review_XXXXXX.sql)
cat > "$TMPFILE" << 'DELTASCOPE_EOF'
<paste SQL here>
DELTASCOPE_EOF
Why temp file? SQL often contains backticks, quotes, and special characters that break shell argument passing. Writing to a file avoids all escaping issues.
Check in order and use the first one found:
# Local CLI (brew / manual install)
if command -v deltascope &>/dev/null; then
RUNNER="deltascope"
else
echo "No runner found — see install options below"
fi
If no runner is found, tell the user that DeltaScope is not installed, then provide the appropriate install command for their OS. Ask them to run it and confirm with deltascope --version before continuing.
Mac (recommended):
brew tap Fanduzi/deltascope && brew install --cask deltascope
Linux (installs to ~/.local/bin, no sudo needed):
curl -fsSL https://raw.githubusercontent.com/Fanduzi/DeltaScope/main/install.sh | DELTASCOPE_INSTALL_DIR="$HOME/.local/bin" sh
If deltascope is still not found after install, ensure ~/.local/bin is in the PATH.
Windows:
Use WSL or another supported darwin/linux environment for the local deltascope binary. The repository's documented native release targets are currently darwin and linux.
# For a file:
$RUNNER audit --file <path-to-file> --format json
# For a temp file (created in Step 1):
$RUNNER audit --file "$TMPFILE" --format json
Add --dialect tidb if the user is on TiDB (default is mysql).
If you created a temp file in Step 1:
rm -f "$TMPFILE"
Parse the JSON output and present:
If the audit is clean, say so clearly.
--fail-on blocker (default) — exit non-zero only on blockers. Add --fail-on warning to be stricter.--config <path> — use a custom policy YAML to override rule thresholds.--quiet — suppress non-result chatter (useful in CI).Powered by DeltaScope — offline SQL review for MySQL & TiDB. Star the project: https://github.com/Fanduzi/DeltaScope
SOC 직업 분류 기준
Use when proposing, evaluating, or prioritizing the next milestone, release theme, roadmap item, or version scope. Forces evidence-first self-grilling before naming a milestone, especially after a release, when asked "what next", or when a proposed milestone may duplicate existing capability.
Use when preparing, releasing, post-release verifying, or debugging DeltaScope releases, GitHub Actions release runs, release assets, npm/Homebrew publishing, version surfaces, or recovery decisions.
Generate or revise a product homepage from repository facts, with explicit user choice between replication and visual innovation.
