skills.rest
martinffx
martinffxCOMMUNITY
Explore all skills by this author →
Website𝕏@martinffxGitHub

python:sqlalchemy

Provide SQLAlchemy 2.0+ ORM patterns for Python database access.

39|4|Updated Jan 11, 2026
Search Tags:#database#python#patterns#orm#declarative#sqlalchemy#relationships
One-click install
npx skills add https://github.com/martinffx/claude-code-atelier --skill python-sqlalchemy
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: python:sqlalchemy
Source: https://github.com/martinffx/claude-code-atelier/tree/main/plugins/atelier-python/skills/atelier-python-sqlalchemy
Command: npx skills add https://github.com/martinffx/claude-code-atelier --skill python-sqlalchemy

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

SQLAlchemy ORM patterns for Python provide practical patterns to model data, query efficiently, and manage sessions, upserts, and JSON columns in modern applications. This guide helps teams enforce consistent data access practices and reduce boilerplate across services.

Core Features & Use Cases

  • Declarative modeling and relationships to express data structures clearly.
  • Session management and transactional operations for safe data modifications.
  • Upsert handling, advanced querying, and JSON column usage for complex data stores.
  • Use Case: Building a Python service with a PostgreSQL database, adopt these patterns to define models, queries, and data access layers.

Quick Start

Adapt the sample models and queries to your own database schema to start using SQLAlchemy ORM patterns.

Frequently Asked Questions about python:sqlalchemy

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

FAQPage Schema
How do I define declarative models and relationships in SQLAlchemy 2.0?▼

Declarative models in SQLAlchemy 2.0 are defined using the declarative base pattern to express data structures clearly, establishing relationships between tables to map Python classes directly to database schemas for real-world projects.

What is the best way to manage sessions and transactions for database modifications?▼

Session management in SQLAlchemy handles transactional operations for safe data modifications by maintaining unit-of-work boundaries, ensuring database integrity during commits and rollbacks in both synchronous and asynchronous contexts.

How do I perform upsert operations and use JSON columns in SQLAlchemy?▼

Upsert handling and JSON column usage in SQLAlchemy support complex data stores by allowing insert-or-update logic and semi-structured data storage, enabling efficient querying within modern PostgreSQL database services.

Does SQLAlchemy ORM guidance apply to asynchronous Python database access?▼

Yes, SQLAlchemy ORM patterns apply to asynchronous Python database access, offering code references and practical guidance for both synchronous and asynchronous contexts using SQLAlchemy 2.0+ APIs.

Why adopt pattern-based SQLAlchemy ORM guidance for Python services?▼

Pattern-based SQLAlchemy ORM guidance helps teams enforce consistent data access practices and reduce boilerplate across services, providing practical patterns to model data, query efficiently, and manage sessions.

Related Skills

Explore More Software Engineering Skills→
jota-batutajota-batuta

sqlalchemy-models

Generate SQLAlchemy models and database infrastructure from structured data model descriptions.

Community
Advanced
onlyspansonlyspans

golang-database-patterns

Implement Go database integration patterns with sqlx, pgx, and golang-migrate.

Official
Advanced
nguyenthienthanhnguyenthienthanh
24

python-expert

Apply expert Python backend patterns to Django, FastAPI, Flask, and async projects.

Community
Advanced
isharoverwhiteisharoverwhite
13

sqlalchemy-orm

Implement SQLAlchemy 2.0 ORM models for Python database operations.

Community
Intermediate