ClickHouse Query Performance Validation
comet-ml/opik
Measures what a ClickHouse query change actually costs, turning a suspicion that a query is slow into numbers a reviewer can act on before it merges.
Guidelines for querying schemastore.org. An agent skill from sammcj/agentic-coding.
Apache-2.0Auto-check passed
Install JSON Schema Lookup
$ npx skills add sammcj/agentic-coding --skill json-schema-lookup -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install sammcj/agentic-coding json-schema-lookup --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/sammcj/agentic-coding.git skills-src && mkdir -p .claude/skills && cp -r skills-src/Skills/json-schema-lookup .claude/skills/json-schema-lookup && 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 "json-schema-lookup" agent skill from https://github.com/sammcj/agentic-coding/tree/main/Skills/json-schema-lookup into .claude/skills/json-schema-lookup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "json-schema-lookup", 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/sammcj/agentic-coding/tree/main/Skills/json-schema-lookupType 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 sammcj/agentic-coding --skill json-schema-lookup -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install sammcj/agentic-coding json-schema-lookup --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sammcj/agentic-coding.git skills-src && mkdir -p .agents/skills && cp -r skills-src/Skills/json-schema-lookup .agents/skills/json-schema-lookup && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "json-schema-lookup" agent skill from https://github.com/sammcj/agentic-coding/tree/main/Skills/json-schema-lookup into .agents/skills/json-schema-lookup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "json-schema-lookup", 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 sammcj/agentic-coding --skill json-schema-lookup -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install sammcj/agentic-coding json-schema-lookup --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sammcj/agentic-coding.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/Skills/json-schema-lookup .cursor/skills/json-schema-lookup && 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 "json-schema-lookup" agent skill from https://github.com/sammcj/agentic-coding/tree/main/Skills/json-schema-lookup into .cursor/skills/json-schema-lookup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "json-schema-lookup", 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/sammcj/agentic-coding.git --path Skills/json-schema-lookup--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 sammcj/agentic-coding --skill json-schema-lookup -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install sammcj/agentic-coding json-schema-lookup --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sammcj/agentic-coding.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/Skills/json-schema-lookup .gemini/skills/json-schema-lookup && 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 "json-schema-lookup" agent skill from https://github.com/sammcj/agentic-coding/tree/main/Skills/json-schema-lookup into .gemini/skills/json-schema-lookup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "json-schema-lookup", 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 sammcj/agentic-coding json-schema-lookupInstalls 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 sammcj/agentic-coding --skill json-schema-lookup -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/sammcj/agentic-coding.git skills-src && mkdir -p .github/skills && cp -r skills-src/Skills/json-schema-lookup .github/skills/json-schema-lookup && 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 "json-schema-lookup" agent skill from https://github.com/sammcj/agentic-coding/tree/main/Skills/json-schema-lookup into .github/skills/json-schema-lookup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "json-schema-lookup", 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 sammcj/agentic-coding --skill json-schema-lookup -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install sammcj/agentic-coding json-schema-lookup --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/sammcj/agentic-coding.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/Skills/json-schema-lookup .opencode/skills/json-schema-lookup && 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 "json-schema-lookup" agent skill from https://github.com/sammcj/agentic-coding/tree/main/Skills/json-schema-lookup into .opencode/skills/json-schema-lookup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "json-schema-lookup", 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.
Facts
- Skill name
json-schema-lookup- GitHub stars
- 162
- Token cost
- ~621 tokens
- SKILL.md length
- 137 words
- Files
- 1
- Skills in repo
- 64
- Repo updated
- First seen
- Licence
- Apache-2.0
At a glance
Guidelines for querying schemastore.org. An agent skill from sammcj/agentic-coding.
- Works in 3 steps: Find the schema → Fetch and inspect the schema → Common queries
- You need to validate
- SKILL.md covers API, Workflow and Tips
- Calls curl and jq; reaches schemastore.org
What it does
JSON Schema Lookup is an agent skill from sammcj/agentic-coding. Guidelines for querying schemastore.org. Use when you need to validate or discover options for config files relating to popular open source projects.
Its SKILL.md is about 620 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
The repository describes itself as: Agentic Coding Rules, Templates etc... The licence is Apache-2.0.
When your agent uses it
- You need to validate
- Discover options for config files relating to popular open source projects
Example prompts
- “Use the json-schema-lookup skill to guideline for querying schemastore.org. An agent skill from sammcj/agentic-coding”
- “/json-schema-lookup”
Requirements
- Pre-approved tools (allowed-tools): WebFetch, Bash(curl *), Bash(jq *), Bash(yq *), Bash(grep *), Bash(head *), Bash(less *)
Workflow steps
3 steps, taken from the step headings in SKILL.md.
What it can do on your machine
Read from SKILL.md and the folder at commit 2f25ced. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves these tools, so the agent can use them without asking each time:
WebFetchBash(curl *)Bash(jq *)Bash(yq *)Bash(grep *)Bash(head *)Bash(less *)
From allowed-tools in the SKILL.md frontmatter.
Runs code
Shell commands in SKILL.md call:
curljq
From the folder's file list and the shell code blocks in SKILL.md.
Network
Hosts in commands or code, which the agent is likely to contact:
schemastore.org
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
JSON Schema Lookup loads about 621 tokens when it runs. Until then it costs about 42 tokens; SKILL.md has 137 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.
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 sammcj/agentic-coding at commit 2f25ced, republished under its Apache-2.0 licence (© sammcj). 137 words, ~621 tokens.
Download SKILL.mdSave it as
.claude/skills/json-schema-lookup/SKILL.md (or your agent's skills folder).- name
- json-schema-lookup
- description
- Guidelines for querying schemastore.org. Use when you need to validate or discover options for config files relating to popular open source projects.
- allowed-tools
- WebFetch, Bash(curl *), Bash(jq *), Bash(yq *), Bash(grep *), Bash(head *), Bash(less *)
JSON Schema Lookup via SchemaStore
Query schemastore.org's catalog of public configuration file schemas to validate structure, discover options, and check allowed values.
API
- Catalog:
https://www.schemastore.org/api/json/catalog.json- Structure:
{ "schemas": [{ "name", "description", "fileMatch", "url", "versions"? }] }
- Structure:
- Individual schemas: Fetch the
urlfrom the matching catalog entry
Workflow
1. Find the schema
Search the catalog by name or filename pattern:
# Search by name (case-insensitive)
curl -s https://www.schemastore.org/api/json/catalog.json | jq '.schemas[] | select(.name | test("tsconfig"; "i")) | {name, url, fileMatch}'
# Search by filename match
curl -s https://www.schemastore.org/api/json/catalog.json | jq '.schemas[] | select(.fileMatch[]? | test("package\\.json")) | {name, url}'Alternatively, use WebFetch on the catalog URL and ask for the relevant entry.
2. Fetch and inspect the schema
# List top-level properties
curl -s SCHEMA_URL | jq '.properties | keys'
# Inspect a specific field (type, enum values, description)
curl -s SCHEMA_URL | jq '.properties.FIELD_NAME'
# Check definitions/shared types (schemas use $ref to these)
curl -s SCHEMA_URL | jq '.definitions.DEF_NAME.properties'
# Get the full schema (warning - might be large!)
curl -s SCHEMA_URL | jq .3. Common queries
# Find enum values for a field
curl -s SCHEMA_URL | jq '.properties.FIELD.enum'
# List nested properties (e.g. compilerOptions in tsconfig)
curl -s SCHEMA_URL | jq '.definitions.compilerOptionsDefinition.properties.compilerOptions.properties | keys'
# Find all required fields
curl -s SCHEMA_URL | jq '.required'Tips
- Some schemas use
allOf/anyOfcomposition -- check those arrays for the full property set - The
versionsfield on catalog entries provides version-specific schema URLs when available - Schema URLs vary: some point to
json.schemastore.org, others toraw.githubusercontent.com - For large schemas, query specific paths rather than dumping the entire document
- Cache the catalog response locally if making multiple lookups in one session
© sammcj, 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
Just SKILL.md in Skills/json-schema-lookup of sammcj/agentic-coding.
Open the folder on GitHubat commit 2f25ced
Compare with similar skills
JSON Schema Lookup 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 |
|---|---|---|---|---|---|---|
| JSON Schema Lookup this skillsammcj/agentic-coding | 162 | — | ~621 | Automated safety check: Pass | Apache-2.0 | |
| ClickHouse Query Performance Validationcomet-ml/opik | 22k | — | ~2.1k | Automated safety check: Pass | Apache-2.0 | |
| Analyzing Experiment Query PerformancePostHog/posthog | 40k | — | ~3.7k | Automated safety check: Pass | Custom licence | |
| Context7 Documentation Lookupaffaan-m/ECC | 276k | 4 repos | ~1.2k | Automated safety check: Pass | MIT | |
| Frontend Query Mutationlangflow-ai/langflow | 155k | — | ~979 | Automated safety check: Pass | MIT | |
| Studio Queriessupabase/supabase | 111k | — | ~1.3k | Automated safety check: Pass | Apache-2.0 |
Similar skills
- Official
Analyzing Experiment Query Performance
PostHog/posthog
Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute…
Context7 Documentation Lookup
affaan-m/ECC
Fetches current library and framework documentation through the Context7 MCP instead of relying on training data, resolving a library ID before each query.
Frontend Query Mutation
langflow-ai/langflow
Guide for implementing Langflow frontend query and mutation patterns with Axios and TanStack React Query v5.
- Official
Studio Queries
supabase/supabase
React Query conventions for data fetching in Supabase Studio.
Agentdb Query
ruvnet/ruflo
Query AgentDB through the controller bridge -- semantic routing, hierarchical recall, causal graphs, context synthesis, pattern store/search
More from sammcj/agentic-coding
All 64 skills in this repoYue2 Music
sammcj/agentic-coding
A skill your agent uses when generating songs with YuE2, covering a recording via SheetSage2 audio-to-ABC, editing a score or lyrics with melody preservation, or building a reproducible listening…
Bento Slides
sammcj/agentic-coding
A skill your agent uses when creating or editing Bento (.bento.html) slide decks, including any request for a single-file HTML slide deck.
Idrive Backup
sammcj/agentic-coding
A skill your agent uses whenever the user wants you to manage, discuss or diagnose iDrive Backup configuration on macOS
Piper Tts Training
sammcj/agentic-coding
Train custom TTS voices for Piper (ONNX format) using fine-tuning or from-scratch approaches.
PPTX To Md
sammcj/agentic-coding
Convert a PPTX slide deck into per-slide markdown that preserves both the verbatim text and the meaning of embedded screenshots, diagrams and charts in their original layout positions.
Skill Creator Primer
sammcj/agentic-coding
You MUST load this skill before the skill-creator skill AND before making ANY change to, or conducting a review of ANY Agent Skill.
Questions about JSON Schema Lookup
What does JSON Schema Lookup do?
Guidelines for querying schemastore.org. An agent skill from sammcj/agentic-coding. JSON Schema Lookup is an agent skill from sammcj/agentic-coding.org.
When should I use JSON Schema Lookup?
JSON Schema Lookup fits situations like: you need to validate; discover options for config files relating to popular open source projects.
How do I install JSON Schema Lookup in Claude Code?
Run `npx skills add sammcj/agentic-coding --skill json-schema-lookup -a claude-code`. Or copy the skill folder (Skills/json-schema-lookup in sammcj/agentic-coding) into .claude/skills/json-schema-lookup in your project. Claude Code loads it when a task matches its description.
How do I install JSON Schema Lookup in Codex?
Run `npx skills add sammcj/agentic-coding --skill json-schema-lookup -a codex`. Or copy the skill folder (Skills/json-schema-lookup in sammcj/agentic-coding) into .agents/skills/json-schema-lookup in your project. Codex loads it when a task matches its description.
Can I use JSON Schema Lookup 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 sammcj/agentic-coding --skill json-schema-lookup -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/json-schema-lookup, .gemini/skills/json-schema-lookup, .github/skills/json-schema-lookup and .opencode/skills/json-schema-lookup in your project.
What does JSON Schema Lookup need to run?
Going by SKILL.md and its folder, JSON Schema Lookup needs the command-line tools its instructions call (curl and jq). Its frontmatter pre-approves these tools: WebFetch, Bash(curl *), Bash(jq *), Bash(yq *), Bash(grep *), Bash(head *), Bash(less *).
Does JSON Schema Lookup access the network?
SKILL.md names 1 domain. In commands or code: schemastore.org; the agent is likely to contact it when it follows the instructions. This is read from the text; nothing was executed.
Is JSON Schema Lookup 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 JSON Schema Lookup use?
JSON Schema Lookup 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 JSON Schema Lookup use?
About 621 tokens (SKILL.md is roughly 2.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to JSON Schema Lookup?
Skills that share tags, products or a category with JSON Schema Lookup: ClickHouse Query Performance Validation (comet-ml/opik, 22k stars), Analyzing Experiment Query Performance (PostHog/posthog, 40k stars), Context7 Documentation Lookup (affaan-m/ECC, 276k stars) and Frontend Query Mutation (langflow-ai/langflow, 155k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains JSON Schema Lookup?
sammcj (a GitHub user) maintains it in sammcj/agentic-coding, which has 162 GitHub stars. The repository holds 64 skills in this directory. The repository was last updated on October 9, 2026.
Source: sammcj/agentic-coding on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.