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.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
