How does this help with 'Too many connections' errors?

It provides standardized PgBouncer configurations for transaction and session pooling to efficiently manage thousands of client connections.

Can I use this to monitor database health?

Yes, it includes specialized queries for monitoring replication lag, WAL differences, and identifying when partition pruning is disabled.

Is this skill compatible with cloud-managed PostgreSQL?

While it focuses on core PostgreSQL patterns, the partitioning and query optimization logic applies to RDS, Cloud SQL, and self-hosted instances.

What partitioning methods are supported by this skill?

The skill supports Range, List, and Hash partitioning patterns, providing the necessary SQL syntax and best practices for PostgreSQL 16+.

PostgreSQL Scaling & Performance

Name: PostgreSQL Scaling & Performance
Author: pluginagentmarketplace

bypluginagentmarketplace

•

データベース管理

Implements advanced PostgreSQL scaling strategies including partitioning, connection pooling, and high-availability replication.

The PostgreSQL Scaling skill provides a comprehensive toolkit for developers managing high-traffic databases and large datasets. It streamlines the implementation of complex database architectures by offering production-ready patterns for range, list, and hash partitioning, alongside expert PgBouncer configurations for efficient connection pooling. By providing specialized guidance on replication setup and lag monitoring, this skill helps developers ensure database resilience and performance, making it an essential resource for optimizing PostgreSQL for high-load production environments.

主な機能

01Automated partitioning setup for range, list, and hash types

02Optimized PgBouncer connection pooling configurations

03Real-time replication lag monitoring and performance audits

04Expert troubleshooting for partition pruning and connection limits

051 GitHub stars

06High availability replication and slot management

ユースケース

01Optimizing web application performance by implementing transaction-level connection pooling

02Managing massive time-series datasets through automated range partitioning

03Architecting high-availability database clusters with robust read-replicas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pluginagentmarketplace/custom-plugin-postgresql postgresql-scaling

For use in Claude.ai and ChatGPT

Download Skill