Agent skill

Validate App DB Schema

by rajbos in rajbos/ai-engineering-fluency

Validate that ~/.copilot/data.db has the required schema for session hierarchy (workspaceparentlinks, workspaces, sessions tables and columns).

MITAuto-check passedDevelopment

Install Validate App DB Schema

skills CLI

$ npx skills add rajbos/ai-engineering-fluency --skill validate-app-db-schema -a claude-code

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

GitHub CLI

$ gh skill install rajbos/ai-engineering-fluency validate-app-db-schema --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/rajbos/ai-engineering-fluency.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/validate-app-db-schema .claude/skills/validate-app-db-schema && 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 "validate-app-db-schema" agent skill from https://github.com/rajbos/ai-engineering-fluency/tree/main/.claude/skills/validate-app-db-schema into .claude/skills/validate-app-db-schema/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "validate-app-db-schema", 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/rajbos/ai-engineering-fluency/tree/main/.claude/skills/validate-app-db-schema

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 rajbos/ai-engineering-fluency --skill validate-app-db-schema -a codex

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

GitHub CLI

$ gh skill install rajbos/ai-engineering-fluency validate-app-db-schema --agent codex

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

Manual copy

$ git clone --depth 1 https://github.com/rajbos/ai-engineering-fluency.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/validate-app-db-schema .agents/skills/validate-app-db-schema && 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 "validate-app-db-schema" agent skill from https://github.com/rajbos/ai-engineering-fluency/tree/main/.claude/skills/validate-app-db-schema into .agents/skills/validate-app-db-schema/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "validate-app-db-schema", 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 rajbos/ai-engineering-fluency --skill validate-app-db-schema -a cursor

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

GitHub CLI

$ gh skill install rajbos/ai-engineering-fluency validate-app-db-schema --agent cursor

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

Manual copy

$ git clone --depth 1 https://github.com/rajbos/ai-engineering-fluency.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/validate-app-db-schema .cursor/skills/validate-app-db-schema && 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 "validate-app-db-schema" agent skill from https://github.com/rajbos/ai-engineering-fluency/tree/main/.claude/skills/validate-app-db-schema into .cursor/skills/validate-app-db-schema/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "validate-app-db-schema", 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/rajbos/ai-engineering-fluency.git --path .claude/skills/validate-app-db-schema

--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 rajbos/ai-engineering-fluency --skill validate-app-db-schema -a gemini-cli

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

GitHub CLI

$ gh skill install rajbos/ai-engineering-fluency validate-app-db-schema --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/rajbos/ai-engineering-fluency.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/validate-app-db-schema .gemini/skills/validate-app-db-schema && 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 "validate-app-db-schema" agent skill from https://github.com/rajbos/ai-engineering-fluency/tree/main/.claude/skills/validate-app-db-schema into .gemini/skills/validate-app-db-schema/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "validate-app-db-schema", 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 rajbos/ai-engineering-fluency validate-app-db-schema

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 rajbos/ai-engineering-fluency --skill validate-app-db-schema -a github-copilot

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

Manual copy

$ git clone --depth 1 https://github.com/rajbos/ai-engineering-fluency.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/validate-app-db-schema .github/skills/validate-app-db-schema && 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 "validate-app-db-schema" agent skill from https://github.com/rajbos/ai-engineering-fluency/tree/main/.claude/skills/validate-app-db-schema into .github/skills/validate-app-db-schema/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "validate-app-db-schema", 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 rajbos/ai-engineering-fluency --skill validate-app-db-schema -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 rajbos/ai-engineering-fluency validate-app-db-schema --agent opencode

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

Manual copy

$ git clone --depth 1 https://github.com/rajbos/ai-engineering-fluency.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/validate-app-db-schema .opencode/skills/validate-app-db-schema && 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 "validate-app-db-schema" agent skill from https://github.com/rajbos/ai-engineering-fluency/tree/main/.claude/skills/validate-app-db-schema into .opencode/skills/validate-app-db-schema/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "validate-app-db-schema", 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: validate-app-db-schema
GitHub stars: 116
Token cost: ~722 tokens
SKILL.md length: 220 words
Files: 1
Skills in repo: 21
Repo updated: Oct 8, 2026
First seen: Oct 7, 2026
Licence: MIT

At a glance

Validate that ~/.copilot/data.db has the required schema for session hierarchy (workspaceparentlinks, workspaces, sessions tables and columns).

Works in 3 steps: Checks that the required tables and… → Runs an actual data query (today's… → Reports a clear PASS / FAIL with details…
Data.db schema changes may have broken hierarchy enrichment
SKILL.md covers Background, What We Depend On, Usage and Integration, plus 2 more sections
Calls node

What it does

Validate App DB Schema is an agent skill from rajbos/ai-engineering-fluency. Validate that ~/.copilot/data.db has the required schema for session hierarchy (workspaceparentlinks, workspaces, sessions tables and columns). Runs an actual today's-data query so schema regressions are caught early. Use when data.db schema changes may have broken hierarchy enrichment, or on a periodic schedule to detect breaking changes.

Its SKILL.md is about 720 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 Development. The repository describes itself as: Extension that shows information about the estimated token usage and more of AI in editors/CLI's. The licence is MIT.

When your agent uses it

Data.db schema changes may have broken hierarchy enrichment
On a periodic schedule to detect breaking changes

Example prompts

“/validate-app-db-schema”

Workflow steps

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

Checks that the required tables and columns exist
Runs an actual data query (today's parent/child links) to confirm reads work end-to-end
Reports a clear PASS / FAIL with details so CI or a periodic workflow can surface regressions early

What it can do on your machine

Read from SKILL.md and the folder at commit 64b51e6. 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
Shell commands in SKILL.md call:
- node
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

Validate App DB Schema loads about 722 tokens when it runs. Until then it costs about 92 tokens; SKILL.md has 220 words of instructions outside code blocks.

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

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 rajbos/ai-engineering-fluency at commit 64b51e6, republished under its MIT licence (© rajbos). 220 words, ~722 tokens.

Download SKILL.mdSave it as .claude/skills/validate-app-db-schema/SKILL.md (or your agent's skills folder).

name: validate-app-db-schema
description: Validate that ~/.copilot/data.db has the required schema for session hierarchy (workspace_parent_links, workspaces, sessions tables and columns). Runs an actual today's-data query so schema regressions are caught early. Use when data.db schema changes may have broken hierarchy enrichment, or on a periodic schedule to detect breaking changes.

Validate App DB Schema Skill

Validates that the Copilot app's ~/.copilot/data.db still exposes the tables and columns that the extension's session hierarchy feature depends on.

Background

The session hierarchy feature reads parent/child workspace relationships from data.db — a private Copilot app database that is not part of any public API. Its schema can change without notice when the app is updated.

This skill:

Checks that the required tables and columns exist
Runs an actual data query (today's parent/child links) to confirm reads work end-to-end
Reports a clear PASS / FAIL with details so CI or a periodic workflow can surface regressions early

What We Depend On

Table	Required columns
`workspace_parent_links`	`child_workspace_id`, `parent_workspace_id`, `creator_session_id`, `created_at`
`workspaces`	`id`, `session_id`, `name`, `updated_at`
`sessions`	`id`, `title`, `created_at`, `updated_at`

The join that the extension uses (simplified):

sql

SELECT cw.session_id, cw.name, pw.session_id, pw.name
FROM workspace_parent_links l
JOIN workspaces cw ON cw.id = l.child_workspace_id
JOIN workspaces pw ON pw.id = l.parent_workspace_id
WHERE cw.session_id IN (...)
   OR pw.session_id IN (...)

Usage

bash

# Basic validation — exits 0 on pass, 1 on fail
node .github/skills/validate-app-db-schema/validate-schema.js

# Output as JSON (for automated processing)
node .github/skills/validate-app-db-schema/validate-schema.js --json

# Show help
node .github/skills/validate-app-db-schema/validate-schema.js --help

Integration

Add to a periodic GitHub Actions workflow or run manually after a Copilot app update. Example:

yaml

- name: Validate data.db schema
  run: node .github/skills/validate-app-db-schema/validate-schema.js --json

Implementation Details

The script reads data.db using sql.js (pure WASM — no native SQLite binaries required). It performs three checks:

File exists: ~/.copilot/data.db is present
Schema check: PRAGMA table_info(table_name) confirms all required columns exist
Live query: Runs the actual JOIN query used by the extension against the last 24h of data

vscode-extension/src/copilotAppData.ts — the module that reads data.db at runtime
src/types.ts — SessionHierarchyNode, SessionRelationRef, SessionFileDetails
vscode-extension/src/extension.ts — enrichSessionHierarchy() method

Files

Just SKILL.md in .claude/skills/validate-app-db-schema of rajbos/ai-engineering-fluency.

Open the folder on GitHubat commit 64b51e6

Compare with similar skills

Validate App DB Schema 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.

Validate App DB Schema compared with similar skills
Skill	Stars	Used in	Tokens	Auto-check	Licence	Repo updated
Validate App DB Schema this skillrajbos/ai-engineering-fluency	116	—	~722	Automated safety check: Pass	MIT	today
Vercel Composition Patternssupabase/supabase	111k	59 repos	~726	Automated safety check: Pass	MIT	today
Finishing a Development Branchobra/superpowers	296k	5 repos	~1.9k	Automated safety check: Pass	MIT	today
Typescript Advanced Typesrolling-scopes/rsschool-app	10k	25 repos	~4.2k	Automated safety check: Pass	MPL-2.0	4 days ago
PR Babysitteropeninterpreter/openinterpreter	69k	3 repos	~4.2k	Automated safety check: Pass	Apache-2.0	yesterday
Code Review ChecklistshareAI-lab/learn-claude-code	78k	5 repos	~1.1k	Automated safety check: Pass	MIT	10 days ago

Similar skills

Vercel Composition Patterns
supabase/supabase
Official
React composition patterns that scale. An agent skill from supabase/supabase.
111k GitHub starsUsed in 59 repos~726 tokens
DevelopmentAuto-check passed
Finishing a Development Branch
obra/superpowers
Walks the last step of a branch: confirm tests pass, detect the git environment, ask how to integrate, carry out your choice and clean up the worktree.
296k GitHub starsUsed in 5 repos~1.9k tokens
DevelopmentAuto-check passed
Typescript Advanced Types
rolling-scopes/rsschool-app
Master TypeScript's advanced type system including generics, conditional types, mapped types, template literals, and utility types for building type-safe applications.
10k GitHub starsUsed in 25 repos~4.2k tokens
DevelopmentAuto-check passed
PR Babysitter
openinterpreter/openinterpreter
Watches an open GitHub pull request until it merges, handling review comments, diagnosing CI failures and retrying flaky checks along the way.
69k GitHub starsUsed in 3 repos~4.2k tokens
DevelopmentAuto-check passed
Code Review Checklist
shareAI-lab/learn-claude-code
Reviews code against a five-part checklist covering security, correctness, performance, maintainability and testing, and reports findings in a fixed format.
78k GitHub starsUsed in 5 repos~1.1k tokens
DevelopmentAuto-check passed
Greploop
onyx-dot-app/onyx
Iteratively improves a PR (GitHub), MR (GitLab), or shelved changelist (Perforce) until Greptile gives it a 5/5 confidence score with zero unresolved comments.
32k GitHub starsUsed in 4 repos~3.3k tokens
DevelopmentAuto-check passed

More from rajbos/ai-engineering-fluency

All 21 skills in this repo

Check Urls
rajbos/ai-engineering-fluency
Find all hardcoded URLs in TypeScript source files and verify they resolve (return HTTP 2xx/3xx).
116 GitHub stars~662 tokensUpdated today
Auto-check passed
Create Issue
rajbos/ai-engineering-fluency
Create a well-scoped GitHub issue in this repo. An agent skill from rajbos/ai-engineering-fluency.
116 GitHub stars~2k tokensUpdated today
Auto-check passed
Deduplicate Code
rajbos/ai-engineering-fluency
Detect copy-pasted code blocks across the shared source (vscode-extension/src, the repo-root src/, cli/src) with the dependency-free check-code-duplication.js detector, then pick one duplicate group…
116 GitHub stars~2.4k tokensUpdated today
Auto-check passed
Improve Tool Families
rajbos/ai-engineering-fluency
Analyze coverage of the vscode-extension's tool-family definitions (DEFAULTTOOLFAMILIES in vscode-extension/src/toolFamilies.ts) against the canonical tool-name list in src/toolNames.json and/or a…
116 GitHub stars~1.3k tokensUpdated today
Auto-check passed
Load Cache Data
rajbos/ai-engineering-fluency
Load and display the last 10 cache entries as raw JSON output.
116 GitHub stars~3.2k tokensUpdated today
Auto-check passed
PR Risk Review
rajbos/ai-engineering-fluency
Assess the risk of a changeset (a PR, a branch, or the working tree) and classify it as low, medium, or high with a written rationale.
116 GitHub stars~2.6k tokensUpdated today
Auto-check passed

Questions about Validate App DB Schema

What does Validate App DB Schema do?

Validate that ~/.copilot/data.db has the required schema for session hierarchy (workspaceparentlinks, workspaces, sessions tables and columns). Validate App DB Schema is an agent skill from rajbos/ai-engineering-fluency.db has the required schema for session hierarchy (workspaceparentlinks, workspaces, sessions tables and columns).

When should I use Validate App DB Schema?

Validate App DB Schema fits situations like: data.db schema changes may have broken hierarchy enrichment; on a periodic schedule to detect breaking changes.

How do I install Validate App DB Schema in Claude Code?

Run `npx skills add rajbos/ai-engineering-fluency --skill validate-app-db-schema -a claude-code`. Or copy the skill folder (.claude/skills/validate-app-db-schema in rajbos/ai-engineering-fluency) into .claude/skills/validate-app-db-schema in your project. Claude Code loads it when a task matches its description.

How do I install Validate App DB Schema in Codex?

Run `npx skills add rajbos/ai-engineering-fluency --skill validate-app-db-schema -a codex`. Or copy the skill folder (.claude/skills/validate-app-db-schema in rajbos/ai-engineering-fluency) into .agents/skills/validate-app-db-schema in your project. Codex loads it when a task matches its description.

Can I use Validate App DB Schema 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 rajbos/ai-engineering-fluency --skill validate-app-db-schema -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/validate-app-db-schema, .gemini/skills/validate-app-db-schema, .github/skills/validate-app-db-schema and .opencode/skills/validate-app-db-schema in your project.

What does Validate App DB Schema need to run?

Going by SKILL.md and its folder, Validate App DB Schema needs the command-line tools its instructions call (node).

Does Validate App DB Schema 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 Validate App DB Schema 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 Validate App DB Schema use?

Validate App DB Schema is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Validate App DB Schema use?

About 722 tokens (SKILL.md is roughly 2.9k 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 Validate App DB Schema?

Skills that share tags, products or a category with Validate App DB Schema: Vercel Composition Patterns (supabase/supabase, 111k stars), Finishing a Development Branch (obra/superpowers, 296k stars), Typescript Advanced Types (rolling-scopes/rsschool-app, 10k stars) and PR Babysitter (openinterpreter/openinterpreter, 69k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Validate App DB Schema?

rajbos (a GitHub user) maintains it in rajbos/ai-engineering-fluency, which has 116 GitHub stars. The repository holds 21 skills in this directory. The repository was last updated on October 8, 2026.

Source: rajbos/ai-engineering-fluency on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.

Install Validate App DB Schema

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

Validate App DB Schema Skill

Background

What We Depend On

Usage

Integration

Implementation Details

Related Code

Files

Compare with similar skills

Similar skills

More from rajbos/ai-engineering-fluency

Related

Questions about Validate App DB Schema