database-skill

What problem does it solve? Designing database schemas, writing migrations, and managing SQLAlchemy sessions involves repetitive boilerplate and easy-to-miss conventions. This Skill standardizes how models, migrations, and queries are generated so persistence code stays consistent across services. ## Core Features & Use Cases - Model Generation: Creates SQLAlchemy 2.0 declarative models with explicit primary keys and typed attributes, separated from Pydantic API schemas. - Migration Management: Generates Alembic migrations via autogenerate with rules for reviewing, naming, and never editing applied migrations. - Session & Connection Handling: Enforces environment-based connection strings, connection pooling, and context-managed session lifecycles. - Use Case: When adding a new orders table to a microservice, use this Skill to generate the SQLAlchemy model, produce the Alembic migration, and scaffold repository queries following project conventions. ## Quick Start Generate a SQLAlchemy model and Alembic migration for a new users table with email and created_at columns.