Menu
Orienta modelagem, escolha de BD/ORM, indices e migracoes seguras. Use ao criar ou alterar schema e consultas.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Skill for updating, adding, or removing entries in ./Documantation/dot-agents-manual.md based on new or modified agents, skills, and workflows.
Generates and maintains `Frontend/lib/utils/API_functions.dart` — the single source of truth for all HTTP calls from the Flutter app to the ReservAqui backend. Use this skill whenever a developer asks to "add an API function", "criar função de API", "implementar chamada para o backend", "adicionar endpoint no Flutter", "conectar tela com a API", or any variation of wiring a Flutter screen to a backend route. Also trigger this skill when a developer describes a feature that needs API data — even if they don't explicitly mention "API_functions.dart". Never rewrite the existing file; always append. Uses Dio as the HTTP client.
Implementação de CRUD completo para a API do ReservAqui. Especializada na arquitetura do projeto (Entity → Service → Controller → Routes) com multi-tenant PostgreSQL. Use esta skill sempre que precisar criar ou modificar endpoints REST, entidades, rotas, serviços ou controllers no backend — especialmente ao adicionar novos recursos a tabelas do master DB (usuario, anfitriao) ou ao schema tenant (hotel). Aciona automaticamente quando o usuário menciona: "criar endpoint", "novo recurso", "CRUD", "rota", "controller", "service", "adicionar ao backend", "preciso de uma API para", ou quando descreve uma necessidade de negócio que claramente requer novos endpoints ou entidades.
Secure storage implementation skill. Guides the design and implementation of any file/object storage system with a security-first methodology: discovers architecture needs through structured questions, proposes the most secure and optimized approach before writing a single line of code, and then implements it. Activate this skill whenever the user mentions: file upload, object storage, image/video/document storage, S3, GCS, Firebase Storage, Supabase Storage, local disk storage, CDN, media uploads, presigned URLs, multipart upload, storage buckets, secure file access, or anything involving storing user-generated files. Also trigger when the user asks to "add storage", "handle uploads", "store files securely", or "set up a CDN".
Use this skill whenever the user asks to modify, remove, or add new tables in the database, handle database modeling, or update SQL scripts. Make sure to trigger this skill for any relational schemas, PostgreSQL architecture planning, or when creating relationships (1:1, 1:N, N:N).
Orienta sistemas com LLM em producao: limites, custos, observabilidade e seguranca de dados. Use em RAG, agentes ou prompts em produto.
| name | database-design |
| description | Orienta modelagem, escolha de BD/ORM, indices e migracoes seguras. Use ao criar ou alterar schema e consultas. |
SELECT * em producao.EXPLAIN/equivalente em mudancas criticas.python .agent/skills/database-design/scripts/schema_validator.py <caminho>Ver .agent/skills/database-design/ (indexing, migrations, orm-selection, etc.).