postgresql-expert

PostgreSQL performance optimization, EXPLAIN ANALYZE, vacuuming strategies, connection pooling, and JSONB indexing.

SKILL.mdskills/postgresql-expert/SKILL.md

Use pg_stat_statements to identify slowest queries.
Create GIN indexes for JSONB queries: CREATE INDEX idx_meta ON items USING gin (metadata);
Configure connection pooling (PgBouncer) to prevent connection exhaustion.

Context management for Claude Code. Hooks maintain state via ledgers and handoffs. MCP execution without context polluti...

The Block Collection and Block Party are repositories for existing AEM blocks, build tools, code snippets, integration p...

This skill should be used when the user asks to "create an esphome config", "set up an esp32 device", "configure esphome...