PostgreSQL、MySQL、および一般的なORM(Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate)にわたるスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。
The English summary is being prepared. Showing the original description.
15.8K skills · sorted by popularity
PostgreSQL、MySQL、および一般的なORM(Prisma、Drizzle、Kysely、Django、TypeORM、golang-migrate)にわたるスキーマ変更、データマイグレーション、ロールバック、ゼロダウンタイムデプロイメントのためのデータベースマイグレーションベストプラクティス。
The English summary is being prepared. Showing the original description.
Claude Codeセッション中に行われたアーキテクチャ上の意思決定を構造化されたADRとして記録する。意思決定の瞬間を自動検出し、コンテキスト、検討された代替案、根拠を記録する。将来の開発者がコードベースの形状の理由を理解できるようADRログを維持する。
The English summary is being prepared. Showing the original description.
Consult Claude Code from Codex for a second opinion while Codex remains responsible for implementation and verification. Use when the user asks Codex to collaborate with Claude, consult Claude, ask Claude for a plan, get a Claude review, delegate analysis to Claude, or says "Claudeと一緒に", "Claudeに相談", "Claudeにレビューしてもらう", "Claudeの意見も聞く", or "Claudeと計画を立てる". Also use when an explicit independent planning or review pass from Claude would materially reduce risk on a complex coding task.
The English summary is being prepared. Showing the original description.
Use when Codex needs to understand or respond to automatic comment-checker feedback emitted after an edit-like PostToolUse hook.
The English summary is being prepared. Showing the original description.
Track, categorize and prioritize technical debt across the codebase — scans for debt indicators, maintains a register.
The English summary is being prepared. Showing the original description.
Structured bug report from a description, or analyze code for potential bugs. Reproduction steps, severity.
The English summary is being prepared. Showing the original description.
Author the architecture blueprint before code is written. Validates decisions against the pinned engine, flags knowledge gaps.
The English summary is being prepared. Showing the original description.
Architectural code review — coding standards, SOLID, testability, performance concerns.
The English summary is being prepared. Showing the original description.
Builds a short list of must-do and never-do coding rules per system from accepted ADRs. Use when the user wants programmer rules or a quick reference sheet from the ADRs, or needs it regenerated after ADR changes.
The English summary is being prepared. Showing the original description.
Conventions for using sh, bash, bat, python scripts
The English summary is being prepared. Showing the original description.
Conventions for using Java
The English summary is being prepared. Showing the original description.
Conventions for using in all JEE frameworks. These are common standards for CDI
The English summary is being prepared. Showing the original description.
Conventions for using in all JVM languages
The English summary is being prepared. Showing the original description.
Expert knowledge of Fagsak (case) domain in melosys-api. Use when: (1) Understanding the fagsak lifecycle and status transitions, (2) Working with actors (aktører) - citizens, employers, authorities, (3) Debugging case creation, closure, or type/theme changes, (4) Understanding relationship between fagsak and behandling, (5) Working with EU/EEA authorities or bilateral treaty authorities. Triggers: "fagsak", "saksnummer", "MEL-", "aktør", "sakstype", "sakstema", "avslutt sak".
The English summary is being prepared. Showing the original description.
Expert knowledge of EESSI integration via EUX/RINA in melosys-api. Use when: (1) Understanding BUC lifecycle and SED exchange (A-series A001-A012, X-series X001-X013, plus H_BUC/UB_BUC), (2) Debugging SED sending/receiving via EessiClient (opprettBucOgSed, sendSedPåEksisterendeBuc, X008 invalidation, X009 purring), (3) Understanding LA_BUC types and their purposes, (4) Investigating EUX API errors, RINA case (rina saksnummer / saksrelasjon) lookup, (5) Understanding mottakerinstitusjoner / institution catalog lookup.
The English summary is being prepared. Showing the original description.
Expert knowledge of the melosys-api Oracle database schema. Use when: (1) Writing SQL queries against the melosys database, (2) Understanding table relationships and foreign keys, (3) Debugging data issues by querying the database, (4) Understanding what data is stored where, (5) Creating or modifying Flyway migrations, (6) Mapping domain entities to database tables. Triggers: SQL against melosys DB, table/column lookup, FK relationships, "where is X stored", "what column stores X", "why is data missing", beh_resultat_id, behandlingsresultat_id, saksnummer, schema.
The English summary is being prepared. Showing the original description.
Expert knowledge of Brev (letter generation) in melosys-api. Use when: (1) Producing letters and decision documents (vedtaksbrev), (2) Understanding Dokgen templates and mapping, (3) Configuring letter recipients and distribution, (4) Debugging letter generation issues, (5) Adding new letter types or templates.
The English summary is being prepared. Showing the original description.
Expert knowledge of REST endpoint patterns in melosys-api's frontend-api module. Use when: (1) Creating new REST endpoints for melosys-web, (2) Understanding controller patterns and Swagger documentation, (3) Working with DTOs and request/response objects, (4) Understanding exception handling and HTTP status codes, (5) Adding access control to endpoints. Triggers: "new endpoint", "REST controller", "@RestController", "add a DTO", "ResponseEntity", "Aksesskontroll", "access control on endpoint", "Swagger/@Operation", "return 404/403/401/400", "@Protected", "frontend-api", "search endpoint", "/sok".
The English summary is being prepared. Showing the original description.
Expert knowledge of Behandlingsresultat (treatment result) domain in melosys-api. Use when: (1) Understanding result types and their meaning (FASTSATT_LOVVALGSLAND, MEDLEM_I_FOLKETRYGDEN, etc.), (2) Working with periods - Lovvalgsperiode, Medlemskapsperiode, Anmodningsperiode, Utpekingsperiode, (3) Debugging vedtak/decision metadata, criteria evaluation, or social insurance charges, (4) Understanding EU/EEA coordination logic and Article 16 exception handling, (5) Working with trygdeavgift (social insurance charge) calculations.
The English summary is being prepared. Showing the original description.
Expert knowledge of Folketrygdloven (National Insurance Act) processing in melosys-api. Use when: (1) Understanding FTRL bestemmelser (§2-5 to §2-13), (2) Debugging yrkesaktiv/ikke-yrkesaktiv/pensjonist processing flows, (3) Understanding trygdedekning options and combinations, (4) Investigating vilkår for each bestemmelse, (5) Understanding medlemskapsperiode generation logic, (6) Debugging frivillig vs pliktig membership determination.
The English summary is being prepared. Showing the original description.
Expert knowledge of Behandling (case treatment) domain in melosys-api. Use when: (1) Understanding the behandling lifecycle and status transitions, (2) Debugging issues with behandling creation, status changes, or closure, (3) Understanding relationships between Fagsak, Behandling, and Behandlingsresultat, (4) Investigating why a behandling is stuck or has wrong status, (5) Understanding Behandlingstyper, Behandlingstema, Behandlingsstatus enums, (6) Debugging journalføring or SED-triggered behandling creation, (7) Understanding behandling creation via saksflyt sagas.
The English summary is being prepared. Showing the original description.
Modular monolith architecture overview for melosys-api. Use when needing to understand module structure, dependencies between modules, where to place new code, or when changes in one module might affect others. Triggers: "architecture", "module dependencies", "where should I put", "which modules", "dependency graph".
The English summary is being prepared. Showing the original description.
Expert knowledge of Altinn A1 application processing for posted workers in melosys-api. Use when: (1) Understanding Altinn søknad/skjema processing, (2) Debugging MedlemskapArbeidEOS form mapping, (3) Understanding SoeknadMapper transformations, (4) Investigating posted worker application issues, (5) Understanding the MOTTAK_SOKNAD_ALTINN saga flow.
The English summary is being prepared. Showing the original description.
Expert knowledge of lovvalg (law determination/applicable legislation) domain in melosys-api. Use when: (1) Understanding which EU/EEA article applies (11, 12, 13, 16), (2) Debugging LA_BUC processing and SED sending/receiving, (3) Understanding A1 attestation generation, (4) Investigating lovvalgsperiode and unntaksperiode management, (5) Understanding automatic vs manual lovvalg determination, (6) Debugging lovvalgsbeslutning status transitions, (7) Understanding the mapping between regulations and kodeverk.
The English summary is being prepared. Showing the original description.