db-connection

This Skill establishes robust Neon PostgreSQL connections in FastAPI by providing engine creation with connection pooling, enforced SSL, and environment-based configuration to prevent leaks and ensure production reliability.

Dropping Neon connections in FastAPI are prevented by this Skill through enforced connection pooling parameters, mandatory SSL modes, and active health checks that monitor and maintain connection stability.

This Skill enforces SSL for PostgreSQL connections in FastAPI by integrating mandatory SSL mode parameters into the SQLAlchemy engine creation and centralizing them via environment-based Settings configuration.

Yes, Alembic tooling is supported alongside Neon PostgreSQL connection pooling. This Skill integrates with Alembic migrations and exposes get_engine and get_db patterns to manage connections during schema changes.

Monitoring SQLAlchemy connection pool stats in FastAPI is handled by this Skill's built-in health checks and pooling stats monitoring, which track active connections and prevent resource exhaustion in production.

Environment variables are required for configuring FastAPI database connections with this Skill. It uses a centralized Settings model to read DB_URL, pool size, timeout, and SSL mode directly from the environment.