e-volv

Review playbook

DBQueryReview

Reviews database changes for the silent failure modes specific to raw SurrealQL: record-id casting, id resolution, datetime types, and FLEXIBLE placement.

Reviews pull requests that touch database access for SurrealDB-specific silent failure modes: record-id casting, short-id reconstruction, datetime handling, schema declaration order, null handling on SCHEMAFULL tables, and unbounded query shape. Configure the repository and branch on the Clone step after importing if you use this outside a pull-request trigger.

Identifier
db-query-review
Version
1.0.1
Steps
4
Triggers
2
  • database
  • surrealdb
  • query
  • review
  • performance
  • silent-failures

When it runs

Pull requestpull_request.opened
Settle delay
15s after the event

Only when all hold

  • pullRequest.isDraft not equals true
  • actor.username not in dependabot, dependabot[bot], renovate, renovate[bot], github-actions, github-actions[bot]
  • actor.username not contains [bot]
Pull requestpull_request.synchronize
Settle delay
15s after the event

Only when all hold

  • pullRequest.isDraft not equals true
  • actor.username not in dependabot, dependabot[bot], renovate, renovate[bot], github-actions, github-actions[bot]
  • actor.username not contains [bot]

The pipeline

The graph below is the one the workflow opens with in the builder — same steps, same layout, drawn on the same canvas. The run playing through it is a simulation; the branches and conditions are real.

React Flow
  1. 01
    PR Opened / Synchronizedtrigger

    The event that starts the run.

  2. 02
    Clone Repositorygit.clone

    Shallow-clones the repository at the right ref.

  3. 03
    Review Database Queriesagent.run

    One agent works the task with its toolkit.

  4. 04
    Publish Query Review Reportreport.publish

    Posts or updates a deduplicated report comment.

The agent

Database Query Reviewer

Base type
Code Reviewer
Temperature
0.2
Max iterations
25
Tools
6

Git provider · 2

  • get_pull_request_diffGet Pull Request Diff · read
  • read_pull_requestRead Pull Request · read

Filesystem · 2

  • read_fileRead File · read
  • list_dirList Directory · read

Code search · 1

  • code_searchCode Search · read

Status · 1

  • update_statusUpdate Status · write