Harness-engineering harness-sql-review

name: harness-sql-review version: "1.0.0" description: SQL query optimization, index analysis, N+1 detection, and query plan review stability: static cognitive_mode: adversarial-reviewer paths:

• '*.sql' triggers:
• manual
• on_pr platforms:
• claude-code
• gemini-cli
• cursor
• codex tools:
• Bash
• Read
• Write
• Edit
• Glob
• Grep
• emit_interaction cli: command: harness skill run harness-sql-review args:
  • name: path description: Project root path required: false
  • name: dialect description: "SQL dialect: postgresql, mysql, sqlite, mssql. Auto-detected when omitted." required: false
  • name: explain description: Include EXPLAIN ANALYZE output for detected queries when database connection is available required: false mcp: tool: run_skill input: skill: harness-sql-review path: string type: rigid tier: 3 internal: false keywords:
• SQL
• query optimization
• index
• N+1
• explain plan
• slow query
• join
• subquery
• query plan
• database performance
• EXPLAIN ANALYZE stack_signals:
• "src/**/*.sql"
• "queries/"
• "src//repositories/"
• "src//dao/"
• "src/**/query"
• "src/**/repository" phases:
• name: scan description: Locate SQL queries in source files, ORMs, raw queries, and migration scripts required: true
• name: analyze description: Evaluate query patterns for N+1, missing indexes, full table scans, and join efficiency required: true
• name: optimize description: Produce optimized query alternatives, index recommendations, and batching strategies required: true
• name: validate description: Verify optimizations preserve correctness and estimate performance improvement required: true state: persistent: false files: [] depends_on: [] related_skills:
• prisma-performance-patterns
• drizzle-performance-patterns
• prisma-raw-queries
• drizzle-query-builder