Design PostgreSQL schemas, indexes, and safe online migrations; diagnose locks and slow queries with EXPLAIN; configure pooling, auth, and backup/restore without PgBouncer or invalid-index traps.
Install
npx skills add alivirgo/Major-AI-Skills --skill postgresqlnpx skills add alivirgo/Major-AI-Skills --skill postgresql -a claude-code -gnpx skills add alivirgo/Major-AI-Skills --skill postgresql -a codex -ggemini skills install https://github.com/alivirgo/Major-AI-Skills.git --path skills/postgresqlgh skill install alivirgo/Major-AI-Skills postgresqlgit clone --depth 1 https://github.com/alivirgo/Major-AI-Skills /tmp/alivirgo__Major-AI-Skills
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/alivirgo__Major-AI-Skills/skills/postgresql ~/.claude/skills/postgresql # Claude Code
cp -R /tmp/alivirgo__Major-AI-Skills/skills/postgresql ~/.agents/skills/postgresql # Codex, Cursor, Gemini CLI, Copilot, OpenCode