sqlalchemy-orm

What problem does it solve?

This Skill provides a complete guide to using SQLAlchemy 2.0 for building Python applications with relational databases, including an ORM, declarative models, and migrations. It helps automate complex data access patterns, reducing boilerplate and ensuring type-safe SQL queries.

Core Features & Use Cases

• Declarative Models: Define models with Python type hints and clear relationships.
• Powerful Querying: Use modern SQLAlchemy 2.0 APIs for robust queries.
• Migrations with Alembic: Manage schema changes safely over time.
• Use Case: Build a FastAPI/Flask/Django app with complex relationships and migrations.

Quick Start

Install SQLAlchemy, define your models, create an engine and session, and perform queries with modern patterns.