boringSQL | Supercharge your SQL & PostgreSQL powers
boringSQL provides tools to test and optimize PostgreSQL queries, with RegreSQL being an open-source tool for SQL query regression testing.
About this tool
boringSQL is a toolkit focused on PostgreSQL, aiming to enhance SQL development. Its core product, RegreSQL, is an open-source tool for SQL query regression testing. It compares query outputs against known baselines and generates diffs to help developers identify logical errors. RegreSQL includes a trust filter to avoid false positives from statistical sampling noise, and supports gating on actual execution metrics such as q-error, buffers, and temp/spill. It integrates with CI/CD, outputting JUnit XML, pgTAP, GitHub Actions, and JSON formats, and works with local SQL migrations or third-party tools like goose.