Postgresql Best Practices

This is a comprehensive PostgreSQL development framework built around a three-schema architecture pattern: data holds your tables, private contains internal functions and triggers, and api exposes SECURITY DEFINER functions that applications actually call. It pushes hard on specific conventions like Trivadis naming (l_ for locals, in_ for inputs) and includes a native PL/pgSQL migration system so you can skip Flyway. The skill covers everything from basic table APIs to advanced patterns like Medallion architecture for data warehouses, event sourcing, and pgvector search. It's opinionated about PostgreSQL 18+ features like uuidv7 and assumes you want enterprise-grade patterns with proper isolation. If you're building serious database-driven apps or migrating from Oracle, the schema separation model alone is worth studying.

Install to Claude Code

npx -y skills add wimolivier/postgresql-best-practices --skill postgresql-best-practices --agent claude-code