Streamlines database schema design, Alembic migrations, and PostgreSQL query optimization for coffee roasting management systems.
This skill provides specialized capabilities for managing the database layer of 'TheMoon' coffee roasting tool, specifically optimized for PostgreSQL 15 and SQLAlchemy 2.0. It facilitates precise schema design following strict naming conventions, automates migration workflows using Alembic, and offers performance tuning strategies like indexing and eager loading. Whether you need to implement FIFO inventory logic or resolve complex N+1 query issues, this skill ensures robust, scalable data modeling and efficient database interactions.
주요 기능
010 GitHub stars
02Pre-configured patterns for FIFO inventory and stock aggregation
03Query optimization techniques for N+1 problems and bulk operations
04Standardized SQLAlchemy 2.0 model templates and naming conventions
05Advanced PostgreSQL index strategies including composite and partial indexes
06Automated Alembic migration workflows and revision management
사용 사례
01Designing and creating new database schemas for roasting logs and inventory
02Executing and rolling back database migrations during development cycles
03Optimizing slow-running SQL queries through execution plan analysis
