메뉴
Comprehensive map and workflows for the Database domain. Triggers when users ask to 'design a database', 'optimize query', 'schema architecture', 'database ecosystem', or migrate data.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
Create, optimize, critique, and programmatically structure prompts for AI systems. Use this skill whenever the user is designing or improving a static prompt, system prompt, coding prompt, agent prompt, workflow prompt, MCP-oriented prompt package, or an algorithmic prompt optimization pipeline. Also use it when the user asks to turn vague AI behavior into a precise instruction set, tool policy, agent spec, evaluation metric, or prompt architecture.
Enforce and manage DESIGN.md specifications, extract design systems from URLs, and combine design reasoning with token roles to prevent drift.
Assumption-first architecture review skill to stress-test project plans and expose hidden risks.
Forces the agent to act with a Claude-like product mindset, prioritizing user journey, UX states, and visual quality before coding.
Compiles and extracts session knowledge into a living, interconnected LLM-Wiki. Instead of writing isolated logs, it identifies key entities, updates cross-referenced topic files in docs/knowledgelib/, and maintains an index and chronological log. Use this to ensure persistent, compounding project knowledge.
Overrides the agent's behavior to enter an interactive, consulting mode. Instead of guessing or immediately executing a task, the agent will analyze the request and ask guiding, targeted questions to clarify intent, constraints, and requirements first.
SOC 직업 분류 기준
| name | ecosystem-database |
| description | Comprehensive map and workflows for the Database domain. Triggers when users ask to 'design a database', 'optimize query', 'schema architecture', 'database ecosystem', or migrate data. |
Welcome to the database domain ecosystem. This directory contains specialized agentic skills for database schema design, query optimization, data migration, and security (SQL & NoSQL).
For Orchestrator Agents (
task-decomposer,parallel-planner): When asked to plan a database-related task, you MUST consult the workflows below. Do not hallucinate steps; map your plan strictly to these available skills in the order defined.
When the user asks to "design a database", "create tables", or "model the data", execute these skills sequentially:
@schema-architect -> Creates the ERDs, tables, relationships, and normalizes the models.@access-policy-designer -> Designs Row-Level Security (RLS) or application-level access controls.@seed-data-generator -> Generates realistic, varied placeholder data for development and testing.When the user asks to "fix a slow query", "optimize the database", or "why is the DB lagging":
@query-explainer -> Analyzes the execution plans (e.g., EXPLAIN ANALYZE) to locate bottlenecks.@index-advisor -> Recommends optimal covering indexes, composites, or partition keys to solve the bottleneck.@query-budget-enforcer -> Sets up mechanisms to detect and alert on N+1 queries or heavy reads in the future.When the user asks to "update the database", "change a table", or "migrate data":
@schema-diff-analyzer -> Compares the old schema and new schema to detect potential data loss or locks.@migration-strategist -> Designs the zero-downtime migration scripts (up/down) and backfill jobs.When the user asks about "data privacy", "GDPR", or "where does this data go":
@data-masker -> Identifies PII (Personally Identifiable Information) and designs obfuscation/encryption strategies.@data-lineage-tracer -> Maps how data flows from ingestion to the data warehouse.When the user asks to "scale database connections", "setup pgbouncer", "fix too many connections", or "configure connection pool":
@pgbouncer-architect -> Analyzes workload, calculates optimal pool sizes, selects pooling mode, and generates PgBouncer configurations.Database design is focused on data integrity, scalable reads/writes, and strict security constraints. Every skill in this domain is programmed to defend against data corruption and insecure data exposure. Never prioritize feature delivery over data safety.
As an AI Agent reading this ecosystem file, you must actively guide the user to install the missing skills for the selected workflow.
To install all skills within this ecosystem at once, you must execute or instruct the user to execute the provided installation script:
python skills/ecosystem-database/scripts/install_all.py
Execution Rule: Do not attempt to perform the tasks of these skills yourself. Your job is to install them and hand off the execution to the appropriate skill, or instruct the user to trigger the newly installed skills in order.