Emanuel Almeida
692475a315
- Execute all 6 migrations on Desk CRM production database - Create missing tables: cr_lsps, cr_agent_lsps, cr_lsp_usage - Create archive tables: cr_*_usage_archive (4 tables) - Create system tables: cr_migrations, cr_maintenance_log - Make all scripts executable (chmod +x) - Total cr_* tables: 38 Migration files: - 001_initial_schema.sql - 002_add_lsps.sql - 003_add_relationships.sql - 004_add_telemetry.sql - 005_add_archive_tables.sql - 006_add_maintenance_log.sql Scripts: - session-init.sh, session-end.sh - inject-context.sh, inject-agent-context.sh - record-usage.sh, db-backup.sh, sync-to-mysql.sh Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
12 KiB
12 KiB
name, description, argument-hint
| name | description | argument-hint |
|---|---|---|
| relationships | Gestão de relacionamentos entre componentes do sistema. Visualizar, criar, modificar e validar relacionamentos. | [list|show|add|remove|validate|suggest] [type] [args] |
/descomplicar:relationships
Gestão de relacionamentos entre componentes.
Objectivo
Visualizar, criar, modificar e validar relacionamentos entre entidades (Agents, Skills, MCPs, SDKs).
Sintaxe
/descomplicar:relationships [action] [type] [args]
Acções Disponíveis
1. Listar Relacionamentos
Por tipo:
/descomplicar:relationships list agent-mcps
/descomplicar:relationships list sdk-agents
/descomplicar:relationships list sdk-skills
/descomplicar:relationships list sdk-mcps
/descomplicar:relationships list agent-skills
/descomplicar:relationships list skill-mcps
/descomplicar:relationships list agent-collabs
Por entidade específica:
/descomplicar:relationships list agent wordpress-plugin-developer
/descomplicar:relationships list sdk wordpress
/descomplicar:relationships list mcp desk-crm-v3
2. Ver Detalhes de Relacionamento
/descomplicar:relationships show agent wordpress-plugin-developer
Output esperado:
╔══════════════════════════════════════════════════════════════════════╗
║ RELATIONSHIPS: wordpress-plugin-developer ║
╠══════════════════════════════════════════════════════════════════════╣
║ MCPs (via cr_agent_mcps) ║
║ ├── PRIMARY: cwp, ssh-unified ║
║ ├── RECOMMENDED: filesystem, gitea ║
║ └── AVAILABLE: google-workspace, tavily ║
╠══════════════════════════════════════════════════════════════════════╣
║ Skills (via cr_agent_skills) ║
║ └── wp-dev, wp-performance, elementor, woocommerce ║
╠══════════════════════════════════════════════════════════════════════╣
║ SDKs (via cr_sdk_agents) ║
║ └── wordpress, deskdev ║
╠══════════════════════════════════════════════════════════════════════╣
║ Collaborations (via cr_agent_collaborations) ║
║ └── php-fullstack-engineer, database-design-specialist ║
╠══════════════════════════════════════════════════════════════════════╣
║ Decision Trees (via cr_decision_trees) ║
║ └── wordpress-tasks (confidence: 0.92) ║
╚══════════════════════════════════════════════════════════════════════╝
3. Criar Relacionamento
Agent ↔ MCP:
/descomplicar:relationships add agent-mcp wordpress-plugin-developer cwp primary
INSERT INTO cr_agent_mcps (agent_id, mcp_id, relationship_type, created_at)
VALUES (
(SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer'),
(SELECT id FROM cr_mcps WHERE slug = 'cwp'),
'primary',
NOW()
);
SDK ↔ Agent:
/descomplicar:relationships add sdk-agent wordpress wordpress-plugin-developer
INSERT INTO cr_sdk_agents (sdk_id, agent_id, created_at)
VALUES (
(SELECT id FROM cr_sdks WHERE slug = 'wordpress'),
(SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer'),
NOW()
);
Agent ↔ Skill:
/descomplicar:relationships add agent-skill wordpress-plugin-developer wp-dev
Agent ↔ Agent (Collaboration):
/descomplicar:relationships add agent-collab wordpress-plugin-developer php-fullstack-engineer
4. Remover Relacionamento
/descomplicar:relationships remove agent-mcp wordpress-plugin-developer cwp
DELETE FROM cr_agent_mcps
WHERE agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer')
AND mcp_id = (SELECT id FROM cr_mcps WHERE slug = 'cwp');
5. Validar Consistência
/descomplicar:relationships validate
Verificações:
- Todos os agent_id em cr_agent_mcps existem em cr_agents
- Todos os mcp_id em cr_agent_mcps existem em cr_mcps
- Todos os sdk_id em cr_sdk_* existem em cr_sdks
- Todos os skill_id em cr_*_skills existem em cr_skills
- Decision trees referenciam agentes válidos
Output:
╔══════════════════════════════════════════════════════════════════════╗
║ RELATIONSHIP VALIDATION REPORT ║
╠══════════════════════════════════════════════════════════════════════╣
║ Tabela │ Total │ Válidos │ Órfãos │ Status ║
║ cr_agent_mcps │ 483 │ 483 │ 0 │ ✓ ║
║ cr_sdk_agents │ 131 │ 131 │ 0 │ ✓ ║
║ cr_sdk_skills │ 75 │ 75 │ 0 │ ✓ ║
║ cr_sdk_mcps │ 56 │ 56 │ 0 │ ✓ ║
║ cr_agent_skills │ 23 │ 23 │ 0 │ ✓ ║
║ cr_skill_mcps │ 45 │ 45 │ 0 │ ✓ ║
║ cr_agent_collabs │ 12 │ 12 │ 0 │ ✓ ║
║ cr_decision_trees │ 5 │ 5 │ 0 │ ✓ ║
╠══════════════════════════════════════════════════════════════════════╣
║ RESULTADO: 100% consistente, 0 órfãos ║
╚══════════════════════════════════════════════════════════════════════╝
6. Sugerir Relacionamentos
/descomplicar:relationships suggest agent wordpress-plugin-developer
Analisa:
- MCPs usados por agentes similares
- Skills da mesma categoria
- Padrões de uso na telemetria
Output:
╔══════════════════════════════════════════════════════════════════════╗
║ SUGGESTED RELATIONSHIPS: wordpress-plugin-developer ║
╠══════════════════════════════════════════════════════════════════════╣
║ MCPs Sugeridos (baseado em agentes similares) ║
║ ├── lighthouse (usado por 80% dos agentes WP) ║
║ └── gsc (Google Search Console - SEO) ║
╠══════════════════════════════════════════════════════════════════════╣
║ Skills Sugeridas (mesma categoria: dev) ║
║ └── security-audit (não mapeada, relevante para WP) ║
╠══════════════════════════════════════════════════════════════════════╣
║ Collaborations Sugeridas (baseado em workflows) ║
║ └── seo-specialist (frequentemente usado em conjunto) ║
╚══════════════════════════════════════════════════════════════════════╝
Adicionar sugestões? [s/n]
Queries SQL de Referência
Ver todos os relacionamentos de um agente
SELECT
a.slug as agent,
'MCP' as rel_type,
m.slug as related,
am.relationship_type as rel_subtype
FROM cr_agents a
JOIN cr_agent_mcps am ON a.id = am.agent_id
JOIN cr_mcps m ON am.mcp_id = m.id
WHERE a.slug = 'wordpress-plugin-developer'
UNION ALL
SELECT
a.slug as agent,
'SDK' as rel_type,
s.slug as related,
'member' as rel_subtype
FROM cr_agents a
JOIN cr_sdk_agents sa ON a.id = sa.agent_id
JOIN cr_sdks s ON sa.sdk_id = s.id
WHERE a.slug = 'wordpress-plugin-developer'
UNION ALL
SELECT
a.slug as agent,
'Skill' as rel_type,
sk.slug as related,
'uses' as rel_subtype
FROM cr_agents a
JOIN cr_agent_skills asks ON a.id = asks.agent_id
JOIN cr_skills sk ON asks.skill_id = sk.id
WHERE a.slug = 'wordpress-plugin-developer';
Estatísticas de relacionamentos
SELECT
'cr_agent_mcps' as table_name, COUNT(*) as count FROM cr_agent_mcps
UNION ALL SELECT 'cr_sdk_agents', COUNT(*) FROM cr_sdk_agents
UNION ALL SELECT 'cr_sdk_skills', COUNT(*) FROM cr_sdk_skills
UNION ALL SELECT 'cr_sdk_mcps', COUNT(*) FROM cr_sdk_mcps
UNION ALL SELECT 'cr_agent_skills', COUNT(*) FROM cr_agent_skills
UNION ALL SELECT 'cr_skill_mcps', COUNT(*) FROM cr_skill_mcps
UNION ALL SELECT 'cr_agent_collaborations', COUNT(*) FROM cr_agent_collaborations;
Output Esperado
╔══════════════════════════════════════════════════════════════════════╗
║ RELATIONSHIP VALIDATION REPORT ║
╠══════════════════════════════════════════════════════════════════════╣
║ Tabela │ Total │ Válidos │ Órfãos │ Status ║
║ cr_agent_mcps │ 483 │ 483 │ 0 │ ✓ ║
║ cr_sdk_agents │ 131 │ 131 │ 0 │ ✓ ║
║ cr_sdk_skills │ 75 │ 75 │ 0 │ ✓ ║
║ cr_agent_skills │ 23 │ 23 │ 0 │ ✓ ║
╠══════════════════════════════════════════════════════════════════════╣
║ RESULTADO: 100% consistente, 0 órfãos, 800+ relacionamentos ║
╚══════════════════════════════════════════════════════════════════════╝