Change Database Schema
martin-ueding/geo-activity-playground
How to change the SQLAlchemy data model and generate the matching Alembic migration.
Add technical infrastructure adapters for specx core scopes.
$ npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install maksimzayats/specx specx-add-infrastructure-adapter --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/maksimzayats/specx.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/specx-add-infrastructure-adapter .claude/skills/specx-add-infrastructure-adapter && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "specx-add-infrastructure-adapter" agent skill from https://github.com/maksimzayats/specx/tree/main/skills/specx-add-infrastructure-adapter into .claude/skills/specx-add-infrastructure-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "specx-add-infrastructure-adapter", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/maksimzayats/specx/tree/main/skills/specx-add-infrastructure-adapterType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install maksimzayats/specx specx-add-infrastructure-adapter --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/maksimzayats/specx.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/specx-add-infrastructure-adapter .agents/skills/specx-add-infrastructure-adapter && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "specx-add-infrastructure-adapter" agent skill from https://github.com/maksimzayats/specx/tree/main/skills/specx-add-infrastructure-adapter into .agents/skills/specx-add-infrastructure-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "specx-add-infrastructure-adapter", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install maksimzayats/specx specx-add-infrastructure-adapter --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/maksimzayats/specx.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/specx-add-infrastructure-adapter .cursor/skills/specx-add-infrastructure-adapter && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "specx-add-infrastructure-adapter" agent skill from https://github.com/maksimzayats/specx/tree/main/skills/specx-add-infrastructure-adapter into .cursor/skills/specx-add-infrastructure-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "specx-add-infrastructure-adapter", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/maksimzayats/specx.git --path skills/specx-add-infrastructure-adapter--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install maksimzayats/specx specx-add-infrastructure-adapter --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/maksimzayats/specx.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/specx-add-infrastructure-adapter .gemini/skills/specx-add-infrastructure-adapter && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "specx-add-infrastructure-adapter" agent skill from https://github.com/maksimzayats/specx/tree/main/skills/specx-add-infrastructure-adapter into .gemini/skills/specx-add-infrastructure-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "specx-add-infrastructure-adapter", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install maksimzayats/specx specx-add-infrastructure-adapterInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/maksimzayats/specx.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/specx-add-infrastructure-adapter .github/skills/specx-add-infrastructure-adapter && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "specx-add-infrastructure-adapter" agent skill from https://github.com/maksimzayats/specx/tree/main/skills/specx-add-infrastructure-adapter into .github/skills/specx-add-infrastructure-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "specx-add-infrastructure-adapter", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install maksimzayats/specx specx-add-infrastructure-adapter --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/maksimzayats/specx.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/specx-add-infrastructure-adapter .opencode/skills/specx-add-infrastructure-adapter && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "specx-add-infrastructure-adapter" agent skill from https://github.com/maksimzayats/specx/tree/main/skills/specx-add-infrastructure-adapter into .opencode/skills/specx-add-infrastructure-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "specx-add-infrastructure-adapter", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
specx-add-infrastructure-adapterAdd technical infrastructure adapters for specx core scopes.
Specx Add Infrastructure Adapter is an agent skill from maksimzayats/specx. Add technical infrastructure adapters for specx core scopes. Use when implementing SQLAlchemy repositories and Alembic-backed persistence, Redis stores, HTTP/network clients, file or queue adapters, unit-of-work implementations, gateway implementations for external APIs or SDKs such as OpenAI, or explicit diwire bindings for core scope repository and gateway ports.
Its SKILL.md is about 1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 4 other files, including reference files (for example `agents/openai.yaml` and `references/adapter.md`).
It sits in Databases, covering ORMs and data access and Database migrations. It works with OpenAI, Redis and SQLAlchemy. The repository describes itself as: ⚙️ Executable architecture guardrails and agent skills for building structured Python services! The licence is MIT.
12 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 9362406. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Specx Add Infrastructure Adapter loads about 1k tokens when it runs, and up to ~7.9k if it reads all its reference files. Until then it costs about 101 tokens; SKILL.md has 448 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
The full file from maksimzayats/specx at commit 9362406, republished under its MIT licence (© maksimzayats). 448 words, ~1,000 tokens.
.claude/skills/specx-add-infrastructure-adapter/SKILL.md (or your agent's skills folder). This skill also uses 2 other files; get the full folder from GitHub.Use this skill whenever code talks to external systems. Read
references/adapter.md before writing adapters.
repositories/ for owned persistence.
Repository ports inherit BaseRepository and mark required methods with
@abstractmethod.gateways/ for outbound business
capabilities to external systems such as OpenAI, payments, email, queues, or
external HTTP APIs. Gateway ports inherit BaseGateway, mark required
methods with @abstractmethod, declare external effects, and do not return
entities.core/<scope>/infrastructure/<technology>/.httpx2, imported from the
httpx2 namespace; do not generate new legacy httpx imports.infrastructure/<technology>/, even with only one current consumer.close() method; FastAPI lifecycle owns calling it on shutdown.UnitOfWork and a
UnitOfWorkManager; register the manager, not repositories, active UoWs,
or UoW providers for use-case injection._register_dependencies(...) inside
ioc/container.py. Register every technical resource once at its owner
boundary and close that same app-scoped instance from lifecycle.$specx-sqlalchemy-migrations.Logging is top-level runtime infrastructure, not a core-scope adapter. Put
stdlib logging setup in infrastructure/logging/configurator.py with a
LoggingConfigurator that inherits BaseConfigurator; do not create gateway
ports or injected logger bindings for it.
For /readyz, implement required dependency checks as core/health gateway
adapters, for example
core/health/infrastructure/sqlalchemy/readiness_check_gateway.py, and bind
them to ReadinessCheckGateway in ioc/container.py. Bound every dependency
check with a short application timeout and return only a non-sensitive core
status.
Use blank lines as logical separators in all code. Keep related statements together, but separate independent setup, action, assertion, response, branch, and transformation groups so long blocks stay readable.
references/adapter.md - adapter layout, port binding, SQLAlchemy/UoW, Redis,
HTTP client, migration, and test patterns.© maksimzayats, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 2 other files (references) in skills/specx-add-infrastructure-adapter of maksimzayats/specx.
Open the folder on GitHubat commit 9362406
Specx Add Infrastructure Adapter next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Specx Add Infrastructure Adapter this skillmaksimzayats/specx | 202 | — | ~1k | Automated safety check: Pass | MIT | |
| Change Database Schemamartin-ueding/geo-activity-playground | 100 | — | ~225 | Automated safety check: Pass | Custom licence | |
| Daoyou Data LayerChurchTao/Daoyou | 147 | — | ~1.9k | Automated safety check: Pass | GPL-3.0 | |
| Python Database Patternsaiskillstore/marketplace | 433 | 1 repos | ~1.2k | Automated safety check: Notes | None | |
| Database DevelopmentWrongStack/WrongStack | 371 | — | ~864 | Automated safety check: Pass | MIT | |
| DB Connectionaiskillstore/marketplace | 433 | — | ~3.5k | Automated safety check: Notes | None |
martin-ueding/geo-activity-playground
How to change the SQLAlchemy data model and generate the matching Alembic migration.
ChurchTao/Daoyou
Daoyou Drizzle/PostgreSQL、事务、V6 角色与宗门归属、统一背包、Redis 战局和回放归档指南。Use when modifying schema, migrations, repositories, persistence mappers, resource commits or durable game models.
aiskillstore/marketplace
SQLAlchemy and database patterns for Python. An agent skill from aiskillstore/marketplace.
WrongStack/WrongStack
Implement database access, models and queries with explicit consistency, transactions and bounded results.
aiskillstore/marketplace
A skill your agent uses when setting up database connections, especially for Neon PostgreSQL.
kid-sid/claude-spellbook
A skill your agent uses when using async SQLAlchemy 2.0 — defining models, writing queries, managing async sessions, loading relationships without N+1, or setting up and debugging Alembic migrations.
maksimzayats/specx
Add or refactor a specx core scope service. An agent skill from maksimzayats/specx.
maksimzayats/specx
Add or refactor a specx core scope use case. An agent skill from maksimzayats/specx.
maksimzayats/specx
Add delivery controllers for specx services, especially FastAPI HTTP routes.
maksimzayats/specx
Design or review specx core scope boundaries in Python services.
maksimzayats/specx
Wire dependency injection for a specx Python service with diwire.
maksimzayats/specx
Create or reshape a Python FastAPI service repo into the specx clean core/delivery architecture using packaged scoped foundation bases.
Works with
Categories
Add technical infrastructure adapters for specx core scopes. Specx Add Infrastructure Adapter is an agent skill from maksimzayats/specx. Add technical infrastructure adapters for specx core scopes.
Specx Add Infrastructure Adapter fits situations like: implementing SQLAlchemy repositories and Alembic-backed persistence; HTTP/network clients; unit-of-work implementations; gateway implementations for external APIs.
Run `npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a claude-code`. Or copy the skill folder (skills/specx-add-infrastructure-adapter in maksimzayats/specx) into .claude/skills/specx-add-infrastructure-adapter in your project. Claude Code loads it when a task matches its description.
Run `npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a codex`. Or copy the skill folder (skills/specx-add-infrastructure-adapter in maksimzayats/specx) into .agents/skills/specx-add-infrastructure-adapter in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add maksimzayats/specx --skill specx-add-infrastructure-adapter -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/specx-add-infrastructure-adapter, .gemini/skills/specx-add-infrastructure-adapter, .github/skills/specx-add-infrastructure-adapter and .opencode/skills/specx-add-infrastructure-adapter in your project.
SKILL.md names no scripts, command-line tools or credentials: Specx Add Infrastructure Adapter is instructions for the agent only.
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Specx Add Infrastructure Adapter is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 1k tokens (SKILL.md is roughly 4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 6.9k tokens, read only when the agent opens those files.
Skills that share tags, products or a category with Specx Add Infrastructure Adapter: Change Database Schema (martin-ueding/geo-activity-playground, 100 stars), Daoyou Data Layer (ChurchTao/Daoyou, 147 stars), Python Database Patterns (aiskillstore/marketplace, 433 stars) and Database Development (WrongStack/WrongStack, 371 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
maksimzayats (a GitHub user) maintains it in maksimzayats/specx, which has 202 GitHub stars. The repository holds 12 skills in this directory. The repository was last updated on August 8, 2026.
Source: maksimzayats/specx on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.