New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Code Implementation

by apache in apache/shardingsphere

Implement, fix, refactor, or remove repository code under required scope, non-regression, verification, and review gates.

Apache-2.0Auto-check passedDatabases

Install Code Implementation

skills CLI
$ npx skills add apache/shardingsphere --skill code-implementation -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install apache/shardingsphere code-implementation --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/apache/shardingsphere.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.codex/skills/code-implementation .claude/skills/code-implementation && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
code-implementation
GitHub stars
21k
Token cost
~1.2k tokens
SKILL.md length
577 words
Files
7 (incl. references)
Skills in repo
5
Repo updated
First seen
Licence
Apache-2.0

At a glance

Implement, fix, refactor, or remove repository code under required scope, non-regression, verification, and review gates.

  • Works in 8 steps: Apply the pre-write gates in AGENTS.md… → Map every planned production and test… → Classify functional and performance risk… → …
  • A task may change a production
  • SKILL.md covers Required References and Workflow
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Code Implementation is an agent skill from apache/shardingsphere. Implement, fix, refactor, or remove repository code under required scope, non-regression, verification, and review gates. Use whenever a task may change a production, test, script, or other implementation artifact, including build logic, generated source, and behavior-affecting configuration. Also use it alongside a specialized code-changing Skill. Do not use for read-only analysis or review, diagnosis-only work, or prose-only changes.

Its SKILL.md is about 1.2k tokens, which your agent loads only when the skill is triggered. The skill folder holds 9 other files, including reference files (for example `agents/openai.yaml`, `references/rules/artifact-removal-and-contract-impact.md` and `references/rules/implementation.md`).

It sits in Databases, covering Human-in-the-loop approvals. It works with SQL. The repository describes itself as: Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases. The licence is Apache-2.0.

When your agent uses it

  • A task may change a production
  • Other implementation artifact
  • Including build logic
  • Generated source

Example prompts

  • “/code-implementation”

Workflow steps

8 steps, taken from the first numbered list in SKILL.md.

  1. Apply the pre-write gates in AGENTS.md and freeze file -> allowed change intent -> unmet acceptance criterion. Infer clearly authorized…
  2. Map every planned production and test change to one unsatisfied acceptance criterion and identify the supported existing paths that the…
  3. Classify functional and performance risk before the first relevant write. Preserve supported behavior outside the exact requested change…
  4. Implement the smallest clear change under the implementation rules, and apply the testing rules when their trigger above matches.
  5. After each coherent edit batch, inspect every changed path and hunk. Inspect immediately after a formatter, generator, bulk replacement…
  6. Complete this step when Coding Standards applies. After the last implementation write, reapply the Coding Standards Implementation…
  7. Run the narrowest meaningful checks under the verification rules. Reuse a passing result while its task state and evidence remain…
  8. After verification, follow .codex/context/change-completion.md as the sole completion-loop orchestration owner.

What it can do on your machine

Read from SKILL.md and the folder at commit 44e364e. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Code Implementation loads about 1.2k tokens when it runs, and up to ~9.2k if it reads all its reference files. Until then it costs about 115 tokens; SKILL.md has 577 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~115
When it runs · the whole SKILL.md, loaded when a task matches
~1.2k
With references · SKILL.md plus every file in references/, read only if the agent opens them
~9.2k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from apache/shardingsphere at commit 44e364e, republished under its Apache-2.0 licence (© apache). 577 words, ~1,214 tokens.

Download SKILL.mdSave it as .claude/skills/code-implementation/SKILL.md (or your agent's skills folder). This skill also uses 6 other files; get the full folder from GitHub.
name
code-implementation
description
Implement, fix, refactor, or remove repository code under required scope, non-regression, verification, and review gates. Use whenever a task may change a production, test, script, or other implementation artifact, including build logic, generated source, and behavior-affecting configuration. Also use it alongside a specialized code-changing Skill. Do not use for read-only analysis or review, diagnosis-only work, or prose-only changes.

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.

Specialized repository Skills compose with this Skill when they write code. Their narrower rules add to these rules and do not replace them.

Show full SKILL.md (282 more words)Show less

Workflow

  1. Apply the pre-write gates in AGENTS.md and freeze file -> allowed change intent -> unmet acceptance criterion. Infer clearly authorized paths without asking the user to repeat the request; expand only with exact additional path and intent authorization.
  2. Map every planned production and test change to one unsatisfied acceptance criterion and identify the supported existing paths that the change can affect.
  3. Classify functional and performance risk before the first relevant write. Preserve supported behavior outside the exact requested change; when the full non-regression reference is triggered, capture its required baseline before editing.
  4. Implement the smallest clear change under the implementation rules, and apply the testing rules when their trigger above matches.
  5. After each coherent edit batch, inspect every changed path and hunk. Inspect immediately after a formatter, generator, bulk replacement, or another action whose write set is not exact. Stop at the existing scope or authority gate when a required change lies outside the frozen boundary.
  6. Complete this step when Coding Standards applies. After the last implementation write, reapply the Coding Standards Implementation Guidance Mode to affected files and complete its final manual checklist recheck before final verification. Any later write returns the affected files and rules to this step.
  7. Run the narrowest meaningful checks under the verification rules. Reuse a passing result while its task state and evidence remain unchanged; rerun only checks invalidated by a relevant write, failure, scope change, or new evidence.
  8. After verification, follow .codex/context/change-completion.md as the sole completion-loop orchestration owner.

Do not treat a passing build, test, formatter, benchmark, or review tool as proof by itself. Judge the requested behavior, supported existing behavior, contracts, architecture, and affected performance paths directly.

© apache, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 6 other files (references) in .codex/skills/code-implementation of apache/shardingsphere.

  • SKILL.md
  • agents/openai.yaml
  • references/rules/artifact-removal-and-contract-impact.md
  • references/rules/implementation.md
  • references/rules/non-regression.md
  • references/rules/testing.md
  • references/verification.md

Open the folder on GitHubat commit 44e364e

Compare with similar skills

Code Implementation next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Code Implementation compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Code Implementation this skillapache/shardingsphere21k—~1.2kAutomated safety check: PassApache-2.0
Analyzing Dataastronomer/agents451—~1.3kAutomated safety check: PassApache-2.0
Basincloudflare/skills3k1 repos~684Automated safety check: PassApache-2.0
VisualizationFrankChen021/datastoria327—~1.2kAutomated safety check: PassCustom licence
Databricks Dbsqldatabricks/databricks-agent-skills3451 repos~2.8kAutomated safety check: PassCustom licence
Rocky Dsl Changerocky-data/rocky304—~1.3kAutomated safety check: PassApache-2.0

Similar skills

  • Analyzing Data

    astronomer/agents

    Queries the data warehouse with SQL and answers business questions about data.

    451 GitHub stars~1.3k tokensUpdated today
    DatabasesAuto-check passed

  • Basin

    cloudflare/skills

    Official

    Build and troubleshoot Cloudflare Basin analytics workflows with Basin Pipelines, Basin Catalog, and Basin SQL.

    3k GitHub starsUsed in 1 repo~684 tokens
    DatabasesAuto-check passed

  • Visualization

    FrankChen021/datastoria

    Rules for charts and visualization. An agent skill from FrankChen021/datastoria.

    327 GitHub stars~1.2k tokensUpdated 2 mo ago
    DatabasesAuto-check passed

  • Databricks Dbsql

    databricks/databricks-agent-skills

    Official

    Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities.

    345 GitHub starsUsed in 1 repo~2.8k tokens
    DatabasesAuto-check passed

  • Rocky Dsl Change

    rocky-data/rocky

    Rocky DSL (.rocky file) cross-subproject cascade. An agent skill from rocky-data/rocky.

    304 GitHub stars~1.3k tokensUpdated today
    DatabasesAuto-check passed

  • Expensive Snowflake Query Finder

    AltimateAI/data-engineering-skills

    Ranks the costliest, slowest or heaviest-scanning Snowflake queries from query history and suggests how to optimize them.

    128 GitHub stars~662 tokensUpdated 6 days ago
    DatabasesAuto-check passed

More from apache/shardingsphere

  • Review PR

    apache/shardingsphere

    Review Apache ShardingSphere or user-authorized downstream pull requests and PR discussions from public or authorized repository evidence.

    21k GitHub stars~6.4k tokensUpdated today
    Auto-check passed

  • Coding Standards

    apache/shardingsphere

    Apply Apache ShardingSphere's written coding standards when explicitly requested, or when code-implementation routes task-changed production, test, script, build, generated, or Maven POM artifacts…

    21k GitHub stars~2.2k tokensUpdated today
    Auto-check passed

  • Gen Ut

    apache/shardingsphere

    Generate standard unit tests for one or more target classes in Apache ShardingSphere; cover requested behavior and every affected SUT-owned branch, enforce an explicitly requested numeric coverage…

    21k GitHub stars~3k tokensUpdated today
    Auto-check passed

  • Analyze Issue

    apache/shardingsphere

    Used to analyze Apache ShardingSphere community issues. An agent skill from apache/shardingsphere.

    21k GitHub stars~6.5k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Code Implementation

What does Code Implementation do?

Implement, fix, refactor, or remove repository code under required scope, non-regression, verification, and review gates. Code Implementation is an agent skill from apache/shardingsphere. Implement, fix, refactor, or remove repository code under required scope, non-regression, verification, and review gates.

When should I use Code Implementation?

Code Implementation fits situations like: A task may change a production; other implementation artifact; including build logic; generated source.

How do I install Code Implementation in Claude Code?

Run `npx skills add apache/shardingsphere --skill code-implementation -a claude-code`. Or copy the skill folder (.codex/skills/code-implementation in apache/shardingsphere) into .claude/skills/code-implementation in your project. Claude Code loads it when a task matches its description.

How do I install Code Implementation in Codex?

Run `npx skills add apache/shardingsphere --skill code-implementation -a codex`. Or copy the skill folder (.codex/skills/code-implementation in apache/shardingsphere) into .agents/skills/code-implementation in your project. Codex loads it when a task matches its description.

Can I use Code Implementation in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add apache/shardingsphere --skill code-implementation -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/code-implementation, .gemini/skills/code-implementation, .github/skills/code-implementation and .opencode/skills/code-implementation in your project.

What does Code Implementation need to run?

SKILL.md names no scripts, command-line tools or credentials: Code Implementation is instructions for the agent only.

Does Code Implementation access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Code Implementation safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Code Implementation use?

Code Implementation is published under the Apache-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Code Implementation use?

About 1.2k tokens (SKILL.md is roughly 4.9k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 8k tokens, read only when the agent opens those files.

What are the alternatives to Code Implementation?

Skills that share tags, products or a category with Code Implementation: Analyzing Data (astronomer/agents, 451 stars), Basin (cloudflare/skills, 3k stars), Visualization (FrankChen021/datastoria, 327 stars) and Databricks Dbsql (databricks/databricks-agent-skills, 345 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Code Implementation?

apache (a GitHub organization) maintains it in apache/shardingsphere, which has 20,804 GitHub stars. The repository holds 5 skills in this directory. The repository was last updated on October 7, 2026.

Source: apache/shardingsphere on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.