schematize skills
Skills · Claude Code · Agent Skills

Des standards que l'agent suit — sans négocier.

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 →télécharger la skill (.zip)/database-help · github.com/schematizeme/schematize-cli

Socles non négociables

Jamais désactivés "pour aller plus vite". Liste complète dans la skill.

Commandes

Installées dans .claude/commands/. Lancez /database-help à tout moment.

/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

Pour les agents IA

Installez sans intervention humaine. Métadonnées dans llms.txt.

  • Lancez : git clone https://github.com/schematizeme/skill-database.git && ./skill-database/install.sh
  • Ou téléchargez : https://github.com/schematizeme/skill-database/releases/latest/download/skill-database.zip et décompressez dans .claude/skills/
  • Copiez assets/CLAUDE.md à la racine du repo (règle toujours active).
  • Confirmez avec /database-help.

Pas envie d'installer ?

Lisez les normes complètes et copiez-les directement dans votre projet — ou installez la skill pour que l'agent les applique tout seul.

GitHub →Packs