schematize skills
Skills · Claude Code · Agent Skills

Standards the agent follows — no negotiation.

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 →download skill (.zip)/database-help · github.com/schematizeme/schematize-cli

Non-negotiable floors

Never switched off "to go faster". Full list in the skill.

Commands

Installed in .claude/commands/. Run /database-help anytime.

/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

For AI agents

Install with no human in the loop. Metadata in llms.txt.

  • Run: git clone https://github.com/schematizeme/skill-database.git && ./skill-database/install.sh
  • Or download: https://github.com/schematizeme/skill-database/releases/latest/download/skill-database.zip and unzip into .claude/skills/
  • Copy assets/CLAUDE.md to the repo root (always-on rule).
  • Confirm with /database-help.

Don't want to install?

Read the full standards and copy them straight into your project — or install the skill so the agent enforces it for you.

GitHub →Packs