Specx Sqlalchemy Migrations

Add or repair Alembic migrations for specx SQLAlchemy services. Use when adding SQLAlchemy models or repositories, replacing metadata.create_all schema bootstraps, creating async Alembic env.py, adding migration Makefile targets, generating initial revisions, or testing migration drift.

198 stars 33 forksTesting & QA

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add maksimzayats/specx --skill specx-sqlalchemy-migrations
Manual install
git clone --depth 1 https://github.com/maksimzayats/specx.git /tmp/specx
mkdir -p ~/.claude/skills
cp -r /tmp/specx/.agents/skills/specx-sqlalchemy-migrations ~/.claude/skills/specx-sqlalchemy-migrations

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# specx SQLAlchemy Migrations

Use this skill whenever a specx project has SQLAlchemy models or persistence
adapters. Read `references/alembic.md` before editing migration files.

## Workflow

1. Add `alembic>=1.18.5` as a runtime dependency when SQLAlchemy adapters
   exist, together with SQLAlchemy's asyncio extra and the selected driver.
2. Add `alembic.ini`, `migrations/env.py`, `migrations/script.py.mako`, and
   `migrations/versions/`.
3. Use Alembic's async pattern for async SQLAlchemy engines.
4. Put app-wide SQLAlchemy settings/session factory under top-level
   `infrastructure/sqlalchemy/`.
5. Keep scope-owned ORM models and repositories under
   `core/<scope>/infrastructure/sqlalchemy/`.
6. Add a project-local SQLAlchemy declarative base under
   `src/<package>/foundation/sqlalchemy_model.py`; do not use shared packaged
   metadata for generated services.
7. Put reusable model discovery under top-level
   `infrastructure/sqlalchemy/model_discovery.py`. Use that same function from
   `migrations/env.py` and its guardrail test before assigning
   `target_metadata`; do not duplicate discovery or maintain hard-coded model
   module names.
8. Set `target_metadata` to the project-local `BaseSQLAlchemyModel.metadata`.
9. Generate or hand-review an initial migration for current models.
10. Add `make migrate` and `make makemigrations`.
11. Add tests that run `alembic upgrade head` against an isolated database,
Read the full skill on GitHub

Details

Skill name
specx-sqlalchemy-migrations
Path
.agents/skills/specx-sqlalchemy-migrations/SKILL.md
License
MIT
Repo updated
8 August 2026

FAQ

What does the Specx Sqlalchemy Migrations skill do?

Add or repair Alembic migrations for specx SQLAlchemy services. Use when adding SQLAlchemy models or repositories, replacing metadata.create_all schema bootstraps, creating async Alembic env.py, adding migration Makefile targets, generating initial revisions, or testing migration drift.

How do I install the Specx Sqlalchemy Migrations skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add maksimzayats/specx --skill specx-sqlalchemy-migrations. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Specx Sqlalchemy Migrations popular?

It lives in maksimzayats/specx, which has 198 GitHub stars and 33 forks.

Related skills

Specx Add Core Service

198

maksimzayats/specx

Add or refactor a specx core scope service. Use when implementing focused reusable business/application behavior under a core scope services package, extracting logic from a use case, injecting deterministic collaborators, accepting an active unit of work, choosing between Service and Capability, or keeping business decisions away from delivery and infrastructure.

Marketing, Sales & Business33

Specx Add Core Use Case

198

maksimzayats/specx

Add or refactor a specx core scope use case. Use when implementing an externally meaningful application action under a core scope use_cases package, adding same-file command/query inputs, result DTOs, coordinating services, opening a unit-of-work transaction, or moving behavior out of delivery or infrastructure into class-based application code.

Software Development33

Specx Add Delivery Controller

198

maksimzayats/specx

Add delivery controllers for specx services, especially FastAPI HTTP routes. Use when creating top-level `delivery/` request/response schemas, one controller per scoped use-case set, route registration, FastAPI lifecycle managers, HTTP error translation, delivery-only auth/rate-limit/request services, or integration tests that exercise the delivery edge.

Software Development33

Specx Tests

198

maksimzayats/specx

Add or refine tests for specx Python services. Use when creating unit tests for use cases/services, integration tests for FastAPI controllers or infrastructure adapters, e2e smoke tests, architecture import guardrails, DI override tests, pytest fixtures, or coverage and boundary checks.

Testing & QA33

Specx Project Tooling

198

maksimzayats/specx

Add strict Python project tooling for a specx service. Use when creating or updating `pyproject.toml`, `uv` dependency groups and lock checks, Ruff formatting and linting, mypy strict mode, pytest and HTTPX2 test configuration, Makefile commands, root `AGENTS.md` command guidance, or CI-like local guardrails.

Testing & QA33

Hare Lang

293

mohitmishra786/low-level-dev-skills

Hare language skill for simple systems programming. Use when building with hare build/test/run, Hare stdlib, C FFI with @extern, tagged union error handling, or comparing Hare vs C/Zig. Activates on queries about Hare language, hare build, @extern, tagged union, or Hare stdlib.

Testing & QA36

Browse the most popular Claude skills, all testing & qa skills, or write your own with the skills generator.