PostgreSQL

Use this skill for PostgreSQL schema design, SQL, query tuning, migrations, locking, pooling, and operations driven from TypeScript apps. It is ORM-agnostic: it names Drizzle and others as libraries only, and gives plain SQL plus postgres.js, pg, and Bun.SQL snippets.

Snapshot: PostgreSQL 18.6 is the current stable major (18.0 on 2025-09-25, EOL 2030-11-14); 19 is in beta 4 (2026-09-24). Supported: 14.24 (EOL 2026-11-12), 15, 16, 17, 18. Clients: postgres@3.4.9, pg@8.23.1, Bun 1.4 Bun.SQL. Refresh from source-map.md if the server or driver differs.

Workflow