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.
Install
npx skills add maksimzayats/specx --skill specx-sqlalchemy-migrationsgit 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-migrationsPersonal 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,
Details
- Skill name
specx-sqlalchemy-migrations- Repository
- maksimzayats/specx
- 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
198maksimzayats/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.
Specx Add Core Use Case
198maksimzayats/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.
Specx Add Delivery Controller
198maksimzayats/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.
Specx Tests
198maksimzayats/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.
Specx Project Tooling
198maksimzayats/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.
Hare Lang
293mohitmishra786/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.
Browse the most popular Claude skills, all testing & qa skills, or write your own with the skills generator.