agentmods.dev

temps-add-migration-and-entity

temps-add-migration-and-entity is a skill for Claude Code, Codex from gotempsh/temps. It costs 84 tokens per session (2,662 once invoked), scanned A, original, Apache-2.0.

A procedure for changing a PostgreSQL or TimescaleDB database schema together with the Sea-ORM code that represents it. A migration is a scripted database change that can apply or undo a schema change.

In plain words
What is it for?
Use it to add or alter schema objects, register migrations, create or update entities, handle encrypted columns, and test applying and reverting changes.
Why use it?
It keeps a new or changed table, column, index, or constraint aligned with the application code and verifies that the change works on an existing database.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one. Also seen: installed under .agents/ (shared by several agents); mentions AGENTS.md.

Needs its repository: it runs a file that does not travel with it, so clone the repository first. The line is python3 scripts/rule_drift.py.

not rated 903repo +18 changed 2d ago A scan 84 tokens original Apache-2.0

Good fit Use it to add or alter schema objects, register migrations, create or update entities, handle encrypted columns, and test applying and reverting changes.

Compare 6 skills from other repositories ↓
View source ↗ gotempsh/temps temps.sh
Install

Getting it into your agent

It runs from inside its repository, so the clone comes first — what it calls does not travel with the file alone.

Clone the repo
git clone --depth 1 https://github.com/gotempsh/temps
agentmods
npx agentmods add skills/gotempsh/temps/temps-add-migration-and-entity

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for temps-add-migration-and-entity

README.md
[![agentmods](https://agentmods.dev/badge/skills/gotempsh/temps/temps-add-migration-and-entity/github.svg)](https://agentmods.dev/skills/gotempsh/temps/temps-add-migration-and-entity)
Your own site
<a href="https://agentmods.dev/skills/gotempsh/temps/temps-add-migration-and-entity"><img src="https://agentmods.dev/badge/skills/gotempsh/temps/temps-add-migration-and-entity/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for temps-add-migration-and-entity

Your own site · 80×15
<a href="https://agentmods.dev/skills/gotempsh/temps/temps-add-migration-and-entity"><img src="https://agentmods.dev/badge/skills/gotempsh/temps/temps-add-migration-and-entity.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 84 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,662 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00084 $0.02662
Opus 5.5 $0.00034 $0.01065
Sonnet 5.5 $0.00017 $0.00532
Haiku 4.5 $0.00008 $0.00266

Measured 2d ago against content hash 4da48cf7cc3c, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

temps-add-migration-and-entity scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.agents/skills/temps-add-migration-and-entity/SKILL.md · 216 lines

How it starts

The opening of the file, as written. The whole thing — 216 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Add a migration and its entity

A schema change in Temps is always two pieces in one PR: a new migration file (adding the file registers it in Migrator) and the entity (new or changed) that reads the table. A test proves the migration applies to an existing database and, where it matters, that down restores the previous state.

Read first: AGENTS.md (NEVER list, "Configuration is a column", "Data, logging and secrets"), REVIEW.md → "Migrations and the database".

1. Decide what the change is

  • Runtime configuration is a column, never an env var. A new knob belongs on the row it configures (oidc_providers.trust_idp_email, project_analytics_settings.exclude_datacenter_traffic), so it can be changed per record through the API, gets audit logging, and needs no restart. Env vars are only for bootstrap values needed before the database exists.
  • Sensitive values are encrypted at rest. Name the column <thing>_encrypted (TEXT), write it with EncryptionService::encrypt_string and read it with decrypt_string (crates/temps-core/src/encryption.rs). Responses expose a boolean such as has_secret, never the value. Worked example: crates/temps-revenue/src/service/integration.rs.
  • A shipped migration is never edited. Once a migration has been released, its name is recorded in seaql_migrations on users' databases and it never runs again. Fix or extend it with a new migration.
  • Stay compatible with the previous binary. crates/temps-schema/src/schema_guard.rs lets an operator roll the binary back after an upgrade with the newer schema in place. Prefer additive changes (new nullable or defaulted column, new table). Only drop or rename a column after the code has stopped reading it in an earlier release; see m20261105_000002_drop_webhook_deliveries_response_body.rs.

2. Create the migration file

Location: crates/temps-migrations/src/migration/.

Read the full file on GitHub · 216 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 2d ago Changed · +14 lines · +1 tokens per session 4da48cf7cc3c
  2. 5d ago First seen · 202 lines · 83 tokens per session scan A 50939a3954a1

Subscribe to this mod's changes

temps-add-migration-and-entity is a skill published in the GitHub repository gotempsh/temps (903 stars, last pushed yesterday), licensed Apache-2.0. It adds 84 tokens to every session and 2,662 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-11-02.

Analytics and metricsCI and CDDatabasesDevOps and cloudPostgreSQLdeployment-platformdockererror-tracking
Related

temps-add-migration-and-entity compared with skills from other repositories

temps-add-migration-and-entity next to 6 skills from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
temps-add-migration-and-entitygotempsh/tempsSkill903yesterdayApache-2.0A84Claude Code, Codex
alembic-migrationvstorm-co/full-stack-ai-agent-templateSkill2.0k7d agoMITA56Claude Code
jpa-patternspiomin/claude-ai-spring-bootSkill1.4k7d agoApache-2.0A47Claude Code
release-db-config-syncPrismer-AI/PrismerCloudSkill1.4k15d agoMITA91Claude Code
neonericrisco/rsc-harnessSkill5032d agoMITA93Claude Code, Codex
neonG1Joshi/Agent-SkillsSkill151mo agoMITA44Claude Code, Codex
ess-postgres-docsCiscoDevNet/essentialsSkill73d agoApache-2.0A48Claude Code, Codex