cross-env-postgresql-extensions

What problem does it solve?

This skill provides a robust, cross-environment approach for PostgreSQL extension migrations by using a DO block pattern to handle privilege elevation, existence checks, and environment-specific differences.

Core Features & Use Cases

• Cross-environment compatibility for enabling and disabling extensions across Nhost Cloud, CNPG, and standard PostgreSQL.
• DO block pattern with exception handling to safely create and drop extensions without causing migration failures.
• Guidance for common extensions (vector, postgis, pg_trgm, unaccent, etc.) and per-environment behavior.
• Supports up.sql and down.sql migration scripts with idempotent creation and safe rollback.

Quick Start

Run a migration that creates or ensures an extension using the DO block pattern. For example, to enable the vector extension across environments, apply the up.sql pattern with the DO block followed by CREATE EXTENSION IF NOT EXISTS vector.