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 johnqtcg/awesome-skills --skill oceanbase-table-designgit clone --depth 1 https://github.com/johnqtcg/awesome-skillsWrote 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/johnqtcg/awesome-skills/oceanbase-table-design)<a href="https://agentmods.dev/skills/johnqtcg/awesome-skills/oceanbase-table-design"><img src="https://agentmods.dev/badge/skills/johnqtcg/awesome-skills/oceanbase-table-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/johnqtcg/awesome-skills/oceanbase-table-design"><img src="https://agentmods.dev/badge/skills/johnqtcg/awesome-skills/oceanbase-table-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.00111 | $0.08486 |
| Opus 5 | $0.00056 | $0.04243 |
| Sonnet 5 | $0.00022 | $0.01697 |
| Haiku 4.5 | $0.00011 | $0.00849 |
Grade C, and why
oceanbase-table-design scanned grade C with 1 finding 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 3d 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.
Tells the agent never to refusehighAnti-refusal
Suppressing the ability to decline removes a core safety control; a later harmful request then succeeds.
- **Only L1/L2 suboptimal** → **do not refuse**. Output 2+ options plus a trade-off matrix, flagging what needs benchmarking. How it starts
The opening of the file, as written. The whole thing — 415 lines — stays where its author put it; the contents beside it link to each section on GitHub.
OceanBase Table Design Skill (Distributed Modeling Expert Edition)
1. Role
You are an OceanBase distributed database modeling expert: design DDL from a business workload, quantify the high-cost paths inherent to distributed systems, and exploit the product's capabilities (partitioning, local indexes, table groups, duplicated tables, columnstore, lifecycle management) to produce something explainable, verifiable, and actionable.
The goal is not SQL, but:
a design that satisfies the target version and mode's physical and syntactic constraints -- and when it cannot, an actionable alternative instead of a vague pass.
Syntax baseline: OceanBase V4.5.0 (see the two BNF mirrors under references/). When the target version differs, the capability matrix must be checked first.
2. Rule Tiers (apply throughout, must be followed)
Every conclusion must map to a tier below. Mixing tiers is the mistake this skill most needs to avoid, and one direction matters most: only L0 may stop you from emitting DDL.
| Tier | Meaning | Agent behavior |
|---|---|---|
| L0 Hard constraint | The target version / mode rejects the statement | Block DDL generation, give an alternative |
| L1-B Design blocker | The DDL is legal and must still be generated, but the design is wrong in the general case and the damage is quantifiable | Emit the DDL and the corrected design; verdict defaults to fail with the damage quantified; tag rule_tier: L1_blocker. Downgrade to accepted_with_reason only on an explicit user purpose. Never grounds for calling a design infeasible |
| L1 Default recommendation | A directionally correct default | Adopt it, state benefit and exceptions; overridable on a counter-example |
| L2 Threshold to be verified | Empirical, depends on version / spec / workload | Suggest a value, tag rule_tier: L2_unverified, require benchmarking |
One question decides the L0 / L1-B boundary: would the server reject this statement? "Wastes resources", "will be skewed" and "cannot be pruned" are all L1-B -- the server accepts every one. Promoting any to L0 blocks legal designs that may have a deliberate purpose.
What ships with it
59 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
- .gitignore 133 B
- references/anti-patterns.md 7.4 KB
- references/capability-matrix.md 25 KB
- references/doc-gaps.md 18 KB
- references/hotspots.md 12 KB
- references/indexes.md 18 KB
- references/input-collection.md 9.2 KB
- references/mysql_mode_create_table_syntax.md 6.9 KB
- references/oracle_mode_create_table_syntax.md 7.3 KB
- references/output-contract.md 7.2 KB
- references/partitioning.md 30 KB
- references/sources.md 5.4 KB
- references/special-indexes.md 8.4 KB
- references/storage-format.md 20 KB
- references/tablegroup.md 7.9 KB
- references/tablet-capacity.md 13 KB
- references/verification.md 12 KB
- scripts/check_consistency.py 22 KB runs code
- scripts/check_negative_log.py 7.8 KB runs code
- scripts/estimate_tablets.py 37 KB runs code
- scripts/gen_toc.py 7.2 KB runs code
- scripts/run_cases.py 22 KB runs code
- scripts/run_integration.sh 11 KB runs code
- scripts/run_regression.sh 3.5 KB runs code
- scripts/tests/COVERAGE.md 13 KB
- scripts/tests/golden/001_autoinc_mode_gate.json 560 B
- scripts/tests/golden/002_tenant_default_format.json 435 B
- scripts/tests/golden/003_ndv_gt_partitions.json 746 B
- scripts/tests/golden/004_htap_foutiers.json 406 B
- scripts/tests/golden/005_tablemode_compaction.json 424 B
- scripts/tests/golden/006_hotspot_read_direction.json 438 B
- scripts/tests/golden/007_special_index.json 455 B
- scripts/tests/golden/008_input_collection.json 464 B
- scripts/tests/golden/009_doc_conflict_split.json 501 B
- scripts/tests/golden/010_special_index.json 422 B
- scripts/tests/test_golden_scenarios.py 6.2 KB runs code
- scripts/tests/test_mutation_sweep.py 23 KB runs code
- scripts/tests/test_skill_contract.py 60 KB runs code
- tests/cases.json 28 KB
- tests/cases.md 23 KB
- tests/integration/explain_v430.sql 469 B
- tests/integration/explain.sql 2.6 KB
- tests/integration/mysql_base.sql 4.7 KB
- tests/integration/mysql_negative.sql 5.3 KB
- tests/integration/mysql_probe.sql 4.0 KB
- tests/integration/mysql_v430.sql 1.1 KB
- tests/integration/mysql_v435.sql 793 B
- tests/integration/mysql_v435bp1.sql 710 B
- tests/integration/oracle_mode.sql 3.8 KB
- tests/integration/oracle_negative.sql 2.3 KB
- tests/integration/README.md 7.6 KB
- tests/integration/storage_base.sql 550 B
- tests/integration/storage_negative.sql 542 B
- tests/integration/storage_probe.sql 2.8 KB
- tests/integration/storage_v430.sql 1.7 KB
- tests/integration/tablegroup_negative.sql 1.3 KB
- tests/integration/tablegroup_probe.sql 2.3 KB
- tests/integration/tablegroup.sql 2.7 KB
- tests/integration/tablet.sql 3.7 KB
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.
- 3d ago Changed · +1 lines f40e8933b0c5
- 11d ago First seen · 414 lines · 111 tokens per session scan C cdf582a00f7d
oceanbase-table-design is a skill published in the GitHub repository johnqtcg/awesome-skills (30 stars, last pushed today), licensed MIT. It adds 111 tokens to every session and 8,486 once invoked, about $0.0006 per session on Opus 5. A static security scan graded it C with 1 finding (tells the agent never to refuse). No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.
Other skills, from other repositories
security-compliance
Guides security professionals in implementing defense-in-depth security architectures, achieving compliance with industry frameworks (SOC2, ISO27001, GDPR, HIPAA), conducting threat modeling and risk assessments, managing security operations and incident response, and embedding security throughout the SDLC.
cache-components
Expert guidance for Next.js Cache Components and Partial Prerendering (PPR). PROACTIVE ACTIVATION: Use this skill automatically when working in Next.js projects that have cacheComponents: true in their next.config.ts/next.config.js. When this config is detected, proactively apply Cache Components patterns and best…
manage-skills
A maintenance workflow for checking whether project verification skills still cover the code and rules that changed during a session.
stride-analysis-patterns
Apply STRIDE methodology to systematically identify threats. Use when analyzing system security, conducting threat modeling sessions, or creating security documentation.
blind-spot-pass
Use before starting work in a domain you don't know well, to surface the "unknown unknowns" — the things you don't even know to ask about — and learn just enough to prompt and decide well. Implements the "blind spot pass" pattern from Anthropic's Fable "finding your unknowns" field guide. Triggers when you say "I'm…
skill-factory
A workflow that examines completed session work and turns reusable patterns into Claude Code skills.