Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add rockyflux/yq-workflow --skill yq-db-designgit clone --depth 1 https://github.com/rockyflux/yq-workflowWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/rockyflux/yq-workflow/yq-db-design)<a href="https://agentmods.dev/skills/rockyflux/yq-workflow/yq-db-design"><img src="https://agentmods.dev/badge/skills/rockyflux/yq-workflow/yq-db-design/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/rockyflux/yq-workflow/yq-db-design"><img src="https://agentmods.dev/badge/skills/rockyflux/yq-workflow/yq-db-design.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00030 | $0.00681 |
| Opus 5 | $0.00015 | $0.00341 |
| Sonnet 5 | $0.00006 | $0.00136 |
| Haiku 4.5 | $0.00003 | $0.00068 |
Grade A, and why
yq-db-design scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 8d ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
What it actually says
YQ Database Design
Overview
为业务能力设计可落地的数据模型,覆盖实体关系、约束、索引、迁移和数据演进风险。
Core principle: 先定义数据边界和生命周期,再写持久化代码。
When to Use
- 需要新增表、字段、索引或迁移方案
- 需要把领域模型转成数据库结构
- 需要考虑查询性能、一致性、保留策略或审计要求
- 需要评估 schema 变更对现网和回滚的影响
Route Elsewhere
- 需求和业务范围还不清楚:转
yq-req-analysis - 主要是接口契约:转
yq-api-design - 主要是实现 Repository 或 SQL:转
yq-code-gen - 主要是性能排查:转
yq-performance-opt
Process
- 提炼实体、关系、主键和业务约束。
- 设计表结构、索引和唯一性规则。
- 明确写入路径、读取模式和一致性要求。
- 规划迁移、回滚、历史数据兼容和清理策略。
- 标出性能、容量和演进风险。
Output
# Database Design
## Scope
## Entities and Relationships
## Schema Proposal
## Index and Constraint Plan
## Migration and Rollback Notes
## Data Lifecycle and Retention
## Risks and Trade-offs
## Recommended Next Step
Related Skills
- 上游通常来自
yq-system-design - 下游通常接
yq-code-gen、yq-test-gen - 数据性能问题可继续接
yq-performance-opt
Recommended Next Step
- 默认交给
yq-code-gen,把 schema、索引和迁移方案落成实现 - 如果需要先保护数据读写行为,可先补
yq-test-gen - 如果当前焦点已经转到查询瓶颈或索引收益,改走
yq-performance-opt
Common Mistakes
- 按代码结构建表,而不是按业务约束建模
- 缺少迁移和回滚说明
- 只考虑写入,不考虑查询和生命周期
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 8d ago First seen · 91 lines · 30 tokens per session scan A 7adf1ee3cfc1
yq-db-design is a skill published in the GitHub repository rockyflux/yq-workflow (2 stars, last pushed yesterday), licensed MIT. It adds 30 tokens to every session and 681 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.
Other skills, from other repositories
create-pr
Creates a GitHub PR with a Linear-ticket-prefixed title and a decision-led, narrative description for Prisma 8. Use when the user wants to create a pull request, open a PR, or submit changes for review.
schema-exploration
Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.
ha-data-stores
Map of Hope Agent's local data stores and safe read-only query workflow. Use when the user asks where Hope Agent stores data, wants to inspect sessions/messages/memory/logs/background jobs/knowledge indexes/settings, asks the model to query local app data, or debugging requires checking persisted state. Trigger…
supabase
Supabase / PostgREST Row-Level-Security playbook — pull the anon (or leaked servicerole) key out of the frontend JS, map tables from the auto-generated OpenAPI spec, test anonymous RLS READ disclosures (PII/secret leaks), and anonymous RLS WRITE abuse (insert/update/delete — e.g. forging…
nornicdb-cypher-queries
Pick fast, predictable Cypher query shapes in NornicDB — point lookups, batch retrieval, pagination, search, traversal, batched UNWIND/MERGE writes, cleanup, multi-tenant isolation. Use when writing or reviewing Cypher whose latency or throughput matters; maps user intent to the executor's hot-path query templates.
dsql
Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, foreign key…