Awesome Reviewers checks + prompts

verify / sql

Verifying SQL changes

Files: .sql. Run the checks under every change, add the checks for what your diff touches, then apply the review prompts for what the tools miss. Usage is measured across 0 scanned repositories that write SQL; prompts come from 17 review discussions.

raw .md .json

Run on every change

the tool most SQL repositories run for each check

  • Formatting Layout drift that buries the real change in the diff.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Linting Bug-prone patterns, unused code and conventions the formatter does not cover.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Type checking Wrong types, unhandled null or None, call signatures broken across modules.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Unit and integration tests Behaviour regressions on the paths the tests exercise.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Review prompts for every change 1 in total

  • langfuse/langfuse Naming Conventions Sql observability
    raw open

Add when the change touches

open the ones that describe your diff

Authentication, input handling, secrets, permissions security scanningsecret scanningdependency audit 3 prompts
  • Security scanning Injection, unsafe APIs and tainted data reaching a sink.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Secret scanning Credentials and tokens committed to the repository.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Dependency audit Known-vulnerable or disallowed dependencies and licenses.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • neondatabase/neon Security Sql data-systems
    raw open
  • Helicone/helicone Security Sql security
    raw open
  • langfuse/langfuse Security Sql observability
    raw open
Public APIs, signatures, error paths, nullability type checkingunit and integration testsproperty-based tests
  • Type checking Wrong types, unhandled null or None, call signatures broken across modules.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Unit and integration tests Behaviour regressions on the paths the tests exercise.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Property-based tests Edge-case inputs nobody wrote a test for; invariants over generated data.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Service and framework code unit and integration testsversion and platform matrix
  • Unit and integration tests Behaviour regressions on the paths the tests exercise.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Version and platform matrix Breakage on a runtime version, OS or feature combination you did not run locally.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Algorithms, parsers, data transforms property-based testsfuzzingmutation testingproofs and specifications
  • Property-based tests Edge-case inputs nobody wrote a test for; invariants over generated data.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Fuzzing Crashes, panics and hangs on malformed input, especially in parsers and decoders.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Mutation testing Tests that keep passing whatever the code does.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Proofs and specifications Design-level bugs in protocols and algorithms, checked against a specification.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Threads, async code, locks, shared state concurrency model checkingundefined-behaviour detectionproperty-based tests
  • Concurrency model checking Races and orderings that fail only under specific interleavings.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Undefined-behaviour detection Memory-safety and aliasing violations in unsafe code.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Property-based tests Edge-case inputs nobody wrote a test for; invariants over generated data.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Network calls, retries, timeouts, protocols unit and integration testsfuzzing
  • Unit and integration tests Behaviour regressions on the paths the tests exercise.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Fuzzing Crashes, panics and hangs on malformed input, especially in parsers and decoders.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

UI components and pages end-to-end browser testslinting
  • End-to-end browser tests User flows broken across components, routing and the network.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Linting Bug-prone patterns, unused code and conventions the formatter does not cover.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Databases, migrations, caching unit and integration testsversion and platform matrix 11 prompts
  • Unit and integration tests Behaviour regressions on the paths the tests exercise.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Version and platform matrix Breakage on a runtime version, OS or feature combination you did not run locally.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Helicone/helicone Migrations Sql data-systems
    raw open
  • elie222/inbox-zero Migrations Sql app-frameworks
    raw open
  • lobehub/lobe-chat Migrations Sql ai-agents
    raw open
  • rocicorp/mono Database Sql data-systems
    raw open
  • elie222/inbox-zero Database Sql app-frameworks
    raw open

6 more in Database, Migrations, Caching — the playbook lists the top 11.

Model, prompt and LLM code unit and integration tests
  • Unit and integration tests Behaviour regressions on the paths the tests exercise.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

CI workflows and configuration files ci workflow lintingfile hygiene
  • CI workflow linting Broken GitHub Actions syntax, script injection, over-broad token permissions.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • File hygiene Invalid JSON, YAML or TOML, merge markers, trailing whitespace, oversized files.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Dependencies and lockfiles dependency auditlockfile consistencyversion and platform matrix
  • Dependency audit Known-vulnerable or disallowed dependencies and licenses.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Lockfile consistency A lockfile that no longer matches its manifest.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Version and platform matrix Breakage on a runtime version, OS or feature combination you did not run locally.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

The tests themselves mutation testingversion and platform matrix 2 prompts
  • Mutation testing Tests that keep passing whatever the code does.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Version and platform matrix Breakage on a runtime version, OS or feature combination you did not run locally.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • apache/spark Testing Sql data-systems
    raw open
  • ClickHouse/ClickHouse Testing Sql data-systems
    raw open
Documentation and comments docs buildspelling
  • Docs build Broken cross-references, links and markup in documentation.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

  • Spelling Typos in identifiers, comments and docs.

    No scanned repository in this language runs a tool for this. Lean on the review prompts.

Where this comes from

0 scanned repositories with at least a fifth of their prompts in SQL

No scanned repository writes mostly SQL, so every check above falls back to cross-language tools or the prompts.