- 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>
14 KiB
14 KiB
name, description, argument-hint
| name | description | argument-hint |
|---|---|---|
| agent-config | Configuração completa de recursos por agente. MCPs, Skills, SDKs, Colaborações e Datasets Dify. | [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:
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:
-- 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:
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:
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:
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:
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:
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:
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:
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:
{
"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 ║
╚══════════════════════════════════════════════════════════════════════╝