SQL Queries
w95/awesome-claude-corporate-skills
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
Adding a new warehouse or source adapter crate to the Rocky engine.
$ npx skills add rocky-data/rocky --skill rocky-new-adapter -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install rocky-data/rocky rocky-new-adapter --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-new-adapter .claude/skills/rocky-new-adapter && 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-new-adapter" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-new-adapter into .claude/skills/rocky-new-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-new-adapter", 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-new-adapterType 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-new-adapter -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install rocky-data/rocky rocky-new-adapter --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-new-adapter .agents/skills/rocky-new-adapter && 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-new-adapter" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-new-adapter into .agents/skills/rocky-new-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-new-adapter", 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-new-adapter -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install rocky-data/rocky rocky-new-adapter --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-new-adapter .cursor/skills/rocky-new-adapter && 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-new-adapter" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-new-adapter into .cursor/skills/rocky-new-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-new-adapter", 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-new-adapter--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-new-adapter -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install rocky-data/rocky rocky-new-adapter --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-new-adapter .gemini/skills/rocky-new-adapter && 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-new-adapter" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-new-adapter into .gemini/skills/rocky-new-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-new-adapter", 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-new-adapterInstalls 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-new-adapter -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-new-adapter .github/skills/rocky-new-adapter && 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-new-adapter" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-new-adapter into .github/skills/rocky-new-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-new-adapter", 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-new-adapter -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-new-adapter --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-new-adapter .opencode/skills/rocky-new-adapter && 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-new-adapter" agent skill from https://github.com/rocky-data/rocky/tree/main/.agents/skills/rocky-new-adapter into .opencode/skills/rocky-new-adapter/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "rocky-new-adapter", 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-new-adapterAdding a new warehouse or source adapter crate to the Rocky engine.
Rocky New Adapter is an agent skill from rocky-data/rocky. Adding a new warehouse or source adapter crate to the Rocky engine. Use when introducing a new target (e.g. BigQuery, Redshift, ClickHouse) or source (e.g. Airbyte, Singer). Covers crate layout, trait implementation, dialect specifics, auth, conformance tests, and factory registration.
Its SKILL.md is about 2k 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, covering Data warehousing. It works with ClickHouse, Google BigQuery, Airbyte and Databricks. 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.
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:
cargoFrom 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 New Adapter loads about 2k tokens when it runs. Until then it costs about 76 tokens; SKILL.md has 847 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). 847 words, ~2,034 tokens.
.claude/skills/rocky-new-adapter/SKILL.md (or your agent's skills folder).Rocky adapters are Cargo crates that implement traits from rocky-adapter-sdk. Existing examples:
| Kind | Crate | What it talks to |
|---|---|---|
| Target (warehouse) | rocky-databricks | Databricks SQL Statement Execution API + Unity Catalog |
| Target (warehouse) | rocky-snowflake | Snowflake REST API |
| Target (local) | rocky-duckdb | Embedded DuckDB |
| Source | rocky-fivetran | Fivetran REST API |
Create engine/crates/rocky-<name>/ with a Cargo.toml registered in the workspace (engine/Cargo.toml members list). Use rocky-databricks or rocky-snowflake as a template for a warehouse adapter, rocky-fivetran for a source adapter.
rocky-databricks/src/)| File | Responsibility |
|---|---|
lib.rs | pub mod exports + crate-level docs |
adapter.rs | impl Adapter for <Name>Adapter — the main trait from rocky-adapter-sdk::traits |
dialect.rs | impl SqlDialect — dialect-specific SQL (quoting, type widening rules, insert_overwrite_partition, MV/dynamic-table DDL) |
connector.rs | REST client or native connection — use reqwest for HTTP-based adapters |
auth.rs | Credential handling (PAT, OAuth M2M, key-pair JWT, etc.) with env var auto-detection |
catalog.rs | Catalog/schema CRUD (CREATE/ALTER/DESCRIBE) |
permissions.rs | GRANT/REVOKE + SHOW GRANTS parsing |
batch.rs | Bulk operations (e.g. information_schema UNION ALL batching) |
throttle.rs | Rate limiting / adaptive concurrency if the backend needs it |
types.rs | Native → internal type mapping |
rocky-fivetran/src/)| File | Responsibility |
|---|---|
lib.rs | Exports |
adapter.rs | impl SourceAdapter |
client.rs | Async REST client |
connector.rs | Source discovery + filtering |
schema.rs | Schema config parsing (often nested JSON) |
sync.rs | Sync detection / staleness checks |
Traits live in engine/crates/rocky-adapter-sdk/src/traits.rs. The key ones:
Adapter — warehouse adapter core: execute_sql, describe_table, list_tables, create_catalog, …SqlDialect — SQL generation specifics. Pay special attention to:is_safe_type_widening() — allowlist for ALTER TABLE type changes; conservative by defaultinsert_overwrite_partition() — returns Vec<String> so multi-statement transactions work (Snowflake needs BEGIN/DELETE/INSERT/COMMIT)SourceAdapter — source discovery and sync staleness detectionAuthenticator — if there's a credential flow worth unifyingUse #[async_trait] for all async trait impls.
rocky-adapter-sdk/src/conformance.rs hosts a reusable test suite. Wire your adapter into it so rocky test-adapter <name> (the CLI command) validates the baseline behavior: CREATE/DROP, incremental copy, schema drift, permission reconcile.
Test pattern: add an integration test file in your crate that instantiates the adapter and runs the conformance suite. For credential-free local testing, gate behind an env var — see how rocky-databricks skips network tests when DATABRICKS_HOST is unset.
The CLI + config parser needs to know your adapter type string. Search for where existing adapter types are registered (typically in rocky-core/src/config.rs or the CLI's adapter dispatch) and add yours. The config block in rocky.toml will then accept:
[adapter]
type = "<name>" # ← the string you registered
host = "${MY_HOST}"
# … adapter-specific fieldsrocky-databricks/src/auth.rs. Tries PAT from env, falls back to client_credentials flow if PAT is absent.rocky-snowflake/src/auth.rs. OAuth (pre-supplied) > RS256 key-pair JWT > password.rocky-fivetran/src/client.rs. Simplest case — base64 of key:secret.rocky-sql/validation.rs before interpolation.The SqlDialect trait is where adapters actually diverge. Things to get right:
rocky-databricks uses backticks for principals; most warehouses use the standard double-quote identifier.'…' by hand. State the lexer fact once with literal_escape() — LiteralEscape::Standard (no backslash escapes; a quote is doubled: Trino, DuckDB) or LiteralEscape::Backslash (a quote is \', a backslash \\, a line break \n: Snowflake, Databricks, BigQuery) — then call rocky_core::sql_gen::string_literal(dialect, value). Answer from the warehouse's own lexer documentation, and prove it: encode a value holding a quote AND a backslash, SELECT it back, assert byte-identical.
literal_escape() is required only on rocky_core::traits::SqlDialect — the in-tree trait, whose init-adapter scaffold emits a compile_error! so the crate will not build until you answer. rocky_adapter_sdk::traits::SqlDialect, the out-of-process trait, does not carry it yet, so an SDK adapter compiles without stating anything. If you are writing one, pick the rule by hand and encode with rocky_sql::literal::encode_string_literal — nothing will remind you.is_safe_type_widening(from, to) controls whether Rocky will ALTER TABLE or fall back to full refresh. Be conservative — data loss from an unsafe cast is worse than an extra full refresh.INSERT INTO ... REPLACE WHERE as a single atomic op. Snowflake and DuckDB need BEGIN; DELETE; INSERT; COMMIT; — hence the Vec<String> return type.engine/AGENTS.md for the canonical DDL strings.rocky-adapter-sdk/src/process.rs provides helpers for out-of-process adapters (spawning an external binary, parsing JSON, handling exit codes). Useful if you're wrapping a dbt-like adapter or a CLI tool instead of speaking a REST API directly.
engine/Cargo.toml workspace membersimpl Adapter (or SourceAdapter) completeimpl SqlDialect with all required methodsliteral_escape() answered from the warehouse's lexer docs and proved with an executed round triprocky test-adapter <name> passes)rocky.toml type = "<name>" resolvesengine/crates/rocky-core/src/adapter_capability.rs::capability_for (data / discovery / both). Drives kind-field validation in rocky.toml and feeds the rocky-config skill table.engine/README.md and/or docs/src/content/docs/adapters/<name>.mdcargo test -p rocky-<name> greencargo clippy -p rocky-<name> -- -D warnings cleanfeat(engine/rocky-bigquery): scaffold BigQuery target adapter
feat(engine/rocky-bigquery): implement SqlDialect + conformance tests
feat(engine/rocky-bigquery): OAuth service-account auth
docs(engine): add BigQuery adapter reference© 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-new-adapter of rocky-data/rocky.
Open the folder on GitHubat commit 365aebf
Rocky New Adapter 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 New Adapter this skillrocky-data/rocky | 304 | — | ~2k | Automated safety check: Pass | Apache-2.0 | |
| SQL Queriesw95/awesome-claude-corporate-skills | 244 | 3 repos | ~2.8k | Automated safety check: Pass | MIT | |
| Warehouse SQLHybridAIOne/hybridclaw | 159 | — | ~1.8k | Automated safety check: Pass | MIT | |
| Migrating To Amazon Redshiftaws/agent-toolkit-for-aws | 2.8k | — | ~2.7k | Automated safety check: Notes | Apache-2.0 | |
| Airflow State Storeastronomer/agents | 451 | — | ~6.1k | Automated safety check: Pass | Apache-2.0 | |
| Clickhouse Logs Queriessupabase/supabase | 111k | — | ~2.4k | Automated safety check: Pass | Apache-2.0 |
w95/awesome-claude-corporate-skills
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
HybridAIOne/hybridclaw
Review and run read-only natural-language SQL against a customer data warehouse with cached schema introspection and explicit write grants.
aws/agent-toolkit-for-aws
Guides an end-to-end data-warehouse migration to Amazon Redshift — discovery, schema/SQL/stored-procedure/macro/script conversion, data migration, validation, performance comparison, and reporting.
astronomer/agents
Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores (taskstatestore, assetstatestore) and the crash-safe ResumableJobMixin.
supabase/supabase
Write, review, and migrate Supabase logs queries against the ClickHouse-backed logs table (the logs.all.otel analytics endpoint).
AltimateAI/data-engineering-skills
Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.
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
Rocky DSL (.rocky file) cross-subproject cascade. An agent skill from rocky-data/rocky.
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.
Categories
Adding a new warehouse or source adapter crate to the Rocky engine. Rocky New Adapter is an agent skill from rocky-data/rocky. Adding a new warehouse or source adapter crate to the Rocky engine.
Rocky New Adapter fits situations like: introducing a new target (e.g; tasks that involve Data warehousing.
Run `npx skills add rocky-data/rocky --skill rocky-new-adapter -a claude-code`. Or copy the skill folder (.agents/skills/rocky-new-adapter in rocky-data/rocky) into .claude/skills/rocky-new-adapter in your project. Claude Code loads it when a task matches its description.
Run `npx skills add rocky-data/rocky --skill rocky-new-adapter -a codex`. Or copy the skill folder (.agents/skills/rocky-new-adapter in rocky-data/rocky) into .agents/skills/rocky-new-adapter 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-new-adapter -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-new-adapter, .gemini/skills/rocky-new-adapter, .github/skills/rocky-new-adapter and .opencode/skills/rocky-new-adapter in your project.
Going by SKILL.md and its folder, Rocky New Adapter needs the command-line tools its instructions call (cargo).
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 New Adapter 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 2k tokens (SKILL.md is roughly 8.1k 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 New Adapter: SQL Queries (w95/awesome-claude-corporate-skills, 244 stars), Warehouse SQL (HybridAIOne/hybridclaw, 159 stars), Migrating To Amazon Redshift (aws/agent-toolkit-for-aws, 2.8k stars) and Airflow State Store (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.