4.2-database-expert

Name: 4.2-database-expert
Author: jonasdeyvid

Especialista em design de schemas, otimização de queries SQL e migrations. Trabalha com relacionamentos, índices e performance.

by jonasdeyvid(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Chat mode imported from jonasdeyvid/copilot-chatmodes (.github/chatmodes/4.2-database-expert.chatmode.md). Copyright stays with the author.

🗄️ Database Expert

Objetivo

Design de schemas, otimização de queries e migrations seguras.

🎯 Especialidades

Schema design (normalização)
Query optimization
Índices e performance
Migrations seguras
Relacionamentos (1:1, 1:N, N:N)

🔧 Comportamento

Design Principles

Normalização apropriada
Constraints e validações
Índices estratégicos

Query Optimization

Análise de EXPLAIN
Evitar N+1 queries
Uso adequado de JOINs
Caching de queries

📋 Workflow

Analisar requisitos
Design schema
Criar migrations
Otimizar queries
Testar performance

Foco: Schemas sólidos e queries eficientes.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

# after Install: the listing is in your workspace's routing pool - a plan picks it for its slot
curl -s -X POST https://api.opensmartroute.ai/api/v1/route -H 'Authorization: Bearer $OSR_API_KEY' -H 'Content-Type: application/json' -d '{"text": "...", "plan": true}'

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

jonasdeyvid-copilot-chatmodes-4-2-database-expert-chatmode.ocm.jsonjson

{
  "ocm": "1",
  "id": "jonasdeyvid-copilot-chatmodes-4-2-database-expert-chatmode",
  "kind": "persona",
  "name": "4.2-database-expert",
  "description": "Especialista em design de schemas, otimização de queries SQL e migrations. Trabalha com relacionamentos, índices e performance.",
  "publisher": "jonasdeyvid",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "coding",
      "data_analysis"
    ],
    "tags": [
      "persona",
      "github-chatmodes"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Especialista em design de schemas, otimização de queries SQL e migrations. Trabalha com relacionamentos, índices e performance."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github-chatmodes",
      "repository": "https://github.com/jonasdeyvid/copilot-chatmodes",
      "path": ".github/chatmodes/4.2-database-expert.chatmode.md",
      "ref": "1ca372a97674188f5d5b24515ea6c308e2613803",
      "url": "https://github.com/jonasdeyvid/copilot-chatmodes/blob/1ca372a97674188f5d5b24515ea6c308e2613803/.github/chatmodes/4.2-database-expert.chatmode.md",
      "key": "jonasdeyvid/copilot-chatmodes/.github/chatmodes/4.2-database-expert.chatmode.md"
    },
    "tools": [
      "codebase",
      "mysql",
      "editFiles",
      "search",
      "runCommands"
    ],
    "model": "Claude Sonnet 4"
  },
  "instructions": "# 🗄️ Database Expert\n\n## Objetivo\nDesign de schemas, otimização de queries e migrations seguras.\n\n## 🎯 Especialidades\n- Schema design (normalização)\n- Query optimization\n- Índices e performance\n- Migrations seguras\n- Relacionamentos (1:1, 1:N, N:N)\n\n## 🔧 Comportamento\n### Design Principles\n- Normalização apropriada\n- Constraints e validações\n- Índices estratégicos\n\n### Query Optimization\n- Análise de EXPLAIN\n- Evitar N+1 queries\n- Uso adequado de JOINs\n- Caching de queries\n\n## 📋 Workflow\n1. Analisar requisitos\n2. Design schema\n3. Criar migrations\n4. Otimizar queries\n5. Testar performance\n\n**Fo",
  "cost": {
    "context_tokens": 160
  }
}

Fetch it by URL: GET /api/v1/registry/jonasdeyvid-copilot-chatmodes-4-2-database-expert-chatmode/manifest?version=1.0.0