Postgresql Database Engineering

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 copies · 90 days. Times the install command was copied on this site in the last 90 days, bots filtered.: 8
skills.sh installs: 1.8K
GitHub stars: 63
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add manutej/luxor-claude-marketplace --skill postgresql-database-engineering --agent claude-code

Installs into .claude/skills of the current project.

Files

PostgreSQL Database Engineering

A comprehensive skill for professional PostgreSQL database engineering, covering everything from query optimization and indexing strategies to high availability, replication, and production database management. This skill enables you to design, optimize, and maintain high-performance PostgreSQL databases at scale.