Sqlalchemy Orm
This gives Claude the modern SQLAlchemy 2.0 API patterns, including the newer Mapped type hints and select() syntax instead of the old Query interface. You'll want this when building database-backed Python apps, especially with FastAPI or Flask where you need clean ORM patterns and relationship handling. The skill covers declarative models, proper eager loading to avoid N+1 queries, and session management with dependency injection. It's focused on the 2.x way of doing things, which matters because the API changed significantly from 1.x. Solid reference if you're tired of looking up whether it's selectinload or joinedload this time.
- skills.sh installs
- 873
- GitHub stars
- 79
- last updated
- Aug 21, 2026
Install
$ npx -y skills add bobmatnyc/claude-mpm-skills --skill sqlalchemy-orm --agent claude-codeInstalls into .claude/skills of the current project.
Files
This gives Claude the modern SQLAlchemy 2.0 API patterns, including the newer Mapped type hints and select() syntax instead of the old Query interface. You'll want this when building database-backed Python apps, especially with FastAPI or Flask where you need clean ORM patterns and relationship handling. The skill covers declarative models, proper eager loading to avoid N+1 queries, and session management with dependency injection. It's focused on the 2.x way of doing things, which matters because the API changed significantly from 1.x. Solid reference if you're tired of looking up whether it's selectinload or joinedload this time.
Browse the repository on GitHubSponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/bobmatnyc/claude-mpm-skills
- Categories
- Backend & APIs, Python, Databases
- First seen
- Apr 16, 2026
More from bobmatnyc/claude-mpm-skills
All 158- Github Actions771
- Nodejs Backend Typescript745
- Cypress664
- Session Compression664
- Opentelemetry647
- Hono Cloudflare639
- Wordpress Security Validation618
- Xlsx599
- Tanstack Query595
- Fastify582
- Api Design Patterns579
- Skill Creator569
- Git Workflow568
- Express Production519
- Golang Grpc518
- Axum500
- Hono Core500
- Zustand496
- Asyncio494
- Mcp Protocol Builder491
- Typescript Core487
- Bug Fix482
- Supabase Backend Platform482
- Mypy478
Recommended
More Backend & APIs
encore-databaseencoredev/skillsWork with PostgreSQL in Encore.ts using `SQLDatabase` from `encore.dev/storage/sqldb` — schema migrations and SQL queries.842skills.sh installs
backend-to-frontend-handoff-docssoftaworks/agent-toolkitCreate API handoff documentation for frontend developers. Use when backend work is complete and needs to be documented for frontend integration, or user says 'c821skills.sh installs
clerk-authenticationmindrally/skillsGuidelines for implementing Clerk authentication in Next.js applications with middleware, hooks, and security best practices707skills.sh installs
api-test-suite-builderalirezarezvani/claude-skillsUse when the user asks to generate API tests, create integration test suites, test REST endpoints, or build contract tests.677skills.sh installs
gemini-managed-agents-apigoogle/skillsManages custom Agent resources on Gemini Enterprise Agent Platform. Use when the user wants to programmatically create, configure, list, update, or delete state673skills.sh installsencore-go-databaseencoredev/skillsWork with PostgreSQL in Encore Go using `sqldb.NewDatabase` from `encore.dev/storage/sqldb` — schema migrations and SQL queries.595skills.sh installs