Provide PostgreSQL best practices for schema design, performance tuning, security, and operations.
npx skills add https://github.com/mamamou/ai-coding-skills --skill postgres-mamamou
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/mamamou/ai-coding-skills/tree/main/postgres Command: npx skills add https://github.com/mamamou/ai-coding-skills --skill postgres-mamamou
PostgreSQL best practices for schema design, query optimization, security, and operations to help teams build robust, scalable databases.
Configure baseline PostgreSQL settings, enable essential extensions like pg_stat_statements, and adopt recommended operational patterns to start applying best practices today.
High-intent search queries and answers about installing and using this skill.
Configure PostgreSQL performance tuning by applying schema design, indexing, and MVCC best practices alongside essential extensions like pg_stat_statements to monitor query execution and improve production scalability.
PostgreSQL zero-downtime migrations require formal operational patterns for schema changes and upgrades. Following established best practices ensures continuous availability during maintenance tasks for production-grade database deployments.
MVCC in PostgreSQL dictates concurrency handling, requiring specific schema design and indexing strategies to optimize performance. Understanding MVCC fundamentals ensures reliable query execution and scalable database operations.
Set up production-grade PostgreSQL by following operational best practices for replication, backups, and monitoring. Configuring essential extensions and adopting recommended patterns ensures robust database operations and reliable disaster recovery.
Yes, this PostgreSQL guidance covers real-world scenarios for OLTP, analytics, and geospatial workloads. It provides practical examples and tailored best practices to optimize schema design and performance tuning across diverse database use cases.
Implement PostgreSQL security and partitioning strategies by following formal best practices for production deployments. Proper partitioning improves query performance and scalability, while security guidelines ensure robust data protection for operators and developers.
newkubGuide PostgreSQL schema design, query optimization, and security best practices.
mbadozPlan zero-downtime database migrations across PostgreSQL, MySQL, and ORMs.
chicanoandres702Design and deploy production Grafana dashboards for system and application metrics.
ricableCoordinate distributed RuVector nodes with Raft consensus and auto-sharding.
