From myk-review
> **Bug Reporting Policy:** If you encounter ANY error, unexpected behavior, or reproducible bug
How this command is triggered — by the user, by Claude, or both
Slash command
/myk-review:query-dbThe summary Claude sees in its command listing — used to decide when to auto-load this command
# Review Database Query Command > **Bug Reporting Policy:** If you encounter ANY error, unexpected behavior, or reproducible bug > while executing this command — DO NOT work around it silently. Ask the user: > "Should I create a GitHub issue for this?" Route to: > `myk-org/claude-code-config` for plugin/command spec or `myk-claude-tools` CLI issues. > Do not silently skip steps or apply manual fixes that hide the root cause. Query the reviews database for analytics and insights about PR review history. ## Prerequisites Check (MANDATORY) ### Step 0: Check uv If not found, install from...
Bug Reporting Policy: If you encounter ANY error, unexpected behavior, or reproducible bug while executing this command — DO NOT work around it silently. Ask the user: "Should I create a GitHub issue for this?" Route to:
myk-org/claude-code-configfor plugin/command spec ormyk-claude-toolsCLI issues. Do not silently skip steps or apply manual fixes that hide the root cause.
Query the reviews database for analytics and insights about PR review history.
uv --version
If not found, install from https://docs.astral.sh/uv/getting-started/installation/
myk-claude-tools --version
If not found, prompt to install: uv tool install myk-claude-tools
/myk-review:query-db stats --by-source # Stats by source
/myk-review:query-db stats --by-reviewer # Stats by reviewer
/myk-review:query-db patterns --min 2 # Find duplicate patterns
/myk-review:query-db dismissed --owner X --repo Y
/myk-review:query-db query "SELECT * FROM comments WHERE status='skipped' LIMIT 10"
/myk-review:query-db find-similar < comments.json # Find similar dismissed comments
Show addressed rate by source (human vs AI reviewers):
myk-claude-tools db stats --by-source
Show statistics by individual reviewer:
myk-claude-tools db stats --by-reviewer
Find recurring dismissed suggestions:
myk-claude-tools db patterns --min 2
Get all dismissed comments for a specific repo:
myk-claude-tools db dismissed --owner <owner> --repo <repo>
Run a custom SELECT query:
myk-claude-tools db query "SELECT * FROM comments WHERE status = 'skipped' ORDER BY id DESC LIMIT 10"
Find comments similar to previously dismissed ones. Accepts JSON input via stdin:
echo '[{"body": "Consider adding error handling", "path": "src/main.py"}]' | myk-claude-tools db find-similar
Input format: JSON array of objects with body (required) and optionally path fields.
Returns matches with similarity scores to help identify recurring patterns that were previously dismissed.
reviews table:
| Column | Type |
|---|---|
| id | INTEGER PRIMARY KEY |
| pr_number | INTEGER |
| owner | TEXT |
| repo | TEXT |
| commit_sha | TEXT |
| created_at | TEXT (ISO 8601) |
comments table:
| Column | Type |
|---|---|
| id | INTEGER PRIMARY KEY |
| review_id | INTEGER (FK -> reviews.id) |
| source | TEXT (human/qodo/coderabbit) |
| thread_id | TEXT |
| node_id | TEXT |
| comment_id | INTEGER |
| author | TEXT |
| path | TEXT |
| line | INTEGER |
| body | TEXT |
| priority | TEXT (HIGH/MEDIUM/LOW) |
| status | TEXT (pending/addressed/skipped/not_addressed) |
| reply | TEXT |
| skip_reason | TEXT |
| posted_at | TEXT (ISO 8601) |
| resolved_at | TEXT (ISO 8601) |
The reviews database is located at <project-root>/.claude/data/reviews.db.
Query Constraints:
npx claudepluginhub myk-org/claude-code-config --plugin myk-review