Does it handle database-specific features?

Yes, it includes patterns for database-specific dialects, such as PostgreSQL upserts (on_conflict_do_update) and advanced JSON column querying.

How does this skill improve database performance?

By providing optimized query patterns, efficient session lifecycle management, and clear relationship mapping, it helps prevent common issues like N+1 queries and session leaks.

Can I use this for both sync and async Python code?

The skill provides patterns for standard synchronous operations and includes references for implementing optimized asynchronous SQLAlchemy workflows.

What version of SQLAlchemy does this skill support?

This skill specifically targets SQLAlchemy 2.0 and later, utilizing modern features like DeclarativeBase and Mapped types for enhanced type safety.

SQLAlchemy ORM Patterns

Name: SQLAlchemy ORM Patterns
Author: martinffx

bymartinffx

•

データベース管理

Implements modern SQLAlchemy 2.0+ patterns for robust Python database modeling and optimized query execution.

This skill equips Claude with specialized knowledge for architecting database layers using SQLAlchemy 2.0+, emphasizing type-safe Declarative mapping and optimized query patterns. It provides immediate access to production-ready templates for session management, complex relationships, and advanced database operations like upserts and JSON column filtering. By applying these patterns, developers can ensure their Python applications maintain high code quality, performance, and maintainability when interacting with relational databases.

主な機能

016 GitHub stars

02SQLAlchemy 2.0 Declarative Mapping with type-safe Mapped columns

03Modern relationship mapping using back_populates and type hints

04PostgreSQL-specific upsert logic and JSON column manipulation

05Advanced query patterns including scalar fetching and filtering

06Best-practice session management and engine configuration

ユースケース

01Refactoring legacy SQLAlchemy 1.x codebases to modern 2.0 standards

02Building robust data persistence layers for FastAPI or Flask applications

03Implementing complex data structures with relational mapping and JSON storage

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add martinffx/claude-code-atelier atelier-python-sqlalchemy

For use in Claude.ai and ChatGPT

Download Skill