From taxonomy-creation
Use when you need to load a taxonomy into SQLite — create table, import data, support upsert/replace/append modes, type columns appropriately.
npx claudepluginhub danielrosehill/claude-code-plugins --plugin taxonomy-creationThis skill uses the workspace's default tool permissions.
Load a taxonomy into SQLite with full schema generation, type inference, and multiple load modes.
Prevents silent decimal mismatch bugs in EVM ERC-20 tokens via runtime decimals lookup, chain-aware caching, bridged-token handling, and normalization. For DeFi bots, dashboards using Python/Web3, TypeScript/ethers, Solidity.
Share bugs, ideas, or general feedback.
Load a taxonomy into SQLite with full schema generation, type inference, and multiple load modes.
.db file (will be created if missing).data/<name>/<name>.csv.replace, upsert, append.STRICT tables (SQLite ≥3.37) for stronger type enforcement.sqlite3 --version; if ≥3.37, offer STRICT table option (recommended).code → TEXT PRIMARY KEY.label / name → TEXT.INTEGER or REAL.TEXT (ISO 8601 string) or INTEGER (Unix epoch).parent_code → TEXT with FOREIGN KEY (SQLite supports FK but must enable PRAGMA foreign_keys = ON).STRICT; to the CREATE TABLE statement.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.PRAGMA foreign_keys = ON; before any load if hierarchical.state/loads/<timestamp>-<filename>.log with timestamp, mode, row count, status.state/loads/<timestamp>-<filename>.log.PRAGMA foreign_keys = ON; to enforce; disabled by default.