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

alembic — Claude Code skill: database migrations

A skill that walks your agent through Alembic migrations on SQLAlchemy projects, from alembic init to production rollout and rollback.

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

What alembic does

The skill covers the whole Alembic loop: hand-written revisions and --autogenerate, data migrations during schema changes, and the path from dev to staging to production. It ships code samples for env.py, pulling DATABASE_URL from environment variables, and adding columns and indexes to a tickets table.

Autogenerate gets its own section. The agent will flag that the output needs a human pass: a renamed column shows up as a drop plus an add, a type change needs data conversion, and complex constraints and data migrations never make it into the generated file. That is the reason not to run alembic upgrade head right after generating.

Dependencies are alembic>=1.13.0, sqlalchemy>=2.0.0, psycopg2-binary>=2.9.0 and pytest>=7.0.0. The examples assume PostgreSQL and support-desk tables: tickets, satisfaction ratings, schema versioning. On another database engine you will rewrite the connection setup.

What it helps with

  • write an Alembic revision for a new column on the tickets table
  • backfill data when a column type or value set changes
  • roll back a failed migration in production
  • read the connection string from environment variables
  • review an autogenerated revision before deploy

Example prompts for the agent

  • create an Alembic migration for a priority column on tickets
  • write a data migration that maps old ticket statuses to the new enum
  • review this autogenerated revision and tell me what it missed

How to install alembic

1Skills CLI (Vercel)

npx skills add manutej/luxor-claude-marketplace --skill alembic -a claude-code

2Manually: put the files in place

~/.claude/skills/alembic/SKILL.md

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

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

Questions about alembic

How do I install the alembic skill in Claude?

Run npx skills add manutej/luxor-claude-marketplace --skill alembic -a claude-code. The skill then lives at ~/.claude/skills/alembic/SKILL.md.

What does the alembic skill do?

It guides the agent through writing and checking Alembic migrations: revisions, data migrations, rollbacks and production deploys. It targets PostgreSQL and support systems.

What do I need to run it?

The packages alembic>=1.13.0, sqlalchemy>=2.0.0, psycopg2-binary>=2.9.0 and pytest>=7.0.0. The connection examples assume PostgreSQL.

Similar skills

All skills for Data and databases →
neon-postgres neondatabase This skill guides agents through Neon Postgres connections, schema changes, branching, and database checks. Use it when working with an existing schema or DATABASE_URL. CX Codex +1 281,100installs databases mrgoonie A skill that bundles MongoDB and PostgreSQL references: schemas, queries, indexes, migrations, backups and admin tasks. CX Codex +1 435installs neon-postgres-branches neondatabase Selects and provisions Neon database branches through the CLI or MCP server. Built for validating migrations on real data and isolating staging environments. CX Codex +1 31,200installs database-migrations affaan-m A skill that spells out safe, reversible schema changes: expand-contract renames, concurrent indexes, batched backfills, plus workflows for PostgreSQL, Prisma, Drizzle, Kysely, Django and golang-migrate. CX Codex +1 5,200installs planetscale-schema-recommendations-agent-loop planetscale Turns open PlanetScale schema recommendations into a plan, issue, branch or PR. It never applies production changes on its own. CX Codex +1 1,800installs

From the same set31

jest-react-testing A skill for testing React components and hooks with Jest and React Testing Library: config, mocks, async patterns. CX Codex +1 1,200installs ui-design-patterns A reference on common interface patterns: navigation, forms, data display, feedback and accessibility. Useful when you design components or audit an existing UI. CX Codex +1 853installs ux-principles Gives your coding agent usability heuristics, user research methods and accessibility checks, so interface work follows known rules instead of guesswork. CX Codex +1 836installs frontend-architecture A skill for planning frontend structure: layers, patterns, state management and module boundaries. Useful once an app outgrows a flat folder of components. CX Codex +1 722installs wireframing A skill for interface design work: it walks from rough sketches and screen structure to a layout close to the final design. CX Codex +1 566installs expressjs-development A skill that feeds your coding agent Express.js patterns: routing, middleware, request and response handling, error handling. CX Codex +1 555installs mobile-design A skill for mobile interfaces: touch targets, gestures, thumb zones, safe areas and mobile-first layout for small screens. CX Codex +1 545installs figma-design A Figma skill covering components, auto layout, variables, prototyping and plugin development. Useful when the agent writes plugin code or builds a design system. CX Codex +1 542installs

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