SQLModel Models & Sessions Skill

What problem does it solve?

This skill helps developers model data with SQLModel and orchestrate asynchronous sessions for Neon PostgreSQL in FastAPI projects, reducing boilerplate and maintenance overhead.

Core Features & Use Cases

• Define SQLModel models with table=True (User, Task) and establish relationships (User has many Tasks) with proper foreign keys (user_id).
• Setup asynchronous engines and sessions using create_async_engine and AsyncSession for non-blocking database access.
• Implement dependency injection via a get_session-like pattern to provide a session to FastAPI routes.
• Optimize performance with indexing on frequently queried fields (e.g., user_id, email).

Quick Start

Provide a minimal example that defines models, creates an async engine, and shows a FastAPI route using Depends(get_session) to operate on Task/User models.