Skip to content

Ryanzucchi/Eldritch_Lich / .agents/skills/categorization-audit

categorization-audit

Verified

Audit the fidelity of Eldritch Lich manuscript imports and automatically categorized data against a source text such as a PDF. Use when asked to verify or correct extracted characters, places, items, events, timelines, family trees, import/export fidelity, orphan references, automation histories, or category assignment in an Eldritch Lich project.

FileKindSize
SKILL.mdskill md3.6 KB
references/schema-eldritch-lich.mdmarkdown1.6 KB
references/tipos-de-erro.mdmarkdown1.1 KB

references/schema-eldritch-lich.md

View on GitHub
# Schema Eldritch Lich: consulta da auditoria

O banco principal é Dexie/IndexedDB local, atualmente na versão 40, nomeado `EldritchDatabase_<activeProjectId>`. A fonte canônica e detalhada é `bd.md` na raiz do projeto e `apps/web/src/db/schema.ts`.

## Tabelas mínimas para auditoria

| Área | Tabelas |
|---|---|
| Manuscrito | `manuscripts`, `manuscriptVersions`, `pendingSaves`, `folders`, `comments` |
| Extração | `automationHistories`, `wikiEntities`, `characterSheets` |
| Universo | `familyRelations`, `factionSheets`, `locationSheets`, `creatureSheets`, `itemSheets`, `historicalEventSheets`, `entityRelationLinks` |
| Tempo | `timelines`, `timelineEvents` |
| Laboratório | `sandboxes`, `sandboxChanges` |

## Relações importantes

- `projectId` delimita registros do projeto e deve ser usado como filtro.
- `personId` e `relatedPersonId` de `familyRelations` apontam para `characterSheets`.
- `timelineEvents.timelineId` aponta para `timelines`.
- `manuscriptId` em versões, comentários, salvamentos e histórico aponta para `manuscripts`.
- Campos terminados em `Id` são referências lógicas: IndexedDB não tem chaves estrangeiras, cascatas ou RLS.

## Índices que importam para a auditoria

- `automationHistories`: `projectId`, `source`, `kind`, `status`, `manuscriptId`, `createdAt`.
- `familyRelations`: `projectId`, `personId`, `relatedPersonId`, `relationType`.
- `characterSheets`: `projectId`, `name`, `role`, `factionId`.
- `wikiEntities`: `projectId`, `name`, `type`, `isConfidential`.
- `timelineEvents`: `timelineId`, `sortOrder`.

`manuscripts` não possui índice Dexie por `projectId`; filtre a coleção lida pelo projeto ativo.
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: 470kUpdated Claude CodeCodexVerifiedInstall
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: 470kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 470kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall