Manage PostgreSQL database interactions with SQLAlchemy 2.x ORM models and queries.
npx skills add https://github.com/boludo00/bookkeep --skill sqlalchemy
Please help me install this Agent Skill. Skill: sqlalchemy Source: https://github.com/boludo00/bookkeep/tree/main/.claude/skills/sqlalchemy Command: npx skills add https://github.com/boludo00/bookkeep --skill sqlalchemy
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.
Define a new Book model in backend/app/models.py with title, author, and publication_year fields.
High-intent search queries and answers about installing and using this skill.
To define SQLAlchemy models, you create Python classes representing database tables with mapped columns and relationships. This Skill handles model definition for PostgreSQL and SQLite, allowing you to structure data storage and manage schemas efficiently.
Managing database sessions with FastAPI dependency injection involves injecting synchronous SQLAlchemy sessions into route functions. This Skill supports effective session handling and lifecycle management, ensuring database connections are properly opened and closed per request.
Optimizing SQLAlchemy queries with eager loading fetches related objects in a single query to prevent N+1 problems. This Skill facilitates query optimization by supporting eager loading and filtering when retrieving related ORM data.
Yes, this SQLAlchemy ORM approach works with both PostgreSQL and SQLite. The Skill manages database interactions synchronously, supporting seamless transitions between different database backends within your FastAPI application architecture.
Performing CRUD operations using SQLAlchemy 2.x involves using ORM queries and synchronous sessions to create, read, update, and delete records. This Skill facilitates these operations and handles session management for your backend application.
Using synchronous SQLAlchemy sessions instead of async ensures compatibility with specific ORM features and existing codebases. This Skill supports synchronous sessions with FastAPI dependency injection to manage database operations stably.
project-axManage SQLite and PostgreSQL connections for AX applications via a unified factory.
SalmanferozkhanAutomate SQLModel data modeling and FastAPI integration with CRUD operations and Alembic migrations.
JonathanMitchell1234Develop FastAPI Python APIs with Pydantic validation and SQLAlchemy integration.
manastalukdarAnalyze and optimize SQL/NoSQL queries with N+1 detection and index recommendations.
