A skill for adding new analytical data structures to an Oracle AIDP Fusion data system when its existing data cannot answer a business question. A medallion layer is a staged data design that organizes raw data into progressively more useful forms.

Use it to add a new metric or dimension that the existing gold data and content pack cannot provide, using additive YAML and SQL artifacts.

It provides a controlled route for filling a genuine gap without changing already-built data, and checks the available source fields before defining the addition.

mart-author — Skill for Claude Code and Codex by ahmedawan-oracle: A skill for adding new analytical data structures to…

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods

npx agentmods add skills/ahmedawan-oracle/claude-code-plugins/mart-author

Any agent

npx skills add ahmedawan-oracle/claude-code-plugins --skill mart-author

Clone the repo

git clone --depth 1 https://github.com/ahmedawan-oracle/claude-code-plugins

Made for: Claude Code, Codex.

Or install oracle-ai-data-platform-fusion-autopilot, the plugin that ships this one along with the rest of its 16 skills.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/ahmedawan-oracle/claude-code-plugins/mart-author.svg)](https://agentmods.dev/skills/ahmedawan-oracle/claude-code-plugins/mart-author)

Your own site

<a href="https://agentmods.dev/skills/ahmedawan-oracle/claude-code-plugins/mart-author"><img src="https://agentmods.dev/badge/skills/ahmedawan-oracle/claude-code-plugins/mart-author.svg" alt="Measured on agentmods" height="20"></a>

Per session 176 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 4,669 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. Scan, not verified.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5	$0.00176	$0.04669
Opus 5	$0.00088	$0.02335
Sonnet 5	$0.00035	$0.00934
Haiku 4.5	$0.00018	$0.00467

Measured 5d ago against content hash b1cb14e9232b, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

mart-author scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 5d ago.

The scan reads SKILL.md. This mod also ships 1 executable file (change_planner.py), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

claude-code-plugins/oracle-ai-data-platform-fusion-autopilot/skills/mart-author/SKILL.md · 309 lines

How it starts

The opening of the file, as written. The whole thing — 309 lines — stays where its author put it; the contents beside it link to each section on GitHub.

mart-author — author a new medallion node, additively and cheaply

When the gold layer genuinely can't serve a dashboard, this skill extends the medallion as v2 content-pack artifacts (YAML + SQL), authored like a careful data engineer: the smallest, additive, lowest-cost change that serves the need without disturbing already-materialized delta.

It is the GAP-handler of the skill family. It does not seed, query live data, create OAC datasets, or write dim_*.py modules (v2 forbids the last — content-pack YAML+SQL only; tests/architectural/test_no_new_legacy_modules.py enforces it).

Not to be confused with medallion-author, which resolves tenant variation (column aliases / semantic variants) into an overlay. This skill authors new analytical content. Both write to overlay packs.

When to use

oac-dataset-advisor reports a true GAP (neither live gold nor the pack's buildable menu can serve the request).
"Add a metric/dimension my gold layer doesn't have", "create a mart for ", "I need a column that isn't there".

When NOT to use

The data exists but isn't materialized → aidp-fusion-autopilot run --mode seed (or /aidp-fusion-seed); use oac-dataset-advisor to confirm.
Resolving column-alias / semantic-variant tenant variation → medallion-author.
A bronze column-TYPE bug (a declared outputSchema type is wrong vs the live PVO, e.g. decimal(38,30) → decimal(18,0)) → that's a bronze type-overlay via medallion-author (AIDPF-4070), not a new mart. The PVO source schema you inspect here surfaces the right type; retype in place via the overlay rather than authoring a new node.
Changing a bronze node's requiredColumns (assert/pull an extra source column, or relax a normally-required one a tenant's PVO lacks) → that's a bronze requiredColumns overlay via medallion-author (add via requiredColumns, acknowledged removal via relaxRequiredColumns; AIDPF-2062/2063), not a new mart.
Building the OAC dataset/workbook → oac-dataset-advisor + workbook-authoring.

Read the full file on GitHub · 309 lines

Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

change_planner.py 21 KB runs code

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

5d ago First seen · 309 lines · 176 tokens per session scan A b1cb14e9232b

Subscribe to this mod's changes

mart-author is a skill published in the GitHub repository ahmedawan-oracle/claude-code-plugins (2 stars, last pushed 1mo ago), licensed MIT. It adds 176 tokens to every session and 4,669 once invoked, about $0.0009 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Analytics and metrics

systematic-debugging

Use when encountering any bug, test failure, or unexpected behavior, before proposing fixes.

obra/superpowers · 21 tokens

local-ai-agents

Build local-first AI agents that run entirely on a developer workstation with Microsoft Foundry Local and Qwen function-calling models. Covers Small Language Models (SLMs), the OpenAI-compatible local endpoint, sandboxed local tools, local RAG with Chroma, local MCP servers, hybrid cloud/local routing, and the…

microsoft/ai-agents-for-beginners · 200 tokens

next-cache-components-adoption

Turn on Cache Components in a Next.js app and resolve the blocking routes it surfaces. Use when the user wants to enable, adopt, or migrate to Cache Components, flip the cacheComponents flag, work through a flood of blocking-prerender / instant validation errors, run the cache-components-instant-false codemod, or…

vercel/next.js · 95 tokens

chat-pet-sprite-creation

Use when creating or changing VS Code chat pet sprite art, sprite sheets, state animations, eye treatments, Stable/Insiders variants, or pet transitions under src/vs/workbench/contrib/chat/browser/widget/media/chatPet.

microsoft/vscode · 53 tokens

cpu-profile-analysis

Analyze V8/Chrome CPU profiles (.cpuprofile) and DevTools trace files (Trace-.json). Use when: profiling performance, investigating slow functions, comparing code paths, finding bottlenecks, analyzing timeToRequest, understanding call trees from sampling profiler data, analyzing layout/paint/rendering, investigating…

microsoft/vscode · 71 tokens

insight-error-page

Write or audit an insight-kind error page for the Next.js dev overlay. Use when creating a new errors/ .mdx page, auditing an existing one, or checking that a page matches the framework fix cards. Covers page structure, title alignment, FixCard cards with Copy prompt button, code snippets, terminology verification…

vercel/next.js · 83 tokens