sqlmodel-db

What problem does it solve?

This Skill provides ready-to-use SQLModel model definitions and asynchronous session management for Neon PostgreSQL, enabling faster scaffolding of FastAPI apps with clean separation between models and data access.

Core Features & Use Cases

• SQLModel models: Define User and Task models with table=True and well-structured fields.
• Relationship mapping: One-to-many relationship where a User has many Tasks with a foreign key to user_id.
• Async DB access: Async engine creation and session management via create_async_engine and AsyncSession for non-blocking operations.
• Dependency injection: A get_session dependency to provide database sessions to FastAPI routes.
• Performance: Indexed fields (e.g., user_id, email) to optimize common queries in user-task workflows.

Quick Start

Define the User and Task models using SQLModel, configure an async engine with DATABASE_URL, implement get_session, and wire these into a FastAPI route that creates a new task for a user.