Liulishuo Tech Team

May 16, 2018 · Databases

Automating SQL Review with sql-review-helper: Capturing, Analyzing, and Reviewing SQL in CI

The article describes how to build and use a sql-review-helper tool that automatically captures all SQL statements during CI, deduplicates them, runs EXPLAIN to generate fingerprints, and stores the results in a reviewable file so that DBA and developers can reliably review every new SQL before it reaches production.