Sqlalchemy Alembic Expert Best Practices Code Review
SQLAlchemy ORM and Alembic migration best practices for building safe, performant database schemas. This skill should be used when writing, reviewing, or refactoring SQLAlchemy models, Alembic migrations, or database query patterns. Triggers on tasks involving SQLAlchemy ORM, Alembic migrations, database schema changes, or query optimization.
Install
npx skills add wispbit-ai/skills --skill sqlalchemy-alembic-expert-best-practices-code-reviewgit clone --depth 1 https://github.com/wispbit-ai/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/skills/sqlalchemy-alembic-expert-best-practices-code-review ~/.claude/skills/sqlalchemy-alembic-expert-best-practices-code-reviewPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# SQLAlchemy & Alembic Expert Best Practices Simple, pragmatic, opinionated. Only what matters for writing production-grade SQLAlchemy and Alembic code. ## When to Apply Reference these guidelines when: - Writing Alembic migrations for schema changes - Creating or modifying SQLAlchemy models - Adding indexes, constraints, or foreign keys via Alembic - Reviewing database migration code for safety - Refactoring existing database schemas - Optimizing query patterns or database performance ## Rule Categories by Priority | Priority | Category | Impact | Prefix | |----------|----------|--------|--------| | 1 | Index Management | CRITICAL-HIGH | `only-concurrent-indexes`, `verify-query-patterns-are-indexed` | | 2 | Constraint Safety | HIGH | `unique-constraint`, `split-foreign-key`, `change-column-type` | | 3 | Optimization | MEDIUM | `split-check-constraint`, `limit-non-unique-index` | | 4 | Index Efficiency | LOW | `ensure-index-not-covered` | ## Quick Reference - `only-concurrent-indexes` - Always use `postgresql_concurrently=True` with autocommit blocks for index operations - `verify-query-patterns-are-indexed` - Ensure SQLAlchemy queries have appropriate indexes defined - `unique-constraint` - Split unique constraint creation into concurrent index + constraint steps - `split-foreign-key` - Add foreign keys with `NOT VALID` first, then validate separately - `change-column-type` - Use multi-step approach for column type changes to avoid table locks
Details
- Skill name
sqlalchemy-alembic-expert-best-practices-code-review- Repository
- wispbit-ai/skills
- Path
skills/sqlalchemy-alembic-expert-best-practices-code-review/SKILL.md- Repo updated
- 11 February 2026
FAQ
What does the Sqlalchemy Alembic Expert Best Practices Code Review skill do?
SQLAlchemy ORM and Alembic migration best practices for building safe, performant database schemas. This skill should be used when writing, reviewing, or refactoring SQLAlchemy models, Alembic migrations, or database query patterns. Triggers on tasks involving SQLAlchemy ORM, Alembic migrations, database schema changes, or query optimization.
How do I install the Sqlalchemy Alembic Expert Best Practices Code Review skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add wispbit-ai/skills --skill sqlalchemy-alembic-expert-best-practices-code-review. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Sqlalchemy Alembic Expert Best Practices Code Review popular?
It lives in wispbit-ai/skills, which has 9 GitHub stars and 0 forks.
Related skills
Graphql Expert Best Practices
9wispbit-ai/skills
GraphQL performance optimization and best practices for building scalable APIs. This skill should be used when writing, reviewing, or refactoring GraphQL schemas, resolvers, or query execution code. Triggers on tasks involving GraphQL APIs, resolver optimization, query performance, or data fetching patterns.
Postgresql Expert Best Practices Code Review
9wispbit-ai/skills
PostgreSQL database design, migration, and performance optimization best practices. This skill should be used when writing, reviewing, or refactoring database schemas, migrations, or query patterns. Triggers on tasks involving PostgreSQL databases, schema design, migration optimization, or data modeling.
Python Expert Best Practices Code Review
9wispbit-ai/skills
Python best practices for writing production-grade code. This skill should be used when writing, reviewing, or refactoring Python code. Triggers on tasks involving Python development, error handling patterns, dictionary operations, and code quality improvements.
Super Bill Software
9Magical-Bear/BillUserManualSkills
super-bill 软件领域 Skill。用于产品场景、Web、API、异步 Python、数据库、报表、ECharts、前端和软件测试设计;必须由 super-bill 主 Skill 的需求、架构、分支和验收门禁编排。
Rust Expert Best Practices Code Review
9wispbit-ai/skills
Rust best practices and code quality guidelines for writing idiomatic, safe, and performant Rust code. This skill should be used when writing, reviewing, or refactoring Rust code. Triggers on tasks involving Rust programming, code review, error handling, type safety, or performance optimization.
Webcrack Deobfuscate
10iceman1001/awesome_rfid_claude_skills
Run the webcrack CLI on JavaScript files to deobfuscate, unminify, and unbundle them BEFORE reading or analyzing them. Use this skill any time the user provides a `.js`, `.mjs`, or `.cjs` file and wants Claude to read, analyze, explain, audit, modify, reverse-engineer, debug, or understand it — especially if the file appears minified, bundled (webpack/browserify/rollup/parcel), or obfuscated (obfuscator.io, string arrays, control-flow flattening, hex identifiers like `_0xabc123`). Trigger this skill even when the user does NOT explicitly say "deobfuscate" — the goal is that Claude is always re
Browse the most popular Claude skills, all software development skills, or write your own with the skills generator.