HN Showcase
Back to browse
GitHub Repository

pistachio is a declarative schema management tool for PostgreSQL.

15 starsGo

Pistachio – A declarative schema migration tool for PostgreSQL

by winebarrel·Jun 14, 2026·2 points·0 comments
Visit ProjectView on HN

AI Analysis

●●SolidNiche GemShip It

Uses PostgreSQL's own parser when sqldef hits parsing limits.

Strengths
  • •pg_query_go means zero parser mismatches with PostgreSQL syntax
  • •Demo Docker image lets you test without local installation
  • •Breaking change documentation shows mature release management
Weaknesses
  • •Declarative schema migration is crowded with Atlas, sqitch, and sqldef
  • •Only 15 stars suggests limited community adoption so far
Target Audience

PostgreSQL developers and DBAs managing schema changes

Similar To

sqldef · Atlas · sqitch

Post Description

Pistachio is a declarative schema migration tool similar to sqldef.

I created this tool because there were some SQL statements that psqldef couldn't parse.

Since it uses pg_query_go, you can parse the SQL using PostgreSQL's SQL parser.

You can try out the demo using the following command:

docker run --rm -it ghcr.io/winebarrel/pistachio-demo

Similar Projects