data-schemas

data-schemas is a skill for Claude Code from peerjakobsen/smartspender. It costs 26 tokens per session (6,787 once invoked), scanned A, original, MIT.

A set of definitions for the CSV files that store SmartSpender’s transaction and other financial data. CSV is a simple table format that can be opened as a spreadsheet.

In plain words
What is it for?
Use it when reading or writing transaction files, including dates, amounts, currencies, merchants, accounts, and duplicate-check information.
Why use it?
It keeps imported bank data in a consistent structure, reducing errors when the data is read or updated.

Skill for Claude Code

Written for Claude Code: shipped in a Claude Code plugin.

Part of the smartspender plugin — 13 skills, 19 commands shipped together

Good fit Use it when reading or writing transaction files, including dates, amounts, currencies, merchants, accounts, and duplicate-check information.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/peerjakobsen/smartspender/data-schemas
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.

Any agent
npx skills add peerjakobsen/smartspender --skill data-schemas
Clone the repo
git clone --depth 1 https://github.com/peerjakobsen/smartspender

Made for: Claude Code.

Or install smartspender, the plugin that ships this one along with the rest of its 13 skills, 19 commands.

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.

agentmods badge for data-schemas

README.md
[![agentmods](https://agentmods.dev/badge/skills/peerjakobsen/smartspender/data-schemas.svg)](https://agentmods.dev/skills/peerjakobsen/smartspender/data-schemas)
Your own site
<a href="https://agentmods.dev/skills/peerjakobsen/smartspender/data-schemas"><img src="https://agentmods.dev/badge/skills/peerjakobsen/smartspender/data-schemas.svg" alt="Measured on agentmods" height="20"></a>
Per session 26 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 6,787 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00026 $0.06787
Opus 5 $0.00013 $0.03393
Sonnet 5 $0.00005 $0.01357
Haiku 4.5 $0.00003 $0.00679

Measured 7d ago against content hash c2c04f14e0a9, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-07, from the pricing page.

Security

Grade A, and why

data-schemas 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 7d ago.

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.

skills/data-schemas/SKILL.md · 617 lines

How it starts

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

Data Schemas

Purpose

Defines the local CSV file structure that stores all SmartSpender data. All read/write operations use the Filesystem tool to access CSV files in the working directory. Files are created automatically on first use if they don't exist — write the header row first, then append data rows.


1. Transaction Schema

Purpose

Defines the common data format for all transactions in SmartSpender. Every bank adapter normalizes its export into this schema before storing locally.

Schema

Field Type Required Description
tx_id string yes Unique transaction ID (auto-generated UUID)
tx_hash string yes Deduplication hash
date date yes Transaction date (YYYY-MM-DD)
amount number yes Amount with sign (negative = expense, positive = income)
currency string yes ISO currency code (default: DKK)
description string yes Cleaned, human-readable description
raw_text string yes Original text from bank export, unmodified
bank string yes Bank identifier (e.g., enable-banking)
account string yes Account identifier from the bank
synced_at datetime yes When the transaction was imported (YYYY-MM-DD HH:MM:SS)

Hash Computation

The tx_hash prevents duplicate imports across multiple sync runs.

Primary formula (when bank provides running balance)
"{account}|{date}|{amount}|{saldo}"

Where:

  • account is the account identifier from the bank export (e.g., the Enable Banking account UID for API sync)
  • date is in YYYY-MM-DD format
  • amount is formatted to exactly 2 decimal places (e.g., -55.00)
  • saldo is the running balance after the transaction, formatted to exactly 2 decimal places (e.g., 927.83)

The running balance is a natural disambiguator — even two identical purchases at the same merchant on the same day produce different balances.

Fallback formula (when bank does not provide running balance)

Read the full file on GitHub · 617 lines

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.

  1. 7d ago First seen · 617 lines · 26 tokens per session scan A c2c04f14e0a9

Subscribe to this mod's changes

data-schemas is a skill published in the GitHub repository peerjakobsen/smartspender (5 stars, last pushed 7mo ago), licensed MIT. It adds 26 tokens to every session and 6,787 once invoked, about $0.0001 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.

Related

Other skills, from other repositories

cap-table-analysis

Guides Slice MCP cap-table and ESOP-pool analysis by combining company summary, cap table, ownership, stakeholder, share class, funding round, equity pool, valuation, and securities tools. Use when answering questions about cap table structure, stakeholder holdings, ownership, ESOP pools, share classes, rounds…

Global-Slice/claude-plugin · 79 tokens

workflows-analysis

Guides Slice MCP workflow analysis using workflow list/get-one tools, exercise payment reconciliation, and tax withholding tools. Use when answering questions about grant letters, corporate approvals, share certificate workflows, exercise workflows, pending payments, tax withholding, workflow status, stuck workflows…

Global-Slice/claude-plugin · 67 tokens

board-presentation-analysis

Guides creation of board-ready Slice presentations using MCP tools, especially offered-status grants and ESOP/equity-pool summaries. Use when preparing board decks, board approval packs, grant approval summaries, ESOP pool updates, option pool utilization slides, or board-facing equity recommendations.

Global-Slice/claude-plugin · 61 tokens

equity-compensation-analysis

Guides Slice MCP analysis of equity compensation, grants, options, RSUs, vesting, exercises, forfeitures, PTEP, tax treatments, and valuations. Use when answering questions about employee equity, grant positions, vested or exercisable quantities, exercise price, FMV/409A, option pool consumption, tax treatment, or…

Global-Slice/claude-plugin · 78 tokens

funding-rounds-analysis

Guides Slice MCP analysis of funding rounds, share classes, price per share, primary issuances, secondary transactions, convertibles, SAFEs, option-pool top-ups, total raised, and dilution. Use when answering questions about rounds, Series A/B/C, seed rounds, bridge rounds, investor positions, round history…

Global-Slice/claude-plugin · 80 tokens

waterfall-analysis

Guides exit waterfall analysis using Slice MCP cap-table, share-class, securities, rounds, and ownership tools. Use when answering questions about exit proceeds, liquidation preferences, participating preferred, conversion thresholds, proceeds allocation, MOIC, investor returns, or ordinary/common shareholder payouts.

Global-Slice/claude-plugin · 58 tokens