connection-pooling-specialist

What problem does it solve?

This skill helps diagnose and remediate database connection exhaustion, frequent connection timeouts, and inefficient pooling configurations in PostgreSQL and Supabase environments to restore application availability and reduce resource waste.

Core Features & Use Cases

• Connection diagnostics: Identify active, idle, and long-running connections and surface root causes of "too many connections" errors.
• Pooler configuration: Provide actionable guidance for Supavisor and PgBouncer configuration, pool modes, and sizing appropriate for serverless and long-lived workloads.
• Application guidance: Recommend client-side pool settings, connection reuse patterns, and graceful shutdown practices to prevent leaks.
• Use Case: Convert a fleet of serverless functions that were exhausting database connections into a pooled, low-latency architecture using Supavisor and tuned per-function pool sizes.

Quick Start

Inspect your Supabase/PostgreSQL connection metrics, switch serverless workloads to the pooled connection endpoint, and apply adjusted pool sizes per instance based on calculated connection requirements.