postgresql-database-engineering
Comprehensive PostgreSQL database engineering covering indexing, query optimization, replication, and production management.
- Covers 6 index types (B-tree, Hash, GiST, GIN, BRIN, SP-GiST) with decision matrices for choosing the right index for specific query patterns
- Includes streaming and logical replication setup, failover procedures, and high-availability configuration with synchronous/asynchronous modes
- Provides partitioning strategies (range, list, hash) with automation examples and partition pruning optimization for large tables
- Details MVCC concurrency model, transaction isolation levels, VACUUM operations, and connection pooling with pgBouncer and PgPool-II
- Covers physical and logical backups, point-in-time recovery (PITR), performance monitoring with pg_stat_statements, and troubleshooting common issues
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.
When to Use This Skill
Use this skill when:
More from manutej/luxor-claude-marketplace
docker-compose-orchestration
Container orchestration with Docker Compose for multi-container applications, networking, volumes, and production deployment
1.4Kgolang-backend-development
Complete guide for Go backend development including concurrency patterns, web servers, database integration, microservices, and production deployment
848jest-react-testing
Comprehensive React component testing with Jest and React Testing Library covering configuration, mocking strategies, async testing patterns, hooks testing, and integration testing best practices
664playwright-visual-testing
Browser automation, visual testing, and screenshot validation using Playwright MCP server for accelerated web development. Master visual regression testing, automated UI testing, and cross-browser validation.
616ui-design-patterns
Common interface patterns, navigation patterns, form patterns, data display patterns, feedback patterns, and accessibility considerations
500ux-principles
User research, usability heuristics, user psychology, accessibility, inclusive design, user testing, and UX metrics
470