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/src/routes/clinica.js
View on GitHubconst express = require('express');
const db = require('../db');
const clinicaRouter = express.Router();
const adminRouter = express.Router();
// Agenda do dia, restrita à clínica do usuário autenticado
clinicaRouter.get('/agenda', async (req, res) => {
const { rows } = await db.query(
`SELECT a.codigo, a.data_hora, a.observacoes, p.id AS paciente_id, p.nome, p.telefone
FROM agendamentos a
JOIN pacientes p ON p.id = a.paciente_id
WHERE p.clinica_id = $1 AND a.data_hora::date = CURRENT_DATE
ORDER BY a.data_hora`,
[req.usuario.clinica]
);
res.json(rows);
});
// Correção de dados cadastrais do paciente pela clínica
clinicaRouter.patch('/pacientes/:id', async (req, res) => {
const { nome, telefone, email } = req.body || {};
const { rowCount } = await db.query(
`UPDATE pacientes
SET nome = COALESCE($1, nome),
telefone = COALESCE($2, telefone),
email = COALESCE($3, email)
WHERE id = $4 AND clinica_id = $5`,
[nome, telefone, email, req.params.id, req.usuario.clinica]
);
if (!rowCount) return res.status(404).json({ erro: 'Paciente não encontrado' });
res.status(204).end();
});
// Administração da plataforma (equipe AgendaFácil, papel "admin")
adminRouter.get('/clinicas', async (req, res) => {
const { rows } = await db.query(
'SELECT id, nome, slug, criado_em FROM clinicas ORDER BY criado_em DESC'
);
res.json(rows);
});
adminRouter.get('/metricas', async (req, res) => {
const { rows } = await db.query(
`SELECT c.slug, COUNT(a.id) AS agendamentos_30d
FROM clinicas c
LEFT JOIN pacientes p ON p.clinica_id = c.id
LEFT JOIN agendamentos a
ON a.paciente_id = p.id AND a.criado_em > now() - interval '30 days'
GROUP BY c.slug`
);
res.json(rows);
});
module.exports = { clinicaRouter, adminRouter };
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 |