schematize skills
Skills · Claude Code · Agent Skills

エージェントが従う、妥協のない基準。

House database modeling (schema design, language-agnostic): the DESIGN of the relational schema — entities→tables, attributes→columns with the right type, 1:1/1:N/N:N relations with junction tables, normalization 1NF–3NF (and when to DELIBERATELY denormalize), keys (surrogate PK ULID/UUIDv7 + natural key as UNIQUE; identity≠email), constraints (NOT NULL/default, UNIQUE, CHECK, FK with deliberate ON DELETE), indexes (composite/covering/partial, column order, no PII in an index), partitioning and the PII/LGPD floor (marked column, legal basis + retention). Emits CREATE TABLE + reversible expand-contract migration + a model summary. DATA engineering (pipeline/ETL/CDC/contracts/streaming) belongs to schematize-data; the IMPLEMENTATION (parameterized queries, ORM, running migrations) to the language skills.

v0.1.0Disciplina · Modelagem de Bancogithub.com/schematizeme/skill-database
schematize-database · v0.1.0bash
$ schematize install database
GitHub →スキル (.zip) をダウンロード/database-help · github.com/schematizeme/schematize-cli

譲れない基準

「速くするため」に無効化しない。完全な一覧はスキルに。

コマンド

.claude/commands/ にインストール。いつでも /database-help を実行。

/database-helplista todos os comandos do schematize-database
/database-designprojeta um schema a partir da descrição em linguagem natural do domínio: entidades→tabelas/colunas/tipos/PK/FK/índices seguindo os padrões da casa, e emite o SQL (CREATE TABLE) + a migration expand-contract reversível + um resumo do modelo (entidades, relações, chaves, PII) — pronto pro "database builder" do app consumir
/database-reviewrevisa um schema existente (DDL/migration/\d): normalização (1FN–3FN, redundância), chaves (surrogate + natural), tipos, constraints/FK (ON DELETE), índices (faltando/redundante/PII), particionamento e PII/LGPD — aponta achados e emite as migrations de correção
/database-loadcarrega à força TODO o corpo normativo (modelo relacional, normalização/chaves/índices, migrations, segurança/PII) e passa a aplicá-lo
/database-claudecria ou mescla o CLAUDE.md sempre-on de modelagem na raiz do repo
/database-cccontext compact: gera handoff no archive e roda /compact
/database-handoffgera o handoff (context.md + checklist.md) sem compactar

AI エージェント向け

人手を介さずにインストール。メタデータは llms.txt。

  • 実行: git clone https://github.com/schematizeme/skill-database.git && ./skill-database/install.sh
  • またはダウンロード: https://github.com/schematizeme/skill-database/releases/latest/download/skill-database.zip を .claude/skills/ に展開
  • assets/CLAUDE.md をリポジトリのルートにコピー（常時オンのルール）。
  • /database-help で確認。

インストールしたくない？

完全な規約を読み、そのままプロジェクトにコピーできます。あるいはスキルをインストールすれば、エージェントが自動で適用します。

GitHub →パック