SQLAlchemy ORM Expert

Community

Advanced ORM patterns for robust support systems.

Authormanutej
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill teaches advanced SQLAlchemy ORM patterns for customer support systems, including async sessions, complex relationships, and production-grade data pipelines.

Core Features & Use Cases

  • Declarative Models & Relationships: Rich, type-safe data models for tickets, users, comments, and attachments.
  • Async ORM & FastAPI Integration: Async sessions and FastAPI dependencies for scalable apps.
  • Eager Loading & Performance: Efficient data loading to avoid N+1 queries.
  • Bulk Operations & Migrations: Bulk writes and Alembic migrations for evolving schemas.
  • Testing & Type Safety: Pytest fixtures and type hints for reliability.

Quick Start

Define models, create an async session, and perform a simple async query across models.

Dependency Matrix

Required Modules

sqlalchemy>=2.0asyncpgpsycopg2-binaryalembicpytestpytest-asyncio

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: SQLAlchemy ORM Expert
Download link: https://github.com/manutej/luxor-claude-marketplace/archive/main.zip#sqlalchemy-orm-expert

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.