data-dictionary

Data Dictionary Skill

Gerar dicionarios de dados completos a partir de schemas existentes.

Output Format

Cada tabela/entidade gera uma secao markdown:

### users

Usuarios do sistema.

| Column | Type | Nullable | Default | Description | FK |
|--------|------|----------|---------|-------------|----|
| id | uuid | No | gen_random_uuid() | Primary key | - |
| name | varchar(100) | No | - | Nome completo | - |
| email | varchar(255) | No | - | Email unico | - |
| role_id | uuid | Yes | null | Perfil do usuario | roles.id |
| created_at | timestamptz | No | now() | Data de criacao | - |
| updated_at | timestamptz | No | now() | Data de atualizacao | - |

**Indexes**: `users_email_key` (UNIQUE on email), `users_role_id_idx` (on role_id)
**RLS**: Enabled — users can only read their own row

From Drizzle Schema

// Parse pgTable definitions
import { pgTable, uuid, varchar, timestamp, boolean } from 'drizzle-orm/pg-core';

export const users = pgTable('users', {
  id: uuid('id').defaultRandom().primaryKey(),
  name: varchar('name', { length: 100 }).notNull(),
  email: varchar('email', { length: 255 }).notNull().unique(),
  roleId: uuid('role_id').references(() => roles.id),
  active: boolean('active').default(true).notNull(),
  createdAt: timestamp('created_at', { withTimezone: true }).defaultNow().notNull(),
});

Extrair:

1. Nome da tabela: primeiro arg de pgTable()
2. Colunas: cada propriedade do objeto
3. Tipo: uuid(), varchar(), timestamp(), etc.
4. Nullable: presenca de .notNull() (default e nullable)
5. Default: .default(), .defaultRandom(), .defaultNow()
6. FK: .references(() => table.column)
7. Constraints: .unique(), .primaryKey()

From Prisma Schema

model User {
  id        String   @id @default(uuid())
  name      String
  email     String   @unique
  role      Role?    @relation(fields: [roleId], references: [id])
  roleId    String?
  posts     Post[]
  active    Boolean  @default(true)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  @@index([roleId])
  @@map("users")
}