python-database-patterns - Python Database Patterns with SQLAlchemy
SQLAlchemy 2.0 and database patterns for Python applications
Tags
Updated: 2026-03-10Capabilities
Typical Inputs
Typical Outputs
What this skill does
- create engine
- define model
- create table
- execute query
- manage session
- define relationship
- run migration
- configure pool
- integrate FastAPI
Inputs
- database connection
- model classes
- query statement
Outputs
- query results
- migrated schema
- database state
Requirements
- SQLAlchemy 2.0+
- Python 3.10+
- asyncpg or aiosqlite for async
