advanced-alchemy

Provides expert patterns for Advanced Alchemy and SQLAlchemy ORM development.

15|4|Updated Jan 20, 2026

Search Tags:#database #python #orm #repository pattern #sqlalchemy #service pattern #advanced alchemy

Ready to run

npx skills add https://github.com/cofin/flow --skill advanced-alchemy

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: advanced-alchemy
Source: https://github.com/cofin/flow/tree/main/skills/advanced-alchemy
Command: npx skills add https://github.com/cofin/flow --skill advanced-alchemy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides expert guidance and patterns for efficiently working with Advanced Alchemy and SQLAlchemy ORM, streamlining database interactions and model management.

Core Features & Use Cases

Model Definitions: Demonstrates best practices for defining models with audit fields, PII tracking, and relationships.
Service Layer: Implements robust service patterns for CRUD operations, authentication, and custom business logic.
Database Migrations: Offers commands for generating, upgrading, and downgrading database schemas.
Use Case: When building a new feature that requires complex user authentication and data management, consult this Skill for pre-built, efficient patterns for your models and services.

Quick Start

Use the advanced-alchemy skill to generate a new database migration.

Frequently Asked Questions about advanced-alchemy

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I implement the repository and service pattern in SQLAlchemy?▼

The repository and service pattern in SQLAlchemy separates business logic from data access. This Skill provides expert guidance for implementing robust service patterns for CRUD operations, authentication, and custom business logic.

What's the best way to define SQLAlchemy ORM models with audit fields?▼

Defining SQLAlchemy ORM models with audit fields follows best practices demonstrated by this Skill, which covers model definitions, PII tracking, and relationship management for Advanced Alchemy.

How do I generate and apply database migrations with SQLAlchemy?▼

Database migrations with SQLAlchemy are handled through commands for generating, upgrading, and downgrading database schemas. This Skill offers the necessary commands and patterns to manage schema evolution.

Does Advanced Alchemy support multiple database backends?▼

Advanced Alchemy supports multiple database backends and framework integrations. This Skill provides expert patterns for model definitions and service layer implementation across different database environments.

How do I handle exceptions in a SQLAlchemy service layer?▼

Exception handling in a SQLAlchemy service layer is streamlined using this Skill's expert patterns, which cover custom types, service layer implementation, and robust database interaction management.