Files
descomplicar-meta-plugin/commands/agent-config.md
Emanuel Almeida 692475a315 feat(v1.5.2): Execute database migrations and complete setup
- 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>
2026-02-04 16:18:02 +00:00

333 lines
14 KiB
Markdown

---
name: agent-config
description: >
Configuração completa de recursos por agente.
MCPs, Skills, SDKs, Colaborações e Datasets Dify.
argument-hint: "[agent-slug] [add-mcp|remove-mcp|add-skill|add-collab|export|import]"
---
# /descomplicar:agent-config
Configuração completa de recursos por agente usando tabelas de relacionamento existentes.
## Objectivo
Gerir o mapeamento entre agentes e os seus recursos usando as tabelas `cr_agent_mcps`, `cr_agent_skills`, `cr_sdk_agents`, e `cr_agent_collaborations`.
## Sintaxe
```
/descomplicar:agent-config [agent-slug] [action]
```
## Modo Visualização
### Listar todos os agentes com resumo
```
/descomplicar:agent-config
```
**Query:**
```sql
SELECT
a.slug,
a.name,
a.category,
(SELECT COUNT(*) FROM cr_agent_mcps WHERE agent_id = a.id) as mcps,
(SELECT COUNT(*) FROM cr_agent_skills WHERE agent_id = a.id) as skills,
(SELECT COUNT(*) FROM cr_sdk_agents WHERE agent_id = a.id) as sdks,
(SELECT COUNT(*) FROM cr_agent_collaborations WHERE agent_id = a.id) as collabs
FROM cr_agents a
WHERE a.status = 'active'
ORDER BY a.category, a.slug;
```
**Output:**
```
╔══════════════════════════════════════════════════════════════════════╗
║ AGENT CONFIGURATIONS (46 agentes) ║
╠══════════════════════════════════════════════════════════════════════╣
║ Agent │ MCPs │ Skills │ SDKs │ Collabs ║
║ ─────────────────────────────────────────────────────────────────── ║
║ [DEV - 27 agentes] ║
║ wordpress-plugin-developer │ 12 │ 4 │ 2 │ 3 ║
║ php-fullstack-engineer │ 8 │ 3 │ 3 │ 4 ║
║ ... ║
║ [MARKETING - 13 agentes] ║
║ marketing-planning-expert │ 6 │ 5 │ 2 │ 2 ║
║ ... ║
╚══════════════════════════════════════════════════════════════════════╝
```
### Ver configuração de agente específico
```
/descomplicar:agent-config wordpress-plugin-developer
```
**Queries:**
```sql
-- MCPs do agente (cr_agent_mcps)
SELECT
m.slug,
m.name,
am.relationship_type,
am.priority
FROM cr_agent_mcps am
JOIN cr_mcps m ON am.mcp_id = m.id
WHERE am.agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer')
ORDER BY am.relationship_type, am.priority;
-- Skills do agente (cr_agent_skills)
SELECT
s.slug,
s.name,
s.category
FROM cr_agent_skills ags
JOIN cr_skills s ON ags.skill_id = s.id
WHERE ags.agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer');
-- SDKs do agente (cr_sdk_agents)
SELECT
sdk.slug,
sdk.name
FROM cr_sdk_agents sa
JOIN cr_sdks sdk ON sa.sdk_id = sdk.id
WHERE sa.agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer');
-- Colaborações (cr_agent_collaborations)
SELECT
a2.slug as collaborator,
a2.name,
ac.collaboration_type
FROM cr_agent_collaborations ac
JOIN cr_agents a2 ON ac.collaborator_id = a2.id
WHERE ac.agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer');
-- Decision Trees que usam este agente
SELECT
dt.name,
dt.trigger_keywords,
dt.confidence_score
FROM cr_decision_trees dt
WHERE dt.agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer')
AND dt.status = 'active';
-- Datasets Dify (do agent-knowledge-config.json)
-- Lido do ficheiro local
```
**Output:**
```
╔══════════════════════════════════════════════════════════════════════╗
║ AGENT CONFIG: wordpress-plugin-developer ║
║ Category: dev | Status: active ║
╠══════════════════════════════════════════════════════════════════════╣
║ MCPs (12) via cr_agent_mcps ║
║ ─────────────────────────────────────────────────────────────────── ║
║ Type │ MCP │ Priority │ Status ║
║ PRIMARY │ cwp │ 1 │ active ║
║ PRIMARY │ ssh-unified │ 2 │ active ║
║ RECOMMEND │ filesystem │ 1 │ active ║
║ RECOMMEND │ gitea │ 2 │ active ║
║ AVAILABLE │ google-workspace │ 1 │ active ║
║ AVAILABLE │ tavily │ 2 │ active ║
║ ... ║
╠══════════════════════════════════════════════════════════════════════╣
║ Skills (4) via cr_agent_skills ║
║ ─────────────────────────────────────────────────────────────────── ║
║ wp-dev, wp-performance, elementor, woocommerce ║
╠══════════════════════════════════════════════════════════════════════╣
║ SDKs (2) via cr_sdk_agents ║
║ ─────────────────────────────────────────────────────────────────── ║
║ wordpress, deskdev ║
╠══════════════════════════════════════════════════════════════════════╣
║ Collaborations (3) via cr_agent_collaborations ║
║ ─────────────────────────────────────────────────────────────────── ║
║ php-fullstack-engineer (technical), database-design-specialist, ║
║ seo-specialist (cross-domain) ║
╠══════════════════════════════════════════════════════════════════════╣
║ Decision Trees (1) ║
║ ─────────────────────────────────────────────────────────────────── ║
║ wordpress-tasks (confidence: 0.92, keywords: wordpress, wp, plugin) ║
╠══════════════════════════════════════════════════════════════════════╣
║ Dify Datasets (agent-knowledge-config.json) ║
║ ─────────────────────────────────────────────────────────────────── ║
║ wordpress-development, woocommerce-api, elementor-docs ║
║ Auto-consult: ON | Query template: "WordPress {topic} best practices"║
╠══════════════════════════════════════════════════════════════════════╣
║ Telemetry (30 dias) ║
║ ─────────────────────────────────────────────────────────────────── ║
║ Invocações: 156 | Success: 96% | Avg Duration: 52s ║
╚══════════════════════════════════════════════════════════════════════╝
```
## Modo Edição
### Adicionar MCP
```
/descomplicar:agent-config wordpress-plugin-developer add-mcp lighthouse primary
```
**Query:**
```sql
INSERT INTO cr_agent_mcps (agent_id, mcp_id, relationship_type, priority, created_at)
VALUES (
(SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer'),
(SELECT id FROM cr_mcps WHERE slug = 'lighthouse'),
'primary',
(SELECT COALESCE(MAX(priority), 0) + 1 FROM cr_agent_mcps
WHERE agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer')
AND relationship_type = 'primary'),
NOW()
);
```
### Remover MCP
```
/descomplicar:agent-config wordpress-plugin-developer remove-mcp lighthouse
```
**Query:**
```sql
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 = 'lighthouse');
```
### Alterar tipo de relacionamento MCP
```
/descomplicar:agent-config wordpress-plugin-developer update-mcp lighthouse recommended
```
**Query:**
```sql
UPDATE cr_agent_mcps
SET relationship_type = 'recommended', updated_at = NOW()
WHERE agent_id = (SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer')
AND mcp_id = (SELECT id FROM cr_mcps WHERE slug = 'lighthouse');
```
### Adicionar Skill
```
/descomplicar:agent-config wordpress-plugin-developer add-skill security-audit
```
**Query:**
```sql
INSERT INTO cr_agent_skills (agent_id, skill_id, created_at)
VALUES (
(SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer'),
(SELECT id FROM cr_skills WHERE slug = 'security-audit'),
NOW()
);
```
### Adicionar Colaboração
```
/descomplicar:agent-config wordpress-plugin-developer add-collab seo-specialist cross-domain
```
**Query:**
```sql
INSERT INTO cr_agent_collaborations (agent_id, collaborator_id, collaboration_type, created_at)
VALUES (
(SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer'),
(SELECT id FROM cr_agents WHERE slug = 'seo-specialist'),
'cross-domain',
NOW()
);
```
### Associar a SDK
```
/descomplicar:agent-config wordpress-plugin-developer add-sdk ecommerce
```
**Query:**
```sql
INSERT INTO cr_sdk_agents (sdk_id, agent_id, created_at)
VALUES (
(SELECT id FROM cr_sdks WHERE slug = 'ecommerce'),
(SELECT id FROM cr_agents WHERE slug = 'wordpress-plugin-developer'),
NOW()
);
```
## Modo Bulk
### Adicionar MCP a todos os agentes de uma categoria
```
/descomplicar:agent-config --category=dev add-mcp gitea recommended
```
**Query:**
```sql
INSERT INTO cr_agent_mcps (agent_id, mcp_id, relationship_type, priority, created_at)
SELECT
a.id,
(SELECT id FROM cr_mcps WHERE slug = 'gitea'),
'recommended',
1,
NOW()
FROM cr_agents a
WHERE a.category = 'dev'
AND a.status = 'active'
AND NOT EXISTS (
SELECT 1 FROM cr_agent_mcps am
WHERE am.agent_id = a.id
AND am.mcp_id = (SELECT id FROM cr_mcps WHERE slug = 'gitea')
);
```
## Sincronização com agent-knowledge-config.json
O ficheiro `~/.claude/agents/agent-knowledge-config.json` contém configurações de datasets Dify que complementam os relacionamentos BD:
```json
{
"wordpress-plugin-developer": {
"datasets": ["wordpress-development", "woocommerce-api"],
"auto_consult": true,
"query_template": "WordPress {topic} best practices 2026",
"priority_datasets": ["wordpress-development"]
}
}
```
### Exportar config BD para JSON
```
/descomplicar:agent-config wordpress-plugin-developer export
```
### Importar config JSON para BD
```
/descomplicar:agent-config wordpress-plugin-developer import
```
## Output Esperado
```
╔══════════════════════════════════════════════════════════════════════╗
║ AGENT CONFIG: wordpress-plugin-developer ║
╠══════════════════════════════════════════════════════════════════════╣
║ MCPs (12): cwp, ssh-unified (primary) | filesystem, gitea (rec) ║
║ Skills (4): wp-dev, wp-performance, elementor, woocommerce ║
║ SDKs (2): wordpress, deskdev ║
║ Collabs (3): php-fullstack-engineer, database-design-specialist ║
╠══════════════════════════════════════════════════════════════════════╣
║ Telemetry: 156 invocações | 96% success | 52s avg ║
╚══════════════════════════════════════════════════════════════════════╝
```