postgres
PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.
Works with
--- name: postgres description: PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases. license: MIT --- # Postgres ## Schema and Query Optimization | Topic | Reference | Use for | | ---------------------- | ---------------------------------------------------------------------------- | --------------------------------------------------------- | | Schema Design | [references/schema-design.md](references/schema-design.md) | Tables, primary keys, data types, foreign keys | | Indexing | [references/indexing.md](references/indexing.md) | Index types, composite indexes, performance | | Index Optimization | [references/index-optimization.md](references/index-optimization.md) | Unused/duplicate index queries, index audit | | Partitioning | [references/partitioning.md](references/partitioning.md) | Large tables, time-series, data retention | | Query Patterns | [references/query-patterns.md](references/query-patterns.md) | SQL anti-patterns, JOINs, pagination, batch queries | | Optimization Checklist | [references/optimization-checklist.md](references/optimization-checklist.md) | Pre-optimization audit, cleanup, readiness checks | | MVCC and VACUUM | [references/mvcc-vacuum.md](references/mvcc-vacuum.md) | Dead tuples, long transactions, xid wraparound prevention | ## Operations and Architecture | Topic | Reference | Use for | | -------------------- | -------------------------------------------------------------------------- | ------------------------------------------------------------ | | Process Architecture | [references/process-architecture.md](references/process-architecture.md) | Multi-process model, connection pooling, auxiliary processes | | Memory Architecture | [references/memory-management-ops.md](references/memory-management-ops.md) | Shared/private memory layout, OS page cache, OOM prevention | | MVCC Transactions | [references/mvcc-transactions.md](references/mvcc-transactions.md) | Isolation levels, XID wraparound, serialization errors | | WAL and Checkpoints | [references/wal-operations.md](references/wal-operations.md) | WAL internals, checkpoint tuning, durability, crash recovery | | Replication | [references/replication.md](references/replication.md) | Streaming replication, slots, sync commit, failover | | Storage Layout | [references/storage-layout.md](references/storage-layout.md) | PGDATA structure, TOAST, fillfactor, tablespaces, disk mgmt | | Monitoring | [references/monitoring.md](references/monitoring.md) | pg_stat views, logging, pg_stat_statements, host metrics | | Backup and Recovery | [references/backup-recovery.md](references/backup-recovery.md) | pg_dump, pg_basebackup, PITR, WAL archiving, backup tools |
More Database skills
prisma-mongodb-upgrade
prisma/skills
Decision and migration guide for Prisma ORM MongoDB projects on v6, which have no upgrade path to v7. Use when a MongoDB project asks about upgrading Prisma, when "upgrade to prisma 7" comes up in a project with provider = "mongodb", or when evaluating a move to Prisma Next. Triggers on "upgrade prisma mongodb", "prisma 7 mongodb", "mongodb prisma migration", "prisma next mongodb".
azure-upgrade
microsoft/azure-skills
Assess and upgrade Azure workloads between plans, tiers, or SKUs, or modernize Azure SDK dependencies in source code. WHEN: upgrade Consumption to Flex Consumption, upgrade Azure Functions plan, change hosting plan, function app SKU, migrate App Service to Container Apps, modernize legacy Azure Java SDKs (com.microsoft.azure to com.azure), migrate Azure Cache for Redis (ACR/ACRE) to Azure Managed Redis (AMR).
azure-cost-optimization
microsoft/azure-skills
Identify Azure cost savings from usage and spending data. USE FOR: optimize Azure costs, reduce Azure spending/expenses, analyze Azure costs, find cost savings, generate cost optimization report, identify orphaned resources to delete, rightsize VMs, reduce waste, optimize Redis costs, optimize storage costs, AKS cost analysis add-on, namespace cost, cost spike, anomaly, budget alert, AKS cost visibility. DO NOT USE FOR: deploying resources (use azure-deploy), general Azure diagnostics (use azure-diagnostics), security issues (use azure-security)
