メニュー
Analyses a MySQL or MariaDB instance and produces a database architecture and schema overview. Use when: `.crux/docs/mysql.md` is missing, onboarding needs a live schema scan, or the user wants a concise MySQL topology and object inventory summary.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Produces a weekly CISO management briefing as a Marp-compatible Markdown presentation. Use when: weekly cybersecurity notes, KPI/KRI data, incidents, vulnerabilities, threat intelligence, regulatory updates, or management decision needs must become an executive-ready cyber risk and security management brief.
Operating protocol for a Crux project. Use when: an agent or IDE needs to understand Crux layout, locate framework-home definitions, locate project `.crux` state, route work to the right agent, run onboarding, manage task continuity, or decide which files are read-only versus writable.
Enforces a disciplined implementation posture before coding or broad refactors: surface assumptions, narrow scope, prefer the simplest complete fix, define verification targets, and avoid speculative cleanup. Use when: a developer agent is about to implement, refactor, review, or change non-trivial code and there is meaningful ambiguity, risk, or temptation to over-engineer.
Analyses a live Kubernetes cluster and produces .crux/docs/kubernetes.md and .crux/summaries/kubernetes.md. Read-only — does not modify any cluster resources. Use when: (1) .crux/docs/kubernetes.md is missing during onboarding, (2) user requests an architecture review, (3) cluster configuration has significantly changed.
Audits all cluster namespaces against tenant naming conventions defined in decisions/tenant-naming-conventions.md. Checks label compliance, missing resource quotas, and naming pattern violations. Use when: naming convention question, pre-release namespace review, SOC Type 2 audit, or periodic drift check.
Applies or updates Kubernetes NetworkPolicy resources for a target namespace. Supports standard policy templates (deny-all-ingress, allow-same-namespace, allow-ingress-controller, allow-monitoring) and custom policies from user input. Requires explicit user approval before applying any change. Use when: hardening a namespace, onboarding a new tenant, policy drift repair.
| name | mysql-schema-analyser |
| description | Analyses a MySQL or MariaDB instance and produces a database architecture and schema overview. Use when: `.crux/docs/mysql.md` is missing, onboarding needs a live schema scan, or the user wants a concise MySQL topology and object inventory summary. |
| license | MIT |
| compatibility | opencode |
| metadata | {"owner":"mysql-admin","type":"read-write","approval":"No"} |
Owner: mysql-admin
Type: read-write
Approval: No
Builds a read-only overview of MySQL/MariaDB databases, schemas, and key operational traits.
.crux/docs/mysql.md is missingRequires already loaded:
{framework-home}/agents/mysql-admin/AGENT.md
.crux/workspace/mysql-admin/MEMORY.md
External requirement:
mysql client access to the target instance
Estimated token cost: ~700 tokens
Unloaded after: task completion
| Input | Source | Required |
|---|---|---|
target-host | user / MEMORY.md | Yes |
target-port | user / MEMORY.md | No |
target-user | user / MEMORY.md | No |
1. Validate connection
2. Collect version, database inventory, table counts, and replication role if visible
3. Summarise schema shape and notable operational traits
4. Write docs/mysql.md
5. Return concise result summary
6. Skill complete — unload
Writes to: .crux/docs/mysql.md
Format: markdown
| Condition | Action |
|---|---|
| mysql client not found | Stop. Notify user. |
| Connection fails | Stop. Record blocker in notes. |
.crux/docs/ not writable | Write to .crux/workspace/mysql-admin/output/ and notify user |