← ClaudeAtlas

file-to-database-skilllisted

Use when the user wants to build a database from data files (CSV/Excel/JSON/JSONL/TSV), design a schema from raw data, or turn flat files into tables — AND when the user later talks to that database in natural language (add, query, update, delete records; 'how many...'; 'show me...'). Scans files, infers column types, detects candidate foreign keys, applies the methodology in references/methodology.md to produce DDL, ERD, seed scripts, and validation; runtime operations follow references/operations.md (intent → SQL → safe execution → natural-language report). Do NOT use for ORM code generation or pure database concept discussions.
Thomaszhou22/file-to-database-skill · ★ 2 · Data & Documents · score 68
Install: claude install-skill Thomaszhou22/file-to-database-skill
# Database Generator Skill Turn data files (CSV / Excel / JSON / JSONL / TSV) into a validated database: **scan → infer → model → DDL → verify**, following the pluggable methodology in `references/methodology.md` throughout. ## Onboarding (First Use) When the user first triggers this skill and `memory/file_to_database_state.json` doesn't exist, run a one-time setup: 1. **Introduce capability** (one sentence): _"I can turn CSV/Excel/JSON data files into a validated database, then let you operate it in natural language."_ 2. **Quick configuration:** 1. **Default database engine**(Default: SQLite) - SQLite(zero-install, single-file, personal projectsrecommended) - PostgreSQL(Multi-user / cloud deployment) 2. **Enable runtime natural-language operations**(Default: Yes) - Yes (CRUD in natural language after database is built) - No (build database only, skip runtime mode) 3. **Write initial state file** `memory/file_to_database_state.json`(JSON format, with `onboarded: true` and timestamp) 4. **Confirm completion**: _"Setup done! Just use it from now on. Say 'reset settings' anytime to reconfigure." **Onboarding runs exactly once.** Subsequent activations read the state file directly. When the user says "reset settings", delete the state file and re-run setup. --- ## Startup Flow 1. Read `references/methodology.md` (the methodology is the soul of this skill; read it first, always) 2. Detect the runtime environment: - `python3 --version` ≥ 3.8 → script en