Postgresql Expert

This is a comprehensive PostgreSQL reference that goes deep on production database work. You get solid coverage of advanced data types like JSONB and arrays, full-text search implementation with tsvector, and detailed indexing strategies including when to use GIN, GiST, or BRIN indexes. The window functions and query optimization sections are practical. It's built for developers who need to tune performance, design efficient schemas, or debug slow queries rather than just run basic CRUD operations. The code examples are production-oriented, showing things like concurrent index creation and identifying unused indexes. Requires PostgreSQL 15 or higher and gives Claude access to psql and related command-line tools.

Install to Claude Code

npx -y skills add personamanagmentlayer/pcl --skill postgresql-expert --agent claude-code