Sqlalchemy Orm
技能 警告 活跃SQLAlchemy Python SQL toolkit and ORM with powerful query builder, relationship mapping, and database migrations via Alembic
To serve as a detailed reference and guide for developers using SQLAlchemy in Python applications, covering its ORM capabilities, query building, relationship mapping, and database migration strategies.
功能
- SQLAlchemy 2.0 modern API with type hints
- Declarative model definition and relationships
- Database engine and session configuration
- Advanced query patterns with joins and eager loading
- CRUD operations with examples
- Async SQLAlchemy setup and operations
- Alembic migration setup and usage
- FastAPI integration patterns
- Testing strategies with Pytest
- Performance optimization techniques
使用场景
- Learning and implementing SQLAlchemy ORM in new Python projects.
- Refactoring existing applications to use modern SQLAlchemy 2.0 patterns.
- Setting up database migrations with Alembic for schema management.
- Integrating SQLAlchemy with web frameworks like FastAPI, Flask, or Django.
- Writing complex SQL queries and managing relationships effectively.
非目标
- Providing a full-fledged ORM itself, but rather documenting how to use SQLAlchemy.
- Handling database administration tasks beyond schema migrations.
- Replacing specific database drivers (e.g., psycopg2), but documenting how to use them with SQLAlchemy.
Maintenance
- critical:Commit recencyThe last commit was on 2026-04-15, over 30 days ago, indicating potential unmaintenance given the current date of 2026-05-13.
Trust
- warning:Issues AttentionIn the last 90 days, 4 issues were opened and 0 were closed, indicating slow or no maintainer response to open issues.
安装
npx skills add bobmatnyc/claude-mpm-skills通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。
质量评分
警告类似扩展
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Django Expert
99Use when building Django web applications or REST APIs with Django REST Framework. Invoke when working with settings.py, models.py, manage.py, or any Django project file. Creates Django models with proper indexes, optimizes ORM queries using select_related/prefetch_related, builds DRF serializers and viewsets, and configures JWT authentication. Trigger terms: Django, DRF, Django REST Framework, Django ORM, Django model, serializer, viewset, Python web.
Pydantic Validation
99Python data validation using type hints and runtime type checking with Pydantic v2's Rust-powered core for high-performance validation in FastAPI, Django, and configuration management.
Senior Fullstack
99Fullstack development toolkit with project scaffolding for Next.js, FastAPI, MERN, and Django stacks, code quality analysis with security and complexity scoring, and stack selection guidance. Use when the user asks to "scaffold a new project", "create a Next.js app", "set up FastAPI with React", "analyze code quality", "audit my codebase", "what stack should I use", "generate project boilerplate", or mentions fullstack development, project setup, or tech stack comparison.
Python Best Practices
99Python/FastAPI coding standards including async patterns, Pydantic v2, SQLAlchemy 2.0, and project structure. Use when writing Python code, reviewing FastAPI projects, or learning FastAPI conventions.
Celery
98Distributed task queue system for Python enabling asynchronous execution of background jobs, scheduled tasks, and workflows across multiple workers with Django, Flask, and FastAPI integration.