python-db

What problem does it solve?

Async database access patterns in Python are error-prone and repetitive without a cohesive approach; this Skill provides a structured, production-ready guide for using SQLAlchemy asynchronously, including engine creation, AsyncSession management, declarative models, and migrations.

Core Features & Use Cases

• Async engine setup and AsyncSession usage for PostgreSQL with async drivers
• Declarative models with explicit tablename and mapped_column definitions
• Async queries using select() with proper result handling and caution against deprecated APIs
• Transactional patterns with commit and rollback to ensure atomic operations
• Alembic-based migrations to evolve schemas safely in production environments

Quick Start

Create a minimal async SQLAlchemy setup in your Python project and run a simple select() query to verify connectivity.