Agent skill

Gen Ctx YAML

Generate .ctx.yaml table group context files for NL2SQL optimization.

GPL-3.0Auto-check passedDatabases

Install Gen Ctx YAML

skills CLI

$ npx skills add flyxl/datazen --skill gen-ctx-yaml -a claude-code

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

GitHub CLI

$ gh skill install flyxl/datazen gen-ctx-yaml --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/flyxl/datazen.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.cursor/skills/gen-ctx-yaml .claude/skills/gen-ctx-yaml && 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/

Paste into Claude Code

Install the "gen-ctx-yaml" agent skill from https://github.com/flyxl/datazen/tree/main/.cursor/skills/gen-ctx-yaml into .claude/skills/gen-ctx-yaml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "gen-ctx-yaml", 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

$skill-installer install https://github.com/flyxl/datazen/tree/main/.cursor/skills/gen-ctx-yaml

Type 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.

skills CLI

$ npx skills add flyxl/datazen --skill gen-ctx-yaml -a codex

Project install goes to .agents/skills/; add -g for ~/.codex/skills/.

GitHub CLI

$ gh skill install flyxl/datazen gen-ctx-yaml --agent codex

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/flyxl/datazen.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.cursor/skills/gen-ctx-yaml .agents/skills/gen-ctx-yaml && rm -rf skills-src

Use ~/.agents/skills/ instead of .agents/skills for a personal install.

Codex skills documentation · loads skills from .agents/skills/

Paste into Codex

Install the "gen-ctx-yaml" agent skill from https://github.com/flyxl/datazen/tree/main/.cursor/skills/gen-ctx-yaml into .agents/skills/gen-ctx-yaml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "gen-ctx-yaml", 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.

skills CLI

$ npx skills add flyxl/datazen --skill gen-ctx-yaml -a cursor

Project install goes to .agents/skills/; add -g for ~/.cursor/skills/.

GitHub CLI

$ gh skill install flyxl/datazen gen-ctx-yaml --agent cursor

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/flyxl/datazen.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.cursor/skills/gen-ctx-yaml .cursor/skills/gen-ctx-yaml && rm -rf skills-src

Use ~/.cursor/skills/ instead of .cursor/skills for a personal install.

Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/

Paste into Cursor

Install the "gen-ctx-yaml" agent skill from https://github.com/flyxl/datazen/tree/main/.cursor/skills/gen-ctx-yaml into .cursor/skills/gen-ctx-yaml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "gen-ctx-yaml", 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

$ gemini skills install https://github.com/flyxl/datazen.git --path .cursor/skills/gen-ctx-yaml

--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.

skills CLI

$ npx skills add flyxl/datazen --skill gen-ctx-yaml -a gemini-cli

Project install goes to .agents/skills/; add -g for ~/.gemini/skills/.

GitHub CLI

$ gh skill install flyxl/datazen gen-ctx-yaml --agent gemini-cli

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/flyxl/datazen.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.cursor/skills/gen-ctx-yaml .gemini/skills/gen-ctx-yaml && rm -rf skills-src

Use ~/.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/

Paste into Gemini CLI

Install the "gen-ctx-yaml" agent skill from https://github.com/flyxl/datazen/tree/main/.cursor/skills/gen-ctx-yaml into .gemini/skills/gen-ctx-yaml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "gen-ctx-yaml", 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.

GitHub CLI

$ gh skill install flyxl/datazen gen-ctx-yaml

Installs 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).

skills CLI

$ npx skills add flyxl/datazen --skill gen-ctx-yaml -a github-copilot

Project install goes to .agents/skills/; add -g for ~/.copilot/skills/.

Manual copy

$ git clone --depth 1 https://github.com/flyxl/datazen.git skills-src && mkdir -p .github/skills && cp -r skills-src/.cursor/skills/gen-ctx-yaml .github/skills/gen-ctx-yaml && rm -rf skills-src

Use ~/.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/

Paste into GitHub Copilot

Install the "gen-ctx-yaml" agent skill from https://github.com/flyxl/datazen/tree/main/.cursor/skills/gen-ctx-yaml into .github/skills/gen-ctx-yaml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "gen-ctx-yaml", 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.

skills CLI

$ npx skills add flyxl/datazen --skill gen-ctx-yaml -a opencode

OpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.

GitHub CLI

$ gh skill install flyxl/datazen gen-ctx-yaml --agent opencode

Project scope by default (.agents/skills/); add --scope user for a personal install.

Manual copy

$ git clone --depth 1 https://github.com/flyxl/datazen.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.cursor/skills/gen-ctx-yaml .opencode/skills/gen-ctx-yaml && rm -rf skills-src

Use ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.

OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/

Paste into OpenCode

Install the "gen-ctx-yaml" agent skill from https://github.com/flyxl/datazen/tree/main/.cursor/skills/gen-ctx-yaml into .opencode/skills/gen-ctx-yaml/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "gen-ctx-yaml", 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: gen-ctx-yaml
GitHub stars: 114
Token cost: ~661 tokens
SKILL.md length: 276 words
Files: 1
Skills in repo: 4
Repo updated: Oct 10, 2026
First seen: Oct 7, 2026
Licence: GPL-3.0

At a glance

Generate .ctx.yaml table group context files for NL2SQL optimization.

Works in 4 steps: Ask the user which tables to include and… → Generate the .ctx.yaml content following… → Determine save location → …
The user asks to create table groups
SKILL.md covers Format, Workflow, Rules and Example, plus 1 more section
Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Gen Ctx YAML is an agent skill from flyxl/datazen. Generate .ctx.yaml table group context files for NL2SQL optimization. Use when the user asks to create table groups, generate context files, or wants to organize database tables into named groups for AI-assisted SQL generation.

Its SKILL.md is about 660 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 SQL. It works with SQL and PostgreSQL. The repository describes itself as: Lightweight GPL-3.0 desktop database client (PostgreSQL / MySQL / SQLite / Redis). Built with Tauri + Rust, under 15MB. The licence is GPL-3.0.

When your agent uses it

The user asks to create table groups
Generate context files
Wants to organize database tables into named groups for AI-assisted SQL generation

Example prompts

“/gen-ctx-yaml”

Workflow steps

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

Ask the user which tables to include and how to group them.
Generate the .ctx.yaml content following the format above.
Determine save location
Write the file and confirm to the user.

What it can do on your machine

Read from SKILL.md and the folder at commit a6c7507. 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 (its code samples are yaml).
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

Gen Ctx YAML loads about 661 tokens when it runs. Until then it costs about 60 tokens; SKILL.md has 276 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it: ~60
When it runs · the whole SKILL.md, loaded when a task matches: ~661

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 flyxl/datazen at commit a6c7507, republished under its GPL-3.0 licence (© flyxl). 276 words, ~661 tokens.

Download SKILL.mdSave it as .claude/skills/gen-ctx-yaml/SKILL.md (or your agent's skills folder).

name: gen-ctx-yaml
description: Generate .ctx.yaml table group context files for NL2SQL optimization. Use when the user asks to create table groups, generate context files, or wants to organize database tables into named groups for AI-assisted SQL generation.

Generate .ctx.yaml Table Group Files

Create .ctx.yaml files that define named table groups for NL2SQL context. When a user @-references a .ctx.yaml file in the AI input, DataZen automatically extracts the listed table names, fetches their real-time DDL, and injects the schemas into the system prompt.

Format

yaml

groups:
  - name: "Group Name"
    tables:
      - table_name_1
      - schema.table_name_2

Workflow

Ask the user which tables to include and how to group them. If the user provides a natural language description (e.g. "user management tables"), map it to concrete table names. If unsure, list candidates and confirm.
Generate the .ctx.yaml content following the format above.
Determine save location:
- Default: the DataZen context directory (query via IPC context_get_dir, typically {appData}/contexts/).
- The user may specify a custom path or filename.
- Filename convention: <descriptive-name>.ctx.yaml (e.g. user-management.ctx.yaml, sales-pipeline.ctx.yaml).
Write the file and confirm to the user.

Rules

Each group must have a name (string) and tables (list of strings).
Table names should match exactly what the database uses (case-sensitive).
If the driver uses schema.table notation (e.g. PostgreSQL), include the schema prefix: public.users.
Deduplicate tables across groups; a table may appear in multiple groups but avoid unnecessary repetition.
Keep groups focused: 5–20 tables per group is ideal. For very large sets, split into multiple groups or multiple files.
The file extension must be .ctx.yaml or .ctx.yml.

Example

User: "Create a context file for our e-commerce database with user tables and order tables"

Output (ecommerce.ctx.yaml):

yaml

groups:
  - name: "User Management"
    tables:
      - users
      - user_roles
      - permissions
      - user_sessions
  - name: "Order Processing"
    tables:
      - orders
      - order_items
      - payments
      - shipping_addresses

Integration

After creating the file, instruct the user:

Place this file in your DataZen context directory. When writing SQL with AI assistance, type @ and select the .ctx.yaml file. DataZen will automatically fetch the latest schemas for all listed tables and include them in the AI context.

Files

Just SKILL.md in .cursor/skills/gen-ctx-yaml of flyxl/datazen.

Open the folder on GitHubat commit a6c7507

Compare with similar skills

Gen Ctx YAML 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.

Gen Ctx YAML compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Gen Ctx YAML this skillflyxl/datazen	114	—	~661	Automated safety check: Pass	GPL-3.0	yesterday
Safe SQL Executionsupabase/supabase	111k	—	~4.2k	Automated safety check: Pass	Apache-2.0	yesterday
Citus Backportcitusdata/citus	13k	—	~3.2k	Automated safety check: Pass	AGPL-3.0	2 days ago
SQL Database Support for pRESTprest/prest	4.6k	—	~1.6k	Automated safety check: Pass	MIT	yesterday
Chdb SQLvemetric/vemetric	395	1 repos	~1.2k	Automated safety check: Pass	Apache-2.0	yesterday
Mz BenchmarkMaterializeInc/materialize	6.4k	—	~2.8k	Automated safety check: Pass	Custom licence	yesterday

Similar skills

Safe SQL Execution
supabase/supabase
Official
A skill your agent uses whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix…
111k GitHub stars~4.2k tokensUpdated yesterday
DatabasesAuto-check passed
Citus Backport
citusdata/citus
Backport one or more merged citusdata/citus main commits/PRs onto the active release branches.
13k GitHub stars~3.2k tokensUpdated 2 days ago
DatabasesAuto-check passed
SQL Database Support for pREST
prest/prest
Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.
4.6k GitHub stars~1.6k tokensUpdated yesterday
DatabasesAuto-check passed
Chdb SQL
vemetric/vemetric
A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…
395 GitHub starsUsed in 1 repo~1.2k tokens
DatabasesAuto-check passed
Mz Benchmark
MaterializeInc/materialize
Add/modify/debug Materialize perf benchmark scenarios. An agent skill from MaterializeInc/materialize.
6.4k GitHub stars~2.8k tokensUpdated yesterday
DatabasesAuto-check passed
Schema Exploration
timescale/pg-aiguide
Explore an existing PostgreSQL database before answering questions about its data or writing SQL.
1.9k GitHub stars~1.1k tokensUpdated 3 days ago
DatabasesAuto-check passed

Questions about Gen Ctx YAML

What does Gen Ctx YAML do?

Generate .ctx.yaml table group context files for NL2SQL optimization. Gen Ctx YAML is an agent skill from flyxl/datazen.yaml table group context files for NL2SQL optimization.

When should I use Gen Ctx YAML?

Gen Ctx YAML fits situations like: the user asks to create table groups; generate context files; wants to organize database tables into named groups for AI-assisted SQL generation.

How do I install Gen Ctx YAML in Claude Code?

Run `npx skills add flyxl/datazen --skill gen-ctx-yaml -a claude-code`. Or copy the skill folder (.cursor/skills/gen-ctx-yaml in flyxl/datazen) into .claude/skills/gen-ctx-yaml in your project. Claude Code loads it when a task matches its description.

How do I install Gen Ctx YAML in Codex?

Run `npx skills add flyxl/datazen --skill gen-ctx-yaml -a codex`. Or copy the skill folder (.cursor/skills/gen-ctx-yaml in flyxl/datazen) into .agents/skills/gen-ctx-yaml in your project. Codex loads it when a task matches its description.

Can I use Gen Ctx YAML 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 flyxl/datazen --skill gen-ctx-yaml -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/gen-ctx-yaml, .gemini/skills/gen-ctx-yaml, .github/skills/gen-ctx-yaml and .opencode/skills/gen-ctx-yaml in your project.

What does Gen Ctx YAML need to run?

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

Does Gen Ctx YAML 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 Gen Ctx YAML 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 Gen Ctx YAML use?

Gen Ctx YAML is published under the GPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Gen Ctx YAML use?

About 661 tokens (SKILL.md is roughly 2.6k 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 Gen Ctx YAML?

Skills that share tags, products or a category with Gen Ctx YAML: Safe SQL Execution (supabase/supabase, 111k stars), Citus Backport (citusdata/citus, 13k stars), SQL Database Support for pREST (prest/prest, 4.6k stars) and Chdb SQL (vemetric/vemetric, 395 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Gen Ctx YAML?

flyxl (a GitHub user) maintains it in flyxl/datazen, which has 114 GitHub stars. The repository holds 4 skills in this directory. The repository was last updated on October 10, 2026.

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

Gen Ctx YAML

Install Gen Ctx YAML

Facts

At a glance

What it does

When your agent uses it

Example prompts

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Generate .ctx.yaml Table Group Files

Format

Workflow

Rules

Example

Integration

Files

Compare with similar skills

Similar skills

Safe SQL Execution

Citus Backport

SQL Database Support for pREST

Chdb SQL

Mz Benchmark

Schema Exploration

More from flyxl/datazen

Bump Version

Subagent Coordinator

Wapp

Questions about Gen Ctx YAML

Install Gen Ctx YAML

Facts

At a glance

What it does

When your agent uses it

Example prompts

Workflow steps

What it can do on your machine

Tool permissions

Runs code

Network

Credentials

Context cost

Safety

SKILL.md

Generate .ctx.yaml Table Group Files

Format

Workflow

Rules

Example

Integration

Files

Compare with similar skills

Similar skills

More from flyxl/datazen

Related

Questions about Gen Ctx YAML