Cosmosdb Nosql Query Generation
microsoft/vscode-cosmosdb
Generate, explain, edit, and fix Azure Cosmos DB for NoSQL (SQL API) queries.
Rocky DSL (.rocky file) cross-subproject cascade. An agent skill from rocky-data/rocky.
$ npx skills add rocky-data/rocky --skill rocky-dsl-change -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install rocky-data/rocky rocky-dsl-change --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/rocky-data/rocky.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/rocky-dsl-change .claude/skills/rocky-dsl-change && rm -rf skills-srcUse ~/.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/
Install the "rocky-dsl-change" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-dsl-change into .claude/skills/rocky-dsl-change/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-dsl-change", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-dsl-changeType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add rocky-data/rocky --skill rocky-dsl-change -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install rocky-data/rocky rocky-dsl-change --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rocky-data/rocky.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.agents/skills/rocky-dsl-change .agents/skills/rocky-dsl-change && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "rocky-dsl-change" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-dsl-change into .agents/skills/rocky-dsl-change/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-dsl-change", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add rocky-data/rocky --skill rocky-dsl-change -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install rocky-data/rocky rocky-dsl-change --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rocky-data/rocky.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.agents/skills/rocky-dsl-change .cursor/skills/rocky-dsl-change && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "rocky-dsl-change" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-dsl-change into .cursor/skills/rocky-dsl-change/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-dsl-change", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/rocky-data/rocky.git --path .agents/skills/rocky-dsl-change--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add rocky-data/rocky --skill rocky-dsl-change -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install rocky-data/rocky rocky-dsl-change --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rocky-data/rocky.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.agents/skills/rocky-dsl-change .gemini/skills/rocky-dsl-change && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "rocky-dsl-change" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-dsl-change into .gemini/skills/rocky-dsl-change/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-dsl-change", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install rocky-data/rocky rocky-dsl-changeInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add rocky-data/rocky --skill rocky-dsl-change -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/rocky-data/rocky.git skills-src && mkdir -p .github/skills && cp -r skills-src/.agents/skills/rocky-dsl-change .github/skills/rocky-dsl-change && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "rocky-dsl-change" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-dsl-change into .github/skills/rocky-dsl-change/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-dsl-change", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add rocky-data/rocky --skill rocky-dsl-change -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install rocky-data/rocky rocky-dsl-change --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/rocky-data/rocky.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.agents/skills/rocky-dsl-change .opencode/skills/rocky-dsl-change && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "rocky-dsl-change" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-dsl-change into .opencode/skills/rocky-dsl-change/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-dsl-change", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
rocky-dsl-changeRocky DSL (.rocky file) cross-subproject cascade. An agent skill from rocky-data/rocky.
Rocky Dsl Change is an agent skill from rocky-data/rocky. Rocky DSL (.rocky file) cross-subproject cascade. Use when adding/changing a Rocky DSL keyword, operator, or pipeline step — changes must land in the engine parser, compiler, VS Code TextMate grammar, and snippets together in one PR.
Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Databases. It works with Visual Studio Code and SQL. The repository describes itself as: A SQL transformation engine that type-checks your whole pipeline and catches breaking changes before they run — branches, replay, column-level lineage, compile-time contracts… The licence is Apache-2.0.
7 steps, taken from the first numbered list in SKILL.md.
Read from SKILL.md and the folder at commit 365aebf. It shows what the files ask for, not the result of running them.
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.
Shell commands in SKILL.md call:
justFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Rocky Dsl Change loads about 1.3k tokens when it runs. Until then it costs about 63 tokens; SKILL.md has 581 words of instructions outside code blocks.
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.
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.
The full file from rocky-data/rocky at commit 365aebf, republished under its Apache-2.0 licence (© rocky-data). 581 words, ~1,335 tokens.
.claude/skills/rocky-dsl-change/SKILL.md (or your agent's skills folder).Rocky has its own transformation language as an alternative to SQL: .rocky files with a .toml sidecar. The language has four pieces that live in different subprojects and MUST be changed in lockstep — otherwise the IDE experience and the engine diverge.
from, where, group, derive, select, join, sort, take, distinct, replicate, …)!= → IS DISTINCT FROM rule).toml metadata is parsed| # | Subproject | File | What it owns |
|---|---|---|---|
| 1 | engine/crates/rocky-lang/ | src/token.rs, src/parser.rs, src/lower.rs | Lexer (logos), parser, and lowering to SQL |
| 2 | engine/crates/rocky-compiler/ | src/ (type checking, semantic graph) | Type checking, contract validation, diagnostics |
| 3 | editors/vscode/syntaxes/ | rocky.tmLanguage.json | TextMate grammar — syntax highlighting in VS Code |
| 4 | editors/vscode/snippets/ | rocky.json | Snippet triggers users type to insert keywords |
All four live under engine/ and editors/vscode/ in the same monorepo, so they ship in one PR with one CI run — which is the whole point of the monorepo.
engine/crates/rocky-lang/src/token.rs (logos-derived enum).engine/crates/rocky-lang/src/parser.rs to accept it.engine/crates/rocky-lang/src/lower.rs to lower it to SQL (lower_to_sql); the emitted SQL then compiles through the standard pipeline into ModelIr. There is no direct DSL→IR lowering.engine/crates/rocky-compiler/src/.editors/vscode/syntaxes/rocky.tmLanguage.json.match pattern. TextMate grammars are pure regex with scope names — the scope name should match an existing family (keyword.control.rocky, keyword.operator.rocky, etc.) so existing themes color it.editors/vscode/snippets/rocky.json when the keyword is something users would want to autocomplete with a body.docs/src/content/docs/concepts/rocky-dsl.md (Astro/Starlight); keep the fuller spec at docs/rocky-lang-spec.md in sync too.rocky-lang or an integration test in rocky-compiler that parses and type-checks a snippet using the new syntax.editors/vscode/src/ vitest tests if one exists, or smoke-test in the Extension Development Host (F5).just test # cargo test + pytest + vitest
just lint # cargo clippy/fmt + ruff + eslintCommits scoped by subproject or crate — but land them together in one PR:
feat(engine/rocky-lang): add `pivot` pipeline step
feat(engine/rocky-compiler): type-check pivot step
feat(vscode): highlight + snippet for pivot step
docs(engine): document pivot in rocky-lang-specOr, for a focused change, one combined commit is fine:
feat(rocky-dsl): add `pivot` pipeline step across engine + vscodeThe canonical reminder case in engine/AGENTS.md:
Key difference from SQL:
!=compiles toIS DISTINCT FROM(NULL-safe).
If you changed that rule, you'd touch:
engine/crates/rocky-lang/src/parser.rs to recognize the operator.engine/crates/rocky-compiler/ to fold into the IR.engine/crates/rocky-sql/src/transpile.rs to emit dialect-specific SQL.editors/vscode/syntaxes/rocky.tmLanguage.json so the operator highlights as an operator, not an error.docs/src/content/docs/concepts/rocky-dsl.md (and docs/rocky-lang-spec.md) to document the semantics.rocky compile will reject it. Users get a confusing experience..toml sidecar parsing — model metadata lives in a sibling .toml; if your new syntax requires a new metadata field, update engine/crates/rocky-core/src/models.rs.AGENTS.md (monorepo root) — "When modifying Rocky DSL syntax" cascade rules.engine/AGENTS.md — "Rocky DSL (.rocky files)" section for the current pipeline step list.docs/src/content/docs/concepts/rocky-dsl.md — the published DSL page; docs/rocky-lang-spec.md — the fuller spec.© rocky-data, 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
Just SKILL.md in .agents/skills/rocky-dsl-change of rocky-data/rocky.
Open the folder on GitHubat commit 365aebf
Rocky Dsl Change 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.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Rocky Dsl Change this skillrocky-data/rocky | 304 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | |
| Cosmosdb Nosql Query Generationmicrosoft/vscode-cosmosdb | 200 | — | ~4k | Automated safety check: Warn | MIT | |
| Code Implementationapache/shardingsphere | 21k | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | |
| Basincloudflare/skills | 3k | 2 repos | ~684 | Automated safety check: Pass | Apache-2.0 | |
| Analyzing Dataastronomer/agents | 451 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | |
| VisualizationFrankChen021/datastoria | 327 | — | ~1.2k | Automated safety check: Pass | Custom licence |
microsoft/vscode-cosmosdb
Generate, explain, edit, and fix Azure Cosmos DB for NoSQL (SQL API) queries.
apache/shardingsphere
Implement, fix, refactor, or remove repository code under required scope, non-regression, verification, and review gates.
cloudflare/skills
Build and troubleshoot Cloudflare Basin analytics workflows with Basin Pipelines, Basin Catalog, and Basin SQL.
astronomer/agents
Queries the data warehouse with SQL and answers business questions about data.
FrankChen021/datastoria
Rules for charts and visualization. An agent skill from FrankChen021/datastoria.
databricks/databricks-agent-skills
Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities.
rocky-data/rocky
Fivetran REST API reference for Rocky's source adapter. An agent skill from rocky-data/rocky.
rocky-data/rocky
Databricks REST API and SQL reference for Rocky's warehouse adapter.
rocky-data/rocky
Rocky CLI JSON-output schema cascade. An agent skill from rocky-data/rocky.
rocky-data/rocky
Top-level router for Rocky development tasks. An agent skill from rocky-data/rocky.
rocky-data/rocky
Adding a new warehouse or source adapter crate to the Rocky engine.
rocky-data/rocky
End-to-end checklist for adding a new Rocky CLI subcommand across the engine, JSON schema export, Dagster Pydantic types, Dagster resource wiring, and VS Code extension command.
Works with
Categories
Rocky DSL (.rocky file) cross-subproject cascade. An agent skill from rocky-data/rocky. Rocky Dsl Change is an agent skill from rocky-data/rocky.rocky file) cross-subproject cascade.
Rocky Dsl Change fits situations like: adding/changing a Rocky DSL keyword; pipeline step — changes must land in the engine parser; VS Code TextMate grammar; snippets together in one PR.
Run `npx skills add rocky-data/rocky --skill rocky-dsl-change -a claude-code`. Or copy the skill folder (.agents/skills/rocky-dsl-change in rocky-data/rocky) into .claude/skills/rocky-dsl-change in your project. Claude Code loads it when a task matches its description.
Run `npx skills add rocky-data/rocky --skill rocky-dsl-change -a codex`. Or copy the skill folder (.agents/skills/rocky-dsl-change in rocky-data/rocky) into .agents/skills/rocky-dsl-change in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add rocky-data/rocky --skill rocky-dsl-change -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/rocky-dsl-change, .gemini/skills/rocky-dsl-change, .github/skills/rocky-dsl-change and .opencode/skills/rocky-dsl-change in your project.
Going by SKILL.md and its folder, Rocky Dsl Change needs the command-line tools its instructions call (just).
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.
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.
Rocky Dsl Change 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.
About 1.3k tokens (SKILL.md is roughly 5.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Rocky Dsl Change: Cosmosdb Nosql Query Generation (microsoft/vscode-cosmosdb, 200 stars), Code Implementation (apache/shardingsphere, 21k stars), Basin (cloudflare/skills, 3k stars) and Analyzing Data (astronomer/agents, 451 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
rocky-data (a GitHub organization) maintains it in rocky-data/rocky, which has 304 GitHub stars. The repository holds 22 skills in this directory. The repository was last updated on October 10, 2026.
Source: rocky-data/rocky on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.