PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.
Install
npx skills add affaan-m/ECC --skill postgres-patternsnpx skills add affaan-m/ECC --skill postgres-patterns -a claude-code -gnpx skills add affaan-m/ECC --skill postgres-patterns -a codex -ggemini skills install https://github.com/affaan-m/ECC.git --path .kiro/skills/postgres-patternsgh skill install affaan-m/ECC postgres-patternsgit clone --depth 1 https://github.com/affaan-m/ECC /tmp/affaan-m__ECC
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/affaan-m__ECC/.kiro/skills/postgres-patterns ~/.claude/skills/postgres-patterns # Claude Code
cp -R /tmp/affaan-m__ECC/.kiro/skills/postgres-patterns ~/.agents/skills/postgres-patterns # Codex, Cursor, Gemini CLI, Copilot, OpenCode