ThomasMoreAI/legal-skills-open / br/data-protection/skills/lgpd-enterprise-auditor-brunolagoa
lgpd-enterprise-auditor-brunolagoa
FlaggedAuditoria de conformidade LGPD (Lei nº 13.709/2018) orientada a evidências, com ECA Digital e plataformas digitais — checklist em 17 domínios, severidade, score 0–100 e relatório com plano de adequação. Use quando o usuário pedir auditoria, diagnóstico ou adequação à LGPD/ANPD de um sistema, SaaS, site, app mobile, pipeline DevSecOps ou sistema de IA/LLM.
examples/saas-demo/db/schema.sql
View on GitHub-- AgendaFácil — esquema do banco (projeto fictício de demonstração)
CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE TABLE clinicas (
id SERIAL PRIMARY KEY,
nome TEXT NOT NULL,
slug TEXT NOT NULL UNIQUE,
criado_em TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE TABLE usuarios (
id SERIAL PRIMARY KEY,
clinica_id INTEGER REFERENCES clinicas(id),
email TEXT NOT NULL UNIQUE,
senha_hash TEXT NOT NULL,
papel TEXT NOT NULL CHECK (papel IN ('admin', 'clinica')),
criado_em TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE TABLE pacientes (
id SERIAL PRIMARY KEY,
clinica_id INTEGER NOT NULL REFERENCES clinicas(id),
nome TEXT NOT NULL,
cpf TEXT NOT NULL,
telefone TEXT NOT NULL,
email TEXT,
data_nascimento DATE NOT NULL,
criado_em TIMESTAMPTZ NOT NULL DEFAULT now(),
UNIQUE (clinica_id, cpf)
);
CREATE TABLE agendamentos (
id SERIAL PRIMARY KEY,
codigo UUID NOT NULL DEFAULT gen_random_uuid() UNIQUE,
paciente_id INTEGER NOT NULL REFERENCES pacientes(id),
data_hora TIMESTAMPTZ NOT NULL,
observacoes TEXT, -- motivo da consulta, informado pelo paciente
criado_em TIMESTAMPTZ NOT NULL DEFAULT now()
);
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |