sqlalchemy

What problem does it solve?

This Skill simplifies the process of interacting with your PostgreSQL database by providing tools to define models, write efficient queries, and manage database operations within the Bookkeep backend.

Core Features & Use Cases

• Model Definition: Create and manage SQLAlchemy ORM models for your database tables.
• Query Optimization: Write efficient queries with eager loading and filtering.
• Session Management: Handle database sessions effectively using FastAPI dependency injection.
• Use Case: When you need to add a new feature that requires storing new types of data, use this Skill to define the corresponding SQLAlchemy model and integrate it into your API.

Quick Start

Define a new Book model in backend/app/models.py with title, author, and publication_year fields.