sqlmodel-expert

What problem does it solve?

This Skill enables building robust SQLModel data models and managing production-grade migrations with Alembic, smoothing the path from prototype to stable schemas.

Core Features & Use Cases

• Advanced modeling patterns: one-to-many, many-to-many, and self-referential relationships with validations and mixins.
• Comprehensive migrations and data migrations: using Alembic, zero-downtime strategies, and data backfills.
• Practical templates and references: sample models, migration scripts, and best practices to accelerate real-world projects.

Quick Start

Install required tooling and scaffold your project:

1. Create a Python virtual environment and install: pip install sqlmodel alembic
2. Initialize Alembic: alembic init alembic
3. Create and apply migrations as you evolve your SQLModel models:
   • Modify your models, then run ./scripts/migrate.sh create "description"
   • Upgrade to head: alembic upgrade head
4. Initialize the database with the included script: python scripts/init_db.py --url postgresql://user:pass@localhost/db