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.
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.
curl -O https://raw.githubusercontent.com/apache/shardingsphere/master/.codex/skills/coding-standards/SKILL.mdgit clone --depth 1 https://github.com/apache/shardingsphereWrote 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/apache/shardingsphere/coding-standards)<a href="https://agentmods.dev/skills/apache/shardingsphere/coding-standards"><img src="https://agentmods.dev/badge/skills/apache/shardingsphere/coding-standards/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/apache/shardingsphere/coding-standards"><img src="https://agentmods.dev/badge/skills/apache/shardingsphere/coding-standards.svg" alt="Reviewed on agentmods" width="80" height="20"></a>- Snyk pass
- NVIDIA SkillSpector pass
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.00125 | $0.01840 |
| Opus 5.5 | $0.00050 | $0.00736 |
| Sonnet 5.5 | $0.00025 | $0.00368 |
| Haiku 4.5 | $0.00013 | $0.00184 |
Grade A, and why
coding-standards 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 10d 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.
How it starts
The opening of the file, as written. The whole thing — 79 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Coding Standards
Use this Skill in exactly one of the following modes. Both modes derive compliance only from written standards that actually apply to the target files.
For routing purposes, covered declaration annotations are HighFrequencyInvocation, AllArgsConstructor, RequiredArgsConstructor, NoArgsConstructor, Builder, Getter, Setter, EqualsAndHashCode, ToString, and Slf4j.
Implementation Guidance Mode
Use this mode when implementing, fixing, refactoring, or reviewing code, or when modifying or reviewing a Maven POM, unless the user explicitly requests a standalone coding-standards compliance audit. Read only the references whose conditions below match the affected files and task delta, and add each selected reference's applicable rules to one checklist grouped by governing file set.
- Before starting a read-only code review or making the first write in an implementation task, read the portions of
CODE_OF_CONDUCT.md, repository-level and path-levelAGENTS.md, Checkstyle, Spotless, and other written repository standards that actually apply to every affected file. - For a changed or reviewed
pom.xml, read Maven dependency version rules and apply them only to dependency declarations changed by the task. - Read Java naming rules when the task adds or changes a field, local variable, parameter, lambda, returned-value temporary or direct return, or enhanced loop. When a type declaration or its type annotations change, read Java type rules.
- Before adding or validating
HighFrequencyInvocation, apply theCODE_OF_CONDUCT.mddefinition by identifying the supported normal workload and verifying that the target's work repeats as that workload's throughput grows. Invocation after each DDL or explicit metadata refresh request proves reachability, not high frequency by itself. Leave applicability uncertain when normal-workload evidence is insufficient; do not add the annotation or rewrite Streams solely from reachability or theoretical repeatability. Do not require a TPS benchmark solely to classify these paths. - Before adding, changing, or reordering a covered declaration annotation, or when a Java declaration added or modified by the task contains at least two covered annotations, read the Java declaration annotation order rules through EOF and add each applicable rule to the checklist.
- Read Java constructor rules before changing an explicit or generated constructor or a field that may alter its signature or behavior.
- Before adding or changing a Java
throwstatement, a conditional branch that throws, a validation or precondition call, or a call toShardingSpherePreconditions, read the Java precondition rules through EOF and add each applicable rule to the checklist. - Before adding or changing a Java method annotated with
lombok.SneakyThrowsor changing the checked-exception behavior of such a method, read the Java exception handling rules through EOF and add each applicable rule to the checklist. - Before adding or changing a Java declaration whose type is a
java.util.Collectioninterface or implementation, read the Java collection declaration rules through EOF and add each applicable rule to the checklist. - Before adding or changing a Java expression that copies
Collections.singleton,Collections.singletonMap, orArrays.asListintoArrayList,LinkedList,HashMap, orLinkedHashMap, read the Java collection rules through EOF and add each applicable rule to the checklist. - Read Java expression rules before changing
==or!=when an operand may resolve to a named constant. - Before adding or changing a multi-line Java declaration header, statement, or expression, or a Java physical line that may exceed 200 characters, read the Java line-wrapping rules through EOF and add each applicable rule to the checklist.
- For every affected Java test file, read the Java test code rules through EOF and add each applicable rule to the checklist.
- Read defensive-code rules before adding, changing, removing, or reviewing a defensive construct.
- Apply each rule according to whether its text governs existing code or only the current task delta, and never beyond authorized scope.
- After the last write, manually recheck the effective task delta and only the surrounding declarations needed to evaluate every applicable checklist rule.
- For Java, explicitly verify every applicable
CODE_OF_CONDUCT.mdcoding rule, including declaration order; when a method uses private helpers, verify that those helpers immediately follow the caller and appear in the caller's call order, regardless of the caller's visibility. - For Java, explicitly verify every applicable Java declaration annotation order rule against each declaration added or modified by the task.
- For Java, explicitly verify every applicable Java exception handling rule against each added or modified
lombok.SneakyThrowsannotation and the method bodies, invoked signatures, rethrown values, and contracts needed to resolve its exception types. - For Java, explicitly verify every applicable Java collection declaration rule against the effective task delta and the operations, callers, callees, overrides, and contracts needed to determine the least-specific required declaration type.
- For Java, explicitly verify every applicable mutable-collection construction rule against the effective task delta and the operations, aliases, callers, callees, and contracts needed to determine whether mutability is required.
- For Java, when line-wrapping rules were selected, explicitly verify them against each applicable declaration header, statement, and expression added or modified by the task.
- For Java tests, explicitly verify every applicable Java test code rule against the effective task delta and the declarations and member types needed to resolve semantic applicability.
- Recheck every other selected rule only against the task delta and the context needed to decide applicability.
- Treat passing Checkstyle and Spotless as evidence only for the rules those tools enforce; neither result replaces the manual recheck.
- A later write invalidates final-check evidence only for affected files and rules; recheck those portions before verification or handoff.
- Do not invent rules from preference or nearby code, and do not report pre-existing violations outside task scope.
- Run the applicable formatting and standards checks required by the repository workflow.
- Do not run
apply,format, or another file-modifying command unless the current task authority and repository rules authorize every possible write. - Do not build a complete file inventory or count physical lines to report audit coverage in this mode. Measure the length of applicable Java constructs as required by the line-wrapping rules.
What ships with it
17 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.
- agents/openai.yaml 1.0 KB
- references/rules/defensive-code.md 9.0 KB
- references/rules/java-annotation-order.md 3.7 KB
- references/rules/java-collections.md 4.9 KB
- references/rules/java-constructors.md 2.3 KB
- references/rules/java-exceptions.md 2.5 KB
- references/rules/java-expressions.md 1.9 KB
- references/rules/java-line-wrapping.md 5.9 KB
- references/rules/java-naming.md 5.7 KB
- references/rules/java-preconditions.md 4.2 KB
- references/rules/java-testing.md 4.2 KB
- references/rules/java-types.md 1.5 KB
- references/rules/maven-dependencies.md 6.8 KB
- references/standalone-audit.md 11 KB
- scripts/build_audit_inventory.py 15 KB runs code
- scripts/tests/test_build_audit_inventory.py 17 KB runs code
- scripts/tests/test_checkstyle_rules.py 6.9 KB runs code
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.
- 10d ago Changed · +1 lines f6da1b8de5d3
- 17d ago Changed · +4 lines 0e6a3aa96574
- 1mo ago Changed · -30 lines · +29 tokens per session 7657b130de1d
- 1mo ago Changed · -2 lines · +7 tokens per session a9b0e45e7585
- 1mo ago Changed · +4 lines 81daa94da796
- 1mo ago Changed · +3 lines 346bfeb043ce
- 1mo ago Changed · +3 lines 43acd6057f78
- 1mo ago Changed · +18 lines 7fd233f0243b
- 1mo ago Changed · +9 lines · +5 tokens per session 4782e1bd0f54
- 1mo ago First seen · 69 lines · 84 tokens per session scan A 190b4a7af6c7
coding-standards is a skill published in the GitHub repository apache/shardingsphere (20,817 stars, last pushed today), licensed Apache-2.0. It adds 125 tokens to every session and 1,840 once invoked, about $0.0005 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.
Other skills, from other repositories
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.
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.
react-class-to-functional
Convert React class components to functional components with hooks.
relational-database-design
Designs or reviews a relational database schema for a given domain. Covers table structure, normalization, indexes, constraints, and migration strategy. Invoked when the user asks to design a schema, review a database structure, or optimize a data model.
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.
SQL Query Optimizer
Reviews SQL queries for performance issues and rewrites them with optimized execution plans.