role-database:connection-management

What problem does it solve?

This Skill addresses the challenges of inefficient database connection management, which can lead to performance bottlenecks, resource exhaustion, and application instability.

Core Features & Use Cases

• Connection Pooling: Manages and reuses database connections efficiently across various engines (PostgreSQL, MySQL) using tools like PgBouncer, pgcat, and ProxySQL.
• Pool Sizing & Optimization: Provides guidance on calculating optimal pool sizes and configuring application-level pooling (Prisma, SQLAlchemy, HikariCP, Go's database/sql).
• Serverless Strategies: Explains connection strategies for serverless environments.
• Leak Detection: Offers methods to detect and prevent connection leaks.
• Use Case: When setting up a new microservice that connects to a PostgreSQL database, use this Skill to configure PgBouncer for optimal transaction pooling and determine the appropriate max connection setting for your application's pool.

Quick Start

Configure PgBouncer for transaction pooling with a maximum of 50 server connections per database.