agentmods.dev

load-to-sqlite

load-to-sqlite is a skill for Claude Code from danielrosehill/Claude-Taxonomy-Creation-Plugin. It costs 36 tokens per session (649 once invoked), scanned A, original, MIT.

A loader that imports a taxonomy file into SQLite, a small database stored in a local file. It creates a table and chooses suitable column types from CSV data.

In plain words
What is it for?
Use it to create or update a SQLite database from a CSV taxonomy in replace, upsert, or append mode, optionally with stricter type enforcement.
Why use it?
It removes the manual work of designing a table and supports different ways to handle existing rows when loading data.

Skill for Claude Code

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

Part of the taxonomy-creation plugin — 9 skills shipped together

not rated 3repo 4mo ago A scan 36 tokens original MIT

Good fit Use it to create or update a SQLite database from a CSV taxonomy in replace, upsert, or append mode, optionally with stricter type enforcement.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/danielrosehill/claude-taxonomy-creation-plugin/load-to-sqlite
View source ↗ danielrosehill/Claude-Taxonomy-Creation-Plugin
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 danielrosehill/Claude-Taxonomy-Creation-Plugin --skill load-to-sqlite
Clone the repo
git clone --depth 1 https://github.com/danielrosehill/Claude-Taxonomy-Creation-Plugin

Made for: Claude Code.

Or install taxonomy-creation, the plugin that ships this one along with the rest of its 9 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.

agentmods badge for load-to-sqlite

README.md
[![agentmods](https://agentmods.dev/badge/skills/danielrosehill/claude-taxonomy-creation-plugin/load-to-sqlite.svg)](https://agentmods.dev/skills/danielrosehill/claude-taxonomy-creation-plugin/load-to-sqlite)
Your own site
<a href="https://agentmods.dev/skills/danielrosehill/claude-taxonomy-creation-plugin/load-to-sqlite"><img src="https://agentmods.dev/badge/skills/danielrosehill/claude-taxonomy-creation-plugin/load-to-sqlite.svg" alt="Measured on agentmods" height="20"></a>
Per session 36 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 649 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.00036 $0.00649
Opus 5 $0.00018 $0.00324
Sonnet 5 $0.00007 $0.00130
Haiku 4.5 $0.00004 $0.00065

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

Security

Grade A, and why

load-to-sqlite 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/load-to-sqlite/SKILL.md · 53 lines

How it starts

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

Load Taxonomy to SQLite

Load a taxonomy into SQLite with full schema generation, type inference, and multiple load modes.

When to use

  • "Load the taxonomy into SQLite"
  • "I want this in a local .db file"
  • "Create a SQLite database with the taxonomy"

Inputs to gather

  • Database file path: Absolute path to .db file (will be created if missing).
  • Table name: What to call the table.
  • Taxonomy file path: Absolute path to CSV or auto-discover from data/<name>/<name>.csv.
  • Load mode: replace, upsert, append.
  • Strict mode?: Use STRICT tables (SQLite ≥3.37) for stronger type enforcement.

Procedure

  1. Check SQLite version: Run sqlite3 --version; if ≥3.37, offer STRICT table option (recommended).
  2. Generate DDL: Infer column types from CSV:
    • code → TEXT PRIMARY KEY.
    • label / name → TEXT.
    • Numeric columns → INTEGER or REAL.
    • Timestamps → TEXT (ISO 8601 string) or INTEGER (Unix epoch).
    • parent_code → TEXT with FOREIGN KEY (SQLite supports FK but must enable PRAGMA foreign_keys = ON).
    • For STRICT tables, append STRICT; to the CREATE TABLE statement.
  3. Show user the DDL for approval.
  4. Handle load mode:
    • replace: DELETE FROM <table>; .import --csv <csv_path> <table>
    • upsert: Use Python sqlite3 or raw SQL INSERT … ON CONFLICT(code) DO UPDATE SET … (SQLite 3.24+).
    • append: .import --csv <csv_path> <table> directly.
  5. Enable constraints: Run PRAGMA foreign_keys = ON; before any load if hierarchical.
  6. Load via sqlite3 CLI (fast for CSV) or Python sqlite3 module (for typed inserts and error handling).
  7. Log the operation: Write to state/loads/<timestamp>-<filename>.log with timestamp, mode, row count, status.

Output / side effects

  • SQLite database with populated table.
  • Load logged to state/loads/<timestamp>-<filename>.log.

Safety / constraints

  • STRICT tables: Recommended for type safety on SQLite ≥3.37; omit for older versions.
  • Foreign key support: Must explicitly PRAGMA foreign_keys = ON; to enforce; disabled by default.
  • Type flexibility: SQLite is dynamically typed; STRICT mitigates but doesn't guarantee type discipline.

Read the full file on GitHub · 53 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 · 53 lines · 36 tokens per session scan A aed97fc314c0

Subscribe to this mod's changes

load-to-sqlite is a skill published in the GitHub repository danielrosehill/Claude-Taxonomy-Creation-Plugin (3 stars, last pushed 4mo ago), licensed MIT. It adds 36 tokens to every session and 649 once invoked, about $0.0002 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.

Databases
Related

Other skills, from other repositories

schema-exploration

Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.

langchain-ai/deepagents · 57 tokens

ha-data-stores

Map of Hope Agent's local data stores and safe read-only query workflow. Use when the user asks where Hope Agent stores data, wants to inspect sessions/messages/memory/logs/background jobs/knowledge indexes/settings, asks the model to query local app data, or debugging requires checking persisted state. Trigger…

shiwenwen/hope-agent · 115 tokens

supabase

Supabase / PostgREST Row-Level-Security playbook — pull the anon (or leaked servicerole) key out of the frontend JS, map tables from the auto-generated OpenAPI spec, test anonymous RLS READ disclosures (PII/secret leaks), and anonymous RLS WRITE abuse (insert/update/delete — e.g. forging…

PentesterFlow/agent · 120 tokens

nornicdb-cypher-queries

Pick fast, predictable Cypher query shapes in NornicDB — point lookups, batch retrieval, pagination, search, traversal, batched UNWIND/MERGE writes, cleanup, multi-tenant isolation. Use when writing or reviewing Cypher whose latency or throughput matters; maps user intent to the executor's hot-path query templates.

orneryd/NornicDB · 79 tokens

dsql

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL and PostgreSQL-to-DSQL schema conversion, foreign key…

awslabs/agent-plugins · 229 tokens

volcengine-rds-postgresql

A tool for operating PostgreSQL databases hosted by Volcano Engine's managed database service. PostgreSQL is a relational database used to store structured application data.

bytedance/agentkit-samples · 63 tokens