/query-db

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

uv --version

If not found, install from https://docs.astral.sh/uv/getting-started/installation/

Step 1: Check myk-claude-tools

myk-claude-tools --version

If not found, prompt to install: uv tool install myk-claude-tools

Usage

/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

Available Queries

Stats by Source

Show addressed rate by source (human vs AI reviewers):

myk-claude-tools db stats --by-source

Stats by Reviewer

Show statistics by individual reviewer:

myk-claude-tools db stats --by-reviewer

Duplicate Patterns

Find recurring dismissed suggestions:

myk-claude-tools db patterns --min 2

Dismissed Comments

Get all dismissed comments for a specific repo:

myk-claude-tools db dismissed --owner <owner> --repo <repo>

Custom Query

Run a custom SELECT query:

myk-claude-tools db query "SELECT * FROM comments WHERE status = 'skipped' ORDER BY id DESC LIMIT 10"

Find Similar Comments

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.

Database Schema

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)

Database Location and Constraints

The reviews database is located at <project-root>/.claude/data/reviews.db.

Query Constraints:

• Only SELECT statements and CTEs (Common Table Expressions) are allowed
• INSERT, UPDATE, DELETE, DROP, and other modifying statements are blocked
• This ensures the database remains read-only for analytics queries

Workflow

1. Parse $ARGUMENTS to determine which query to run
2. Execute the appropriate myk-claude-tools db command
3. Present results in a clear, formatted way
4. For natural language questions, compose the appropriate query