Quality score 67boringsql.com#coding#writing#productivity#marketing

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.

Visit website

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.

Use cases
  • Detect query regressions before deployment
  • Verify database migrations don't alter query results
  • Compare query performance across PostgreSQL versions or configurations
  • Automate regression tests in CI pipelines

Features & use cases

Compare query outputs against baselines and generate diffsTrust filter reduces false positives from statistical noiseGate on actual execution metricsSupport multiple output formatsIntegrate with CI/CDSupport local migrations and third-party tools

At a glance

Monetization
  • Free
Maturity signals
  • Open source
  • Public API
Learning curve
  • Medium

Resources

Sources

Every profile keeps its sources and latest verification date.