cosid-sharding SKILL.md skillA

This file is byte-identical to the first copy the registry indexed. Same content hash, so the same checks give both the same grade.

cosid-sharding from ahoo-wang/skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add ahoo-wang/skills/cosid-sharding@git:20261027.4a2e10f

Pins git:20261027.4a2e10f in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
ahoo-wang/skills
Path
sources/CosId/skills/cosid-sharding/SKILL.md
Versions recorded
5
Latest version
git:20261027.4a2e10f, committed Oct 27, 2026
First version recorded
May 27, 2026
Size
6,680 bytes
Repository stars
2
License
Apache-2.0

Design, implement, and validate database sharding with the cosid-sharding module (ModCycle, IntervalTimeline, CachedSharding, ShardingRange, StandardLocalDateTimeConvertor, SnowflakeLocalDateTimeConvertor on a Layout) or ShardingSphere's COSID_MOD, COSID_INTERVAL and COSID_INTERVAL_SNOWFLAKE algorithms. Use for modulo routing, date/time partitions, Snowflake timestamp routing, exact/IN/range behavior, effective nodes, suffix naming, or routing tests. Do not use for choosing an ID generator…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Design CosId Sharding

Treat the core Java sharding API and ShardingSphere configuration as separate integration surfaces. The algorithms
live in `me.ahoo.cosid:cosid-sharding` (package `me.ahoo.cosid.sharding`), released with CosId and depending on
`cosid-core` only (D7). In CosId 5 a range is a `ShardingRange` (Guava's `Range` is gone; the factory names are the
same), and the Snowflake convertor takes a `Layout`. Verify the target CosId and ShardingSphere versions before copying
property names.

## Workflow

1. Identify the sharding key type and every query operator that must route: exact, `IN`, and range.
2. Define physical nodes, naming, bounds, and future partition provisioning before selecting an algorithm.
3. Choose `ModCycle` for fixed-count numeric distribution or `IntervalTimeline` for time partitions.
4. Add Snowflake conversion only when the id `Layout` (epoch, unit, bits) is known.
5. Build a routing matrix that covers boundaries, out-of-range values, and full-range queries.

## Core Algorithms

| API | Use | Important behavior |
|---|---|---|
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add ahoo-wang/skills/cosid-sharding@sha256:144167c08e09e6be

The line at the top of this page pins the label git:20261027.4a2e10f, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_uoimrvmyk3q5mzub.svg)](https://markdownregistry.com/a/art_uoimrvmyk3q5mzub)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 5 versions of this file, between May 27, 2026 and Oct 27, 2026, about one every 38 days.

versioncommittedcommitsizeaudit
git:20261027.4a2e10f latest2026-10-27 4a2e10f 6,680 BA view · diff
git:20261012.e4b9d002026-10-12 e4b9d00 6,120 BA view · diff
git:20260818.2ff7b222026-08-18 2ff7b22 5,920 BA view · diff
git:20260817.88affa12026-08-17 88affa1 10,051 BA view · diff
git:20260527.808710c2026-05-27 808710c 9,204 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (6680 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

ahoo-wang/skills · 2 stars · license Apache-2.0 · pushed 2026-11-05 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_uoimrvmyk3q5mzub
GET https://markdownregistry.com/api/v1/resolve?ref=ahoo-wang/skills/cosid-sharding
GET https://markdownregistry.com/api/v1/blob/144167c08e09e6beb1bc60d4fab9dd709d697ceae787347df3c7595ee9323a4b

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from ahoo-wang/skills

AGENTS.md AGENTS.md file
ahoo-wang/skills · AGENTS.md
git:20261008.51694f7 · audit A · 2 stars
CLAUDE.md CLAUDE.md file
ahoo-wang/skills · CLAUDE.md
git:20260527.808710c · audit A · 2 stars
agent-system-prompt SKILL.md skill
ahoo-wang/skills · plugins/ahoo-agent-skills/skills/agent-system-prompt/SKILL.md · Use this skill when the user needs to write the actual instructional text that defines how an AI agent behaves. This is…
git:20260527.808710c · audit A · 2 stars
coapi-developer SKILL.md skill
ahoo-wang/skills · plugins/ahoo-coapi-skills/skills/coapi-developer/SKILL.md · Help developers use and maintain CoApi, a Spring HTTP Interface client auto-configuration library for typed…
git:20261010.7e97337 · audit A · 2 stars
cocache-develop SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cocache-skills/skills/cocache-develop/SKILL.md · Build, test, review or debug CoCache usage in downstream Java/Kotlin applications with me.ahoo.cocache imports or…
git:20261104.ba3fe59 · audit A · 2 stars
cocache-extend SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cocache-skills/skills/cocache-extend/SKILL.md · Implement or fix a CoCache CoherenceBackend (L1Store or FutureL1Store, plus InvalidationChannel) outside the CoCache…
git:20261104.ba3fe59 · audit A · 2 stars
cosec-custom-matcher SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cosec-skills/skills/cosec-custom-matcher/SKILL.md · Extend CoSec 8.0 with Spring beans - AttributeProvider (external ext.* attributes fetched per request)…
git:20261029.b6d8370 · audit A · 2 stars
cosec-integration SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cosec-skills/skills/cosec-integration/SKILL.md · Integrate CoSec 8.0 into a Spring Boot service - choose the CoSec modules to add next to the starter (WebFlux, WebMVC…
git:20261103.b03b7c5 · audit A · 2 stars
cosec-policy-author SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cosec-skills/skills/cosec-policy-author/SKILL.md · Write, review, validate, or explain CoSec 8.0 policy documents (platform, app and tenant documents) - policies and…
git:20261105.70ae746 · audit A · 2 stars
cosec-troubleshoot SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cosec-skills/skills/cosec-troubleshoot/SKILL.md · Diagnose CoSec 8.0 failures - startup failures (unknown cosec.* keys, pipeline mode, Redis eviction check, missing…
git:20261105.70ae746 · audit A · 2 stars
cosid-manual-integration SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cosid-skills/skills/cosid-manual-integration/SKILL.md · Integrate CosId 5 programmatically into Java or Kotlin applications without Spring Boot. Use for building a RuntimeSpec…
git:20261029.b6d8370 · audit A · 2 stars
cosid-sharding SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cosid-skills/skills/cosid-sharding/SKILL.md · Design, implement, and validate database sharding with the cosid-sharding module (ModCycle, IntervalTimeline…
git:20261027.4a2e10f · audit A · 2 stars

Every file in ahoo-wang/skills

Other files named cosid-sharding

cosid-sharding SKILL.md skill
ahoo-wang/skills · plugins/ahoo-cosid-skills/skills/cosid-sharding/SKILL.md · Design, implement, and validate database sharding with the cosid-sharding module (ModCycle, IntervalTimeline…
git:20261027.4a2e10f · audit A · 2 stars

Browse by kind, by grade A, or by owner.