py-sqlmodel-patterns

What problem does it solve?

SQLModel blends Pydantic and SQLAlchemy, creating confusion around models, schemas, and asynchronous queries. This Skill provides clear patterns for defining models, relationships, and efficient query strategies in async contexts.

Core Features & Use Cases

• Pattern-driven approaches to model definitions, relationships, and session usage with SQLModel and async SQLAlchemy.
• Guidance on eager loading, N+1 prevention, upserts, and clean separation of concerns between DB models and API schemas.
• Use Case: When building an async FastAPI service with SQLModel, apply these patterns to keep code maintainable and correct.

Quick Start

Install SQLModel and SQLAlchemy, then reference the patterns in your project to model relationships, handle sessions, and implement efficient queries.