Database Fundamentals
DanielPodolsky/ownyourcode
Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.
For a change point (function / type / endpoint / SQL column), enumerate its real blast radius across six dimensions with a grep citation per row, then derive the regression test scope.
$ npx skills add Prismer-AI/PrismerCloud --skill impact-trace -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install Prismer-AI/PrismerCloud impact-trace --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/Prismer-AI/PrismerCloud.git skills-src && mkdir -p .claude/skills && cp -r skills-src/sdk/apc/skills/impact-trace .claude/skills/impact-trace && 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 "impact-trace" agent skill from https://github.com/Prismer-AI/PrismerCloud/tree/main/sdk/apc/skills/impact-trace into .claude/skills/impact-trace/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "impact-trace", 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/Prismer-AI/PrismerCloud/tree/main/sdk/apc/skills/impact-traceType 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 Prismer-AI/PrismerCloud --skill impact-trace -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install Prismer-AI/PrismerCloud impact-trace --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Prismer-AI/PrismerCloud.git skills-src && mkdir -p .agents/skills && cp -r skills-src/sdk/apc/skills/impact-trace .agents/skills/impact-trace && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "impact-trace" agent skill from https://github.com/Prismer-AI/PrismerCloud/tree/main/sdk/apc/skills/impact-trace into .agents/skills/impact-trace/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "impact-trace", 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 Prismer-AI/PrismerCloud --skill impact-trace -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install Prismer-AI/PrismerCloud impact-trace --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Prismer-AI/PrismerCloud.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/sdk/apc/skills/impact-trace .cursor/skills/impact-trace && 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 "impact-trace" agent skill from https://github.com/Prismer-AI/PrismerCloud/tree/main/sdk/apc/skills/impact-trace into .cursor/skills/impact-trace/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "impact-trace", 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/Prismer-AI/PrismerCloud.git --path sdk/apc/skills/impact-trace--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 Prismer-AI/PrismerCloud --skill impact-trace -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install Prismer-AI/PrismerCloud impact-trace --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Prismer-AI/PrismerCloud.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/sdk/apc/skills/impact-trace .gemini/skills/impact-trace && 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 "impact-trace" agent skill from https://github.com/Prismer-AI/PrismerCloud/tree/main/sdk/apc/skills/impact-trace into .gemini/skills/impact-trace/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "impact-trace", 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 Prismer-AI/PrismerCloud impact-traceInstalls 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 Prismer-AI/PrismerCloud --skill impact-trace -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/Prismer-AI/PrismerCloud.git skills-src && mkdir -p .github/skills && cp -r skills-src/sdk/apc/skills/impact-trace .github/skills/impact-trace && 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 "impact-trace" agent skill from https://github.com/Prismer-AI/PrismerCloud/tree/main/sdk/apc/skills/impact-trace into .github/skills/impact-trace/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "impact-trace", 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 Prismer-AI/PrismerCloud --skill impact-trace -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install Prismer-AI/PrismerCloud impact-trace --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Prismer-AI/PrismerCloud.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/sdk/apc/skills/impact-trace .opencode/skills/impact-trace && 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 "impact-trace" agent skill from https://github.com/Prismer-AI/PrismerCloud/tree/main/sdk/apc/skills/impact-trace into .opencode/skills/impact-trace/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "impact-trace", 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.
impact-traceFor a change point (function / type / endpoint / SQL column), enumerate its real blast radius across six dimensions with a grep citation per row, then derive the regression test scope.
Impact Trace is an agent skill from Prismer-AI/PrismerCloud. For a change point (function / type / endpoint / SQL column), enumerate its real blast radius across six dimensions with a grep citation per row, then derive the regression test scope. Every impact-table row must trace to a real search hit — never a self-asserted claim.
Its SKILL.md is about 1.5k tokens, which your agent loads only when the skill is triggered. The skill folder holds 1 other file (for example `skill.json`). Compatibility notes: ["claude-code","prismer-sdk"]
It sits in Databases, covering SQL and Citation management. It works with SQL and Prisma. The licence is MIT.
4 steps, taken from the step headings in SKILL.md.
Read from SKILL.md and the folder at commit e5d9444. It shows what the files ask for, not the result of running them.
Pre-approves these tools, so the agent can use them without asking each time:
BashFrom allowed-tools in the SKILL.md frontmatter.
Shell commands in SKILL.md call:
rgnpmFrom the folder's file list and the shell code blocks in SKILL.md.
No URLs in SKILL.md. Its commands use npm, which can reach the network depending on how they are called.
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.
["claude-code","prismer-sdk"]
From compatibility in the SKILL.md frontmatter.
Impact Trace loads about 1.5k tokens when it runs. Until then it costs about 71 tokens; SKILL.md has 416 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 noted patterns worth knowing about, such as sudo or a known installer.
allowed-tools: BashAutomated 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 Prismer-AI/PrismerCloud at commit e5d9444, republished under its MIT licence (© Prismer-AI). 416 words, ~1,521 tokens.
.claude/skills/impact-trace/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.给定一个改动点(函数 / 类型 / endpoint / SQL 列),产出它的真实影响面(受影响的调用方 / 契约消费者 / 持久化写入 / 双 Prisma schema / daemon-SDK 镜像 / skill-role 引用)+ 由此推导的回归测试范围(apc/05 §2 S2 · apc/12 impact-trace 行)。
什么时候用:一个 bugfix / feature 改完,进 review 前需要知道"改这一处会波及哪些地方、要回归哪些层";或评审要判断改动的 blast radius。
铁律:影响表的每一行都必须有 grep/search 证据(path+line)。凭记忆或推理写"这里应该会用到"是开卷考试——本 skill 的产出只认真实搜索命中。你自己不是 ground truth,rg 的命中集才是。
| 命令 | 作用 | 备注 |
|---|---|---|
rg <pattern> [path] -n | 主力搜索:直接调用方 / 契约消费者 / 引用点 | -n 出行号(证据必须带行号);-l 只列文件;-t ts 限类型 |
rg -c <pattern> | 命中计数(核对"没漏"用) | 计数对不上就是漏搜 |
cloud code grep <pattern> --repo <abs> [--glob '*.ts'] | 白名单 repo 内搜索,输出 JSON [{path,line,snippet,sha256}] | 仅 PRISMER_WORKSPACE_ROOT 或 ~/.prismer/agents/<id>/scratch 内;出带 sha 的可引用片段。--glob 只支持 *.ext 形态 |
rg 是本机主力;cloud code grep 用于要产出可引用证据片段(带 sha256)时。两者的命中集应当一致——不一致就查是不是路径白名单/glob 把一部分挡在外面了。feedback_grep_full_range_for_seq_audit)。搜完要核计数:rg -c 的总数 == 影响表行数(去掉 N/A 维度),对不上就是漏了。改动点波及面按六维穷举。任一维标 N/A 必须写理由;双 Prisma 维度永远不许静默省略(apc/12 负控:缺双 Prisma 维且无 N/A 理由 → 校验拒绝)。
| # | 维度 | 怎么搜(示例) | 找什么 |
|---|---|---|---|
| 1 | 直接调用方 | rg '\b<name>\b' -n -t ts | 谁 import / 调用了这个符号 |
| 2 | 契约消费者(API/wire) | rg '<endpoint-path>|<event-code>|<rpc-name>' -n | HTTP 路由消费者、SDK 类型、wire 帧的两端 |
| 3 | 持久化写入 | rg '<column>|<model>\.(create|update|upsert)' -n | 谁写这张表/这个字段 |
| 4 | 双 Prisma schema | rg '<field>' prisma/schema.prisma prisma/schema.mysql.prisma -n | SQLite + MySQL 两份 schema 是否都要改(不许省) |
| 5 | daemon-SDK 镜像 | rg '<name>' sdk/prismer-cloud/runtime/src -n | cloud 侧改了,daemon/SDK 侧有没有对称的一份要跟着改 |
| 6 | skill / role 引用 | rg '<name>' sdk/prismer-cloud/built-in-skills sdk/apc/skills -n | SKILL.md / role template / prompt 里有没有引用它 |
明确改动点的精确标识(符号名 / endpoint 路径 / 列名)。一个改动可能有多个改动点——逐个搜,别只搜一个。
# 维度 1:直接调用方(示例,把 <name> 换成真符号)
rg '\b<name>\b' -n -t ts > /tmp/impact-callers.txt
rg -c '\b<name>\b' -t ts # 核对命中计数
# 维度 4:双 Prisma(两份 schema 都要看)
rg '<field>' prisma/schema.prisma prisma/schema.mysql.prisma -n对每一维,把命中记成影响表的一行:{ path, line, dimension, contract, risk }。没有命中的维度:确认真的没有(不是搜错 pattern),然后写 N/A + 理由。
| path:line | 维度 | 契约 | 风险 | 回归 |
|---|---|---|---|---|
src/foo.ts:42 | 直接调用方 | 传参 shape | 改签名会破 | T0 |
每行必须能回指一条 rg/cloud code grep 命中。行数(不含 N/A 维)应等于去重后的真实命中数——自查:影响表行数 == Σ rg -c。
按影响表命中的文件所在层映射到 tier(对齐 test-runner 选层规则):
| 命中落在 | 回归 tier |
|---|---|
src/lib/** | T0 |
src/im/** / endpoint | T1 |
src/app/** | T2 |
| e2e / 跨端 | T3 |
daemon runtime/src/** | daemon 测试(runtime vitest) |
产出:"本改动需回归 {tiers},因为影响面落在 {层}"。
若本 impact-trace 挂在一个 task 的 acceptance criterion 上,把结论上报:
cloud task verify-criterion "$PRISMER_TASK_ID" "<criterion-id>" --outcome passed \
--note "impact table: N rows, all grep-cited; regression scope: T0,T1"--outcome 合法值恰好四个:passed | failed | n/a | waived。
本 skill 的验收判据不是「报告里出现了某些词」,而是把报告里的声明拿回文件系统复核(structured-criteria.ts 的 cited-evidence / dimension-coverage)。所以报告必须带下面三样可机器解析的东西——形状对但内容假的报告会被当场判红。
① 改动点声明(一行,锚点必须是本次真实改动点,且会被复核确实存在于该文件):
CHANGE-POINT: <symbol> @ <path>② 影响表(markdown 表,首列是 path:line):判据会逐行把 path:line 读回磁盘——文件不存在 / 行号越界 / 该行是空行,任意一条就判红;并且至少 3 条引用所在的那一行必须真的含改动点符号("真实存在的行" ≠ "真实的搜索命中"),且这些命中要落在 ≥3 个不同文件里——把一条真命中抄满整张表是"单命中报告",不是影响面(实证:一条真 path:line 复制 12 遍,加固前 5/5 全绿)。
| path:line | 维度 | 契约 | 风险 | 回归 |
| --- | --- | --- | --- | --- |
| src/foo.ts:42 | direct-callers | 传参 shape | 改签名会破 | T0 |③ 六维逐行作答(每维独占一行 + 固定 key)。判据找的是这一行,报告别处出现同一个词(比如正文里出现 npm run prisma:generate)不算答过——这正是旧判据 match:"prisma" 被证伪的地方:
- [1] direct-callers: <path:line>
- [2] contract-consumers: <path:line>
- [3] persistence-writers: <path:line> | N/A — <理由 ≥20 字符>
- [4] dual-prisma: <path:line> | N/A — <理由 ≥20 字符>
- [5] daemon-sdk-mirror: <path:line>
- [6] skill-role-references: <path:line> | N/A — <理由 ≥20 字符>N/A 必须带理由(去空白后 ≥20 字符);只写 N/A 判红。行号照抄 rg -n 的真实输出,不许凭印象写。
每一维要有自己的证据:同一条 path:line 最多给 2 个维度当证据,第 3 个维度再引它就判红(N/A 维不受影响,它本来就没有引用)。
{path:line, 维度, 契约, 风险} + 找到它的那条搜索。行的真实性 = grep 命中,不是叙述。cloud task verify-criterion 落库 outcome,可回读 acceptance view 确认。不许:把没有搜索命中的行写进影响表;漏搜一个真实调用方(rg -c 计数不核);把双 Prisma 维度静默省掉;断言聊天文本而非 path:line 证据。
rg 命中集是"文本匹配"的 ground truth,不是"语义调用图"——动态派发 / 字符串拼出来的引用 / 反射,文本搜不到。影响表覆盖的是可被文本搜索命中的引用面;无法静态搜到的动态引用要显式标注为已知盲区,不得声称"影响面已穷举"。<!-- APC-ACK:v1 -->
执行本 skill 的第一步,先落一条调用回执:
cloud skill ack impact-trace --task "$PRISMER_TASK_ID"按退出码分流(这条命令的退出码是承重信息,禁止用 || 兜底、; true、
set +e 或重定向把它抹掉):
| exit | 含义 | 你要做的 |
|---|---|---|
0 | 回执已落库(im_task_logs.action='skill_ack') | 继续执行本 skill |
3 | 无 task 上下文——本次运行没有 task,产不出回执 | 继续执行本 skill;但本次运行没有回执,任何报告里都不得声称已 ack |
4 | 你不是该 task 的 assignee,服务端拒绝 | 停下并上报:回执只能由执行该 task 的 agent 产生 |
1 | 其它失败(网络 / 服务端) | 重试一次;仍失败则继续执行,并在结果里显式标注「回执缺失」 |
回执只证明本 skill 被调度,不证明执行正确——效果证明由本 skill 自己的 acceptanceCriteria 副作用断言承担(apc/04 §2 层 1 诚实标注)。
<!-- /APC-ACK:v1 -->
© Prismer-AI, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
SKILL.md and 1 other file in sdk/apc/skills/impact-trace of Prismer-AI/PrismerCloud.
Open the folder on GitHubat commit e5d9444
Impact Trace 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 |
|---|---|---|---|---|---|---|
| Impact Trace this skillPrismer-AI/PrismerCloud | 1.6k | — | ~1.5k | Automated safety check: Notes | MIT | |
| Database FundamentalsDanielPodolsky/ownyourcode | 290 | 1 repos | ~1.6k | Automated safety check: Pass | MIT | |
| DB Review312362115/claude | 107 | — | ~1.8k | Automated safety check: Pass | MIT | |
| Imaging Data CommonsK-Dense-AI/scientific-agent-skills | 48k | 1 repos | ~7.8k | Automated safety check: Pass | MIT | |
| Stash Postgrescipherstash/stack | 157 | — | ~6.3k | Automated safety check: Pass | MIT | |
| SQL Database Assistantalirezarezvani/claude-skills | 28k | — | ~4k | Automated safety check: Pass | MIT |
DanielPodolsky/ownyourcode
Reviews schema design, SQL queries, ORM patterns. An agent skill from DanielPodolsky/ownyourcode.
312362115/claude
数据库代码审查 + Migration 安全检查. An agent skill from 312362115/claude.
K-Dense-AI/scientific-agent-skills
Queries and downloads public cancer imaging data from NCI Imaging Data Commons.
cipherstash/stack
Query EQL v3 encrypted columns from hand-written Postgres SQL over pg (node-postgres) or postgres (postgres-js) — no ORM.
alirezarezvani/claude-skills
A skill your agent uses when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or…
jeremylongshore/tons-of-skills-marketplace
Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence.
Prismer-AI/PrismerCloud
Gives an agent account-scoped access to Gmail, Calendar, Drive, Contacts, Docs and Sheets through the gws CLI or a bundled Python client.
Prismer-AI/PrismerCloud
Walks an agent through creating, importing, editing, validating, testing and publishing Prismer Skills with a fixed workflow and bundled scripts.
Prismer-AI/PrismerCloud
Operates a mailbox from the terminal with the external Himalaya CLI over IMAP, SMTP, Notmuch or Sendmail, separate from any built-in email gateway adapter.
Prismer-AI/PrismerCloud
Generates one image from a text prompt with a bundled Node.js helper and delivers it once as the attachment to the current Prismer reply.
Prismer-AI/PrismerCloud
Produces 3Blue1Brown-style explainer animations with Manim Community Edition for math, algorithms, equations and architecture diagrams, with planning and rendering references.
Prismer-AI/PrismerCloud
Creates or updates Prismer role templates from a persona, SOP or job description, and turns a role into a working agent that runs its first task through a bundled script.
Categories
For a change point (function / type / endpoint / SQL column), enumerate its real blast radius across six dimensions with a grep citation per row, then derive the regression test scope. Impact Trace is an agent skill from Prismer-AI/PrismerCloud. For a change point (function / type / endpoint / SQL column), enumerate its real blast radius across six dimensions with a grep citation per row, then derive the regression test scope.
Impact Trace fits situations like: tasks that involve SQL; tasks that involve Citation management.
Run `npx skills add Prismer-AI/PrismerCloud --skill impact-trace -a claude-code`. Or copy the skill folder (sdk/apc/skills/impact-trace in Prismer-AI/PrismerCloud) into .claude/skills/impact-trace in your project. Claude Code loads it when a task matches its description.
Run `npx skills add Prismer-AI/PrismerCloud --skill impact-trace -a codex`. Or copy the skill folder (sdk/apc/skills/impact-trace in Prismer-AI/PrismerCloud) into .agents/skills/impact-trace 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 Prismer-AI/PrismerCloud --skill impact-trace -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/impact-trace, .gemini/skills/impact-trace, .github/skills/impact-trace and .opencode/skills/impact-trace in your project.
Going by SKILL.md and its folder, Impact Trace needs the command-line tools its instructions call (rg and npm). Its frontmatter pre-approves these tools: Bash. Compatibility (from SKILL.md): ["claude-code","prismer-sdk"].
SKILL.md contains no URLs. Its commands use npm, which can reach the network depending on how they are called. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found notes only (pre-approves every shell command (allowed-tools: bash)), nothing it rates as a warning. It is not a guarantee. Review the folder before installing.
Impact Trace is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
About 1.5k tokens (SKILL.md is roughly 6.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 Impact Trace: Database Fundamentals (DanielPodolsky/ownyourcode, 290 stars), DB Review (312362115/claude, 107 stars), Imaging Data Commons (K-Dense-AI/scientific-agent-skills, 48k stars) and Stash Postgres (cipherstash/stack, 157 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Prismer-AI (a GitHub organization) maintains it in Prismer-AI/PrismerCloud, which has 1,555 GitHub stars. The repository holds 88 skills in this directory. The repository was last updated on September 30, 2026.
Source: Prismer-AI/PrismerCloud on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.