From taxonomy-creation
Use when you need to load a taxonomy into MySQL or MariaDB — create table with charset/collation, load data, support upsert/replace/append modes.
npx claudepluginhub danielrosehill/claude-code-plugins --plugin taxonomy-creationThis skill uses the workspace's default tool permissions.
Load a taxonomy into MySQL or MariaDB with proper charset/collation, DDL generation, and 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 MySQL or MariaDB with proper charset/collation, DDL generation, and load modes.
data/<name>/<name>.csv.replace, upsert, append.utf8mb4 / utf8mb4_unicode_ci; allow override.code → VARCHAR(32) or VARCHAR(64), PRIMARY KEY.label / name → VARCHAR(255) NOT NULL.INT, BIGINT, or DECIMAL as appropriate.metadata → JSON (MySQL 5.7+).parent_code → VARCHAR(32) with FOREIGN KEY constraint.TIMESTAMP or DATETIME.CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci.CREATE TABLE <table> (…) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;local_infile=1: Check SHOW VARIABLES LIKE 'local_infile'. If off, require user to enable it (session or config); note this is a security surface.replace: TRUNCATE TABLE <table>; LOAD DATA LOCAL INFILE '<csv_path>' INTO TABLE <table> FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;upsert: Use LOAD DATA … ON DUPLICATE KEY UPDATE col1=VALUES(col1), col2=VALUES(col2), …; (MySQL 8.0.19+) or row-by-row INSERT … ON DUPLICATE KEY UPDATE via Python.append: Direct LOAD DATA LOCAL INFILE without TRUNCATE.SET FOREIGN_KEY_CHECKS=0; before load, re-enable after (to handle parent-before-child ordering).state/loads/<timestamp>-<database>.<table>.log with timestamp, mode, row count, status.state/loads/<timestamp>-<database>.<table>.log.