Summary
This is production PostgreSQL knowledge packaged up: indexing strategies, query optimization with EXPLAIN, partitioning for tables with 100M+ rows, and replication setup. It covers the stuff you actually need when databases get serious, like MVCC internals, VACUUM operations, choosing between B-tree and BRIN indexes, and connection pooling with pgBouncer. The skill walks through when to use each index type (GIN for JSONB, BRIN for time-series) and replication modes (synchronous vs asynchronous tradeoffs). Honestly most useful if you're already past basic SQL and dealing with performance problems or scaling challenges. Not a tutorial, more like having a senior database engineer's decision framework at hand.
Install to Claude Code
npx -y skills add manutej/luxor-claude-marketplace --skill postgresql-database-engineering --agent claude-codeInstalls into .claude/skills of the current project.
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →
Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →
Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →Files
SKILL.md
Select a file.
Featured
Keeps your Mac awake while Claude Code, Codex or Cursor works. Lets it sleep when they are done.
Try free for 7 days →Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Free an open-source skills that make AI coding agents easier to understand, verify, and control.
Download for free →
