CheckOps home

Tools directory

S

CheckOps

Squawk

Squawk is an Apache-2.0 linter for PostgreSQL migrations that flags changes likely to cause downtime, with a CLI, Docker image, GitHub Action and browser playground.

Visit website

Latest public signals

Not refreshed yet. Refresh reads the public site and, when the entry has a GitHub repository, the latest release.

Visit Website

Introduction

Squawk is a linter for PostgreSQL migrations that aims to prevent unexpected downtime and encourage best practices.

It parses SQL migration files and warns about issues such as adding columns or constraints in ways that take heavy locks, creating indexes without CONCURRENTLY, or choosing 32-bit integers where bigint is safer, with help text for each rule. It runs as a CLI, a Docker image, a GitHub Action, and in a WASM playground.

In the quality loop Squawk gates risky migrations in pull requests.

The source code is at sbdchd/squawk on GitHub under the Apache-2.0 licence, with about 1,300 stars; the most recent commit was on 11 November 2026.

Features

  1. Downtime rules: Lock-heavy changes flagged.
  2. Help text: Fix guidance per rule.
  3. GitHub Action: PR comments.
  4. Docker image: ghcr.io/sbdchd/squawk.
  5. Playground: Check SQL in the browser.
  6. Configurable: Exclude rules.

Pros

  1. Focused: Catches costly migration mistakes.
  2. Free to use: Open source under the Apache-2.0 licence, so the core tool costs nothing to use.
  3. Actively maintained: The repository had commits as recent as 11 November 2026.

Cons

  1. PostgreSQL only: No other databases.
  2. SQL files: Needs raw SQL migrations.
  3. Context-blind: Cannot know table sizes.
squawk migrations/*.sql

Resources:

Pricing

Squawk is free and open source under the Apache-2.0 licence.

  1. PostgreSQL teams shipping frequent migrations.

Conclusion

Squawk is a cheap, effective guard against migration-induced outages.

Add it to every migration pull request.

On CheckOps, Squawk is filed under the Release & CI gates stage. Related tools listed here include pgTAP, utPLSQL, SQLFluff, Atlas, Database Lab Engine and dbt tests. When comparing them, weigh the licence, the languages and platforms each supports, whether it is self-hosted or managed, and how cleanly it slots into your existing CI pipeline. Details on this page were checked against the official website, documentation and repository on 11 November 2026.

Alternatives

Other tools on CheckOps that cover similar ground. Open a page, or compare one with Squawk side by side.