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

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add wispbit-ai/skills --skill sqlalchemy-alembic-expert-best-practices-code-review
Manual install
git 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-review

Personal 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
Read the full skill on GitHub

Details

Skill name
sqlalchemy-alembic-expert-best-practices-code-review
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

9

wispbit-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.

Software Development

Postgresql Expert Best Practices Code Review

9

wispbit-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.

Software Development

Python Expert Best Practices Code Review

9

wispbit-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.

Software Development

Super Bill Software

9

Magical-Bear/BillUserManualSkills

super-bill 软件领域 Skill。用于产品场景、Web、API、异步 Python、数据库、报表、ECharts、前端和软件测试设计;必须由 super-bill 主 Skill 的需求、架构、分支和验收门禁编排。

Software Development

Rust Expert Best Practices Code Review

9

wispbit-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.

Software Development

Webcrack Deobfuscate

10

iceman1001/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

Software Development

Browse the most popular Claude skills, all software development skills, or write your own with the skills generator.