neon-async-db

What problem does it solve?

This skill provides a battle-tested pattern for establishing and maintaining reliable asynchronous connections to Neon Serverless PostgreSQL databases using SQLModel and SQLAlchemy's async APIs. It addresses the challenges of latency, connection pooling, and burst workloads in serverless environments, enabling scalable data access for Python apps.

Core Features & Use Cases

• Asynchronous engine creation with the postgresql+asyncpg driver using create_async_engine
• Async session management via a get_async_session dependency
• Central Base metadata management for SQLModel models
• Health checks to verify connectivity in serverless deployments
• Serverless-optimized pool settings for burst workloads
• Real-world use cases: FastAPI or other async frameworks connecting to Neon PostgreSQL

Quick Start

Use this skill to set up Neon Serverless PostgreSQL with async SQLModel in your Python app.

• Install dependencies: pip install sqlalchemy sqlmodel asyncpg
• Ensure DATABASE_URL is present in the environment for Neon Serverless
• Create an async engine and session: engine = create_async_engine(DATABASE_URL, echo=False, pool_pre_ping=True) async_session = sessionmaker(engine, class_=AsyncSession, expire_on_commit=False)
• Provide a dependency to inject sessions into routes or business logic using get_async_session.