Optimize PostgreSQL production performance with tuning, indexing, and replication guidance.
npx skills add https://github.com/arbazkhan971/godmode --skill postgres-arbazkhan971
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/arbazkhan971/godmode/tree/main/skills/postgres Command: npx skills add https://github.com/arbazkhan971/godmode --skill postgres-arbazkhan971
PostgreSQL performance, scaling, and operational reliability are hard to get right at production scale; this Skill provides a systematic approach to diagnosing slow queries, reducing bloat, configuring resource settings, and implementing safe replication and partitioning strategies to keep databases healthy and fast.
Analyze my PostgreSQL database for performance bottlenecks and recommend concrete tuning, indexing, partitioning, and pooling changes.
High-intent search queries and answers about installing and using this skill.
PostgreSQL partitioning strategies for large tables involve range, list, or hash partitioning to improve scaling. This Skill advises the appropriate partitioning method and connects it with logical and streaming replication guidance to maintain operational reliability.
The best way to configure connection pooling with PgBouncer is to limit direct connections and route traffic through a pooler. This Skill provides pooling guidance to reduce connection overhead and ensures operational safety for self-managed and cloud-managed instances.
You should never disable autovacuum in PostgreSQL because it manages bloat and maintains operational safety by reclaiming dead tuples. This Skill enforces hard rules like keeping autovacuum active and creating indexes concurrently to prevent performance degradation.
Yes, you can use PostgreSQL extensions like pgvector, TimescaleDB, and PostGIS with managed cloud databases. This Skill provides guidance on integrating these extensions and recommends managed helpers like Supavisor for multi-tenant setups.
To set up streaming and logical replication for PostgreSQL, you configure replication parameters and establish connections between primary and replica instances. This Skill provides replication and backup guidance to ensure high availability and operational reliability.
LaurentPRAT-DBAnalyze Databricks metrics and logs to tune Spark configuration and caching.
NguyenvanleOptimize Postgres performance with Supabase best practices for querying, indexing, and partitioning.
HieubkavAnalyze database indexes and query execution plans to recommend optimizations.
nguyenpv1980-wqDecide cloud platform and deployment posture from verified requirements and constraints.
