shrugged

Declarative PostgreSQL migrations with type-safe model and query generation.

Features

• Declarative schema - Write your schema once, get forward and rollback migrations generated automatically
• Schema diffing - Supports all PostgreSQL objects (tables, indexes, functions, triggers, policies, etc.)
• Code generation - Generate type-safe models and query bindings from your database
• Extensions - Add custom fields and Scanner types to generated models that survive regeneration
• Query-to-model matching - Queries that return all model columns automatically use your model type
• Schema linting - Catch issues like missing foreign key indexes before they hit production
• Drift detection - Know when your database has diverged from your migrations

Installation

curl -fsSL https://raw.githubusercontent.com/terminally-online/shrugged/main/install.sh | sh

Or with Go:

go install github.com/terminally-online/shrugged/cmd/shrugged@latest

Requirements: Docker, PostgreSQL 14+

Once installed just run the command shrugged to see all the available options.

Documentation

• Configuration
• Commands

License

MIT