Pistachio – A declarative schema migration tool for PostgreSQL
Uses PostgreSQL's own parser when sqldef hits parsing limits.
PostgreSQL schema intelligence MCP server with offline linting, migration safety, query validation for AI coding assistants.
Offline schema snapshots keep AI agents from wrecking your production database.
Backend developers and DBAs using AI coding assistants
pgAdmin · Sqitch · Cursor
Uses PostgreSQL's own parser when sqldef hits parsing limits.
Drop-in migra replacement with migrations folder support and AI explanations.
Keeps the abandoned migra tool alive, but Atlas and Flyway already own this space.
PostgreSQL schemas + search_path trick gives each Git branch its own database schema.
Offline version-accurate API queries beat fetching docs from remote servers.
Stops AI hallucination with `column_values` and `find_join_path` instead of generic query tools.