Create SQLAlchemy async session management setup
Generate complete async SQLAlchemy session management for FastAPI with connection pooling, error handling, and optional Supabase integration. Use for production-ready database setup with testing and migration support.
/plugin marketplace add kivo360/claude-toolbelt/plugin install asyncpg-to-sqlalchemy-converter@claude-toolbeltCreate SQLAlchemy async session management setup
This command generates complete async session management configuration for FastAPI projects, including dependency injection, connection pooling, error handling, and Supabase integration patterns.
/create-async-session [options]
--output <directory>: Output directory for session files (default: ./database)--supabase: Include Supabase-specific configurations--pool-size <number>: Connection pool size (default: 10)--max-overflow <number>: Maximum overflow connections (default: 0)--testing: Include testing configuration and fixtures--migrations: Include Alembic migration setup--docker: Generate Docker Compose configurationCreate basic session setup:
/create-async-session --output ./src/database
Create Supabase-enabled session management:
/create-async-session --supabase --pool-size 20 --testing
Complete setup with migrations and Docker:
/create-async-session --testing --migrations --docker --supabase
database.py - Main database configuration and session factorydependencies.py - FastAPI dependency injection patternsconfig.py - Environment-based configuration managementexceptions.py - Custom database exception handlerstesting.py - Testing configuration and fixturesmigrations/ - Alembic migration setupdocker-compose.yml - Database container configurationsupabase_integration.py - Supabase-specific integration patterns