Skip to main content
affpapa.org
RU EN
skill CX Codex

SQLAlchemy ORM Expert — Claude Code skill: models and queries

A SQLAlchemy 2.0+ skill for customer support backends: ticket models, sessions, async queries and PostgreSQL. Useful when you build on FastAPI.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add manutej/luxor-claude-marketplace --skill sqlalchemy-orm-expert -a claude-code
npx skills add manutej/luxor-claude-marketplace --skill sqlalchemy -a claude-code
Open on GitHub

What SQLAlchemy ORM Expert does

The skill walks through data models for a support system: users, tickets, comments, attachments, tags. Declarative mapping with type hints, enums for status and priority, soft delete via deleted_at, one-to-many and many-to-many relationships through an association table. Every piece comes with code the agent can drop into your project.

Sessions, query optimisation, async operations and PostgreSQL integration follow. FastAPI, Flask and Django are listed as supported frameworks. Async needs asyncpg; synchronous PostgreSQL access uses psycopg2-binary, migrations run on alembic, tests on pytest and pytest-asyncio. SQLAlchemy itself must be 2.0 or newer — the Mapped and mapped_column examples break on 1.x.

The examples target support workflows: ticket handling, authentication, bulk data operations, reporting, audit trails. On an unrelated project you can still reuse the patterns, but the model layout will need rework.

What it helps with

  • model tickets, users and comments in one place
  • wire up relationships without hand-written joins
  • move sync queries to async under FastAPI
  • speed up heavy PostgreSQL selects
  • add soft delete and an audit trail

Example prompts for the agent

  • Write User, Ticket and Comment models with SQLAlchemy 2.0 type annotations
  • Rewrite this query as an async session with asyncpg
  • Check my model relationships and tell me where selectinload belongs

How to install SQLAlchemy ORM Expert

1Skills CLI (Vercel)

npx skills add manutej/luxor-claude-marketplace --skill sqlalchemy-orm-expert -a claude-code
npx skills add manutej/luxor-claude-marketplace --skill sqlalchemy -a claude-code

2Manually: put the files in place

~/.claude/skills/sqlalchemy/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/sqlalchemy/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about SQLAlchemy ORM Expert

How do I install SQLAlchemy ORM Expert in Claude?

Run npx skills add manutej/luxor-claude-marketplace --skill sqlalchemy-orm-expert -a claude-code, then npx skills add manutej/luxor-claude-marketplace --skill sqlalchemy -a claude-code. The skill file lands at ~/.claude/skills/sqlalchemy/SKILL.md.

What does SQLAlchemy ORM Expert do?

It gives the agent ready patterns for models, sessions and queries in SQLAlchemy 2.0+ support systems. Async operations and PostgreSQL integration get their own sections.

What dependencies does the skill need?

sqlalchemy>=2.0, asyncpg, psycopg2-binary, alembic, pytest and pytest-asyncio. FastAPI, Flask and Django are listed as supported frameworks.

Similar skills

All skills for Data and databases →
sqlalchemy sanjeed5 A Cursor rule that keeps Python database code on SQLAlchemy 2.x: typed models, context-managed sessions, select() instead of the legacy Query. ★ 3,579repo stars prisma-orm-setup prisma Walks an AI coding agent through Prisma ORM setup: find the version, connect the database, verify the link. New apps default to Prisma ORM 8. CX Codex +1 67,900installs prisma-postgres prisma A deprecated compatibility name for prisma-postgres-setup. Use it only when explicitly invoked; new projects should select prisma-postgres-setup instead. CX Codex +1 382,300installs prisma-patterns affaan-m Production patterns and schema guidelines for Prisma ORM in TypeScript. Helps write safe queries, transactions, and pagination while avoiding connection pool exhaustion. CX Codex +1 4,500installs drizzle-orm Mindrally A skill that gives your agent Drizzle ORM conventions: schema as code, inferred types, queries and migrations. CX Codex +1 1,000installs django-patterns affaan-m Guides agents on Django and DRF architecture: modular settings, custom user models, and optimized QuerySets without N+1 queries. CX Codex +1 5,200installs

From the same set31

asyncio-concurrency-patterns A skill on Python concurrency: event loops, coroutines, tasks, semaphores and locks. Useful when you are writing an async service or client. CX Codex +1 489installs rust-systems-programming A skill on systems Rust: ownership, borrowing, threads, async, unsafe and performance. Useful when you write low-level code or port C/C++. CX Codex +1 485installs api-gateway-patterns A skill for building API gateways on Kong: routing, rate limiting, auth, load balancing. Useful when your microservices exist but lack a single entry point. CX Codex +1 481installs react-patterns A skill that hands your agent ready React recipes: hooks, component composition, state management and fewer wasted re-renders. CX Codex +1 471installs pandas A skill that brings pandas expertise to support operations: SLA compliance, agent metrics, PostgreSQL pulls. Useful when you need to dig through tickets and build a report. CX Codex +1 469installs database-management-patterns A reference skill for PostgreSQL and MongoDB work: schema design, indexing, transactions, replication and sharding. CX Codex +1 466installs react-development A skill that feeds your coding agent React patterns: components, hooks, state and effects, taken from the official react.dev docs. CX Codex +1 464installs tailwind-css A Tailwind CSS skill covering utility classes, responsive variants, dark mode and production optimization. Handy when you build UI and want to stay in your markup. CX Codex +1 461installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor