shared-pool-pattern

What problem does it solve?

This Skill provides a proven pattern for sharing a single database connection pool across multiple services within a single application, reducing resource usage and connection overhead while preserving service isolation.

Core Features & Use Cases

• Single Shared Pool: Creates one pool at startup that is reused by all services.
• Schema-Isolated Managers: Each service gets its own manager with a dedicated database schema to avoid table conflicts.
• Per-Service Migrations: Independent migrations run per service module to keep schemas up to date.
• FastAPI Integration: Demonstrates how to wire the shared pool into FastAPI lifespans and dependency injections.

Quick Start

Initialize a shared pool at application startup, then create per-service managers with distinct schemas and run migrations.