shardingsphere: Skill for Codex

.codex/skills/code-implementation/SKILL.md

code-implementation is a skill for Codex from apache/shardingsphere. It costs 90 tokens per session (1,031 once invoked), scanned A, original, Apache-2.0.

A set of rules for implementing, fixing, refactoring, or removing repository code and verifying the resulting changes.

In plain words
What is it for?
Use it for production code, tests, scripts, build logic, generated files, and behavior-changing configuration.
Why use it?
It reduces regressions by requiring the right project rules, testing decisions, and verification steps before handoff.

Skill for Codex ✓ vendor

Written for Codex: agents/openai.yaml present. Also seen: reads ~/.codex paths; mentions AGENTS.md; mentions Codex.

This is apache/shardingsphere's own configuration. It tells Codex how to work on shardingsphere itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything shardingsphere configures →

About the project

Apache ShardingSphere is a database enhancement layer that makes heterogeneous databases easier to access and govern as a unified system, without replacing the underlying databases. It supports distributed database capabilities such as sharding, read-write splitting, SQL federation, encryption, masking, auditing, and traffic control for enterprise data architectures.

apache/shardingsphere · 20,817 stars · on GitHub

Reuse

Borrowing it

Nothing to install: this file belongs to apache/shardingsphere. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/apache/shardingsphere/master/.codex/skills/code-implementation/SKILL.md
Clone the repo
git clone --depth 1 https://github.com/apache/shardingsphere

Made for: Codex.

Wrote 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.

agentmods badge for code-implementation

README.md
[![agentmods](https://agentmods.dev/badge/skills/apache/shardingsphere/code-implementation/github.svg)](https://agentmods.dev/skills/apache/shardingsphere/code-implementation)
Your own site
<a href="https://agentmods.dev/skills/apache/shardingsphere/code-implementation"><img src="https://agentmods.dev/badge/skills/apache/shardingsphere/code-implementation/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.

agentmods 80×15 button for code-implementation

Your own site · 80×15
<a href="https://agentmods.dev/skills/apache/shardingsphere/code-implementation"><img src="https://agentmods.dev/badge/skills/apache/shardingsphere/code-implementation.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 90 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,031 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits
  • NVIDIA SkillSpector warn 7 Sept 2026
SkillSpector: 2 findings, up to medium

These are SkillSpector’s own severities. On a checked sample its high-severity flags on skills were ~96% false positives — a documented command, a public API, a “never do X” rule — so we show them as a caution to read, not a verdict. Why →

  • medium Agent Snooping · line 17
    Skill enumerates or reads other installed skills. Access to other skills' SKILL.md files or the skills directory reveals prompt instructions, capabilities, and secrets that should be invisible to peer skills.
    Fix: Remove all code or instructions that list or read other skills' files or directories. Skills should operate independently; cross-skill access is a privilege escalation.
  • medium Excessive Agency · line 25
    Skill enables autonomous high-impact decisions without human-in-the-loop verification. Critical operations (destructive commands, financial transactions, data deletion) should require explicit user confirmation.
    Fix: Add human-in-the-loop confirmation for destructive, irreversible, or high-impact operations. Never auto-execute commands that modify files, send data, or alter system state.
How audits are shown
Origin original No closer match found in the catalogue.
Token cost

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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00090 $0.01031
Opus 5.5 $0.00036 $0.00412
Sonnet 5.5 $0.00018 $0.00206
Haiku 4.5 $0.00009 $0.00103

Measured 12d ago against content hash 5b39d28fb358, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

code-implementation 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 12d 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.

.codex/skills/code-implementation/SKILL.md · 38 lines

How it starts

The opening of the file, as written. The whole thing — 38 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Code Implementation

AGENTS.md remains authoritative for scope, permission, safety, architecture, and task lifecycle. Reading this Skill does not grant write, Git, remote, file-type, or scope authority.

Required References

Read every selected reference through EOF before relying on it. Do not substitute catalog metadata, a summary, another Skill, or ordinary coding judgment for a required repository source.

  • For every code-affecting write, read .codex/skills/code-implementation/references/rules/implementation.md.
  • Before loading the testing rules, use these routing facts: for Maven source trees only src/main/** may be the subject of added or updated tests; a change confined to src/test/** requires no additional coverage; and a script, configuration, policy, or harness change needs tests only when an existing focused test mechanism protects its behavior. Read .codex/skills/code-implementation/references/rules/testing.md before assessing test scenarios for changed src/main/** behavior, satisfying requested test or coverage work, or creating or changing a test.
  • Read .codex/skills/code-implementation/references/rules/artifact-removal-and-contract-impact.md before removing or replacing an owner, classifying an artifact as unused or removable, changing a public or externally visible contract, or modifying an affected snapshot, golden file, registration, loading path, or workflow filter.
  • Read .codex/skills/code-implementation/references/rules/non-regression.md when a change affects a public or shared contract, crosses behavior owners, or has credible functional or performance risk. Otherwise preserve supported behavior through the implementation rules and focused owner checks without loading the full reference.
  • Read .codex/skills/code-implementation/references/verification.md before the first repository check and reuse it while the task state is unchanged.
  • For production or test Java and Maven POM changes, read .codex/skills/coding-standards/SKILL.md through EOF and use its Implementation Guidance Mode. For other artifacts, inspect only written standards that govern the changed files. Do not run the standalone inventory or physical-line audit unless the user requests that audit.

Read the full file on GitHub · 38 lines

Files

What ships with it

6 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.

Changes

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.

  1. 12d ago Changed · +3 lines 5b39d28fb358
  2. 1mo ago Changed · -3 lines a9f963971097
  3. 1mo ago Changed · +2 lines 413fc0c57b04
  4. 1mo ago First seen · 36 lines · 90 tokens per session scan A 6563786b671a

Subscribe to this mod's changes

code-implementation is a skill published in the GitHub repository apache/shardingsphere (20,817 stars, last pushed today), licensed Apache-2.0. It adds 90 tokens to every session and 1,031 once invoked, about $0.0004 per session on Opus 5.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.

Related

Other skills, from other repositories

ui-visual-regression

Automates visual regression testing for DB Console UI changes. Compares screenshots and network requests between the current branch and its merge base using roachprod, playwright-cli, and ImageMagick. Use when the user wants to verify UI changes haven't introduced visual or behavioral regressions.

cockroachdb/cockroach · 61 tokens

review-prs

Review a GitHub pull request in the googleapis/mcp-toolbox repo against the team's reviewer checklist: PR title/description conventions, linked issue, logic errors and unhandled edge cases, breaking changes, test coverage, docs updates, security (input handling), and new dependencies. Use whenever a maintainer asks…

googleapis/mcp-toolbox · 162 tokens

database-testing

Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance. Use when testing data persistence, ensuring referential integrity, or validating database migrations.

proffesor-for-testing/agentic-qe · 37 tokens

redux-to-swr

Migrate React components from Redux + Saga to SWR hooks. Use when converting data fetching from Redux store (reducers, sagas, selectors, connect HOC) to SWR-based hooks in CockroachDB DB Console or cluster-ui.

cockroachdb/cockroach · 53 tokens

mma-investigator

Expert system for investigating MMA (Multi-Metric Allocator) behavior on CockroachDB clusters. Helps oncall engineers diagnose load imbalances, understand rebalancing decisions, and identify why MMA did or didn't act.

cockroachdb/cockroach · 47 tokens

react-class-to-functional

Convert React class components to functional components with hooks.

cockroachdb/cockroach · 14 tokens