Importing Data
Systematic CSV import process - discover structure, design schema, standardize formats, import to database, detect quality issues (component skill for DataPeeker analysis sessions)
Install
/plugin marketplace add tilmon-engineering/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add tilmon-engineering/claude-skills --skill importing-datagit clone --depth 1 https://github.com/tilmon-engineering/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/plugins/datapeeker/skills/importing-data ~/.claude/skills/importing-dataPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Importing Data - Component Skill ## Purpose Use this skill when: - Starting a new analysis with CSV data files - Need to import CSV into relational database systematically - Want to ensure proper schema design and type inference - Need quality assessment before cleaning/analysis begins - Replacing ad-hoc import workflows This skill is a **prerequisite** for all DataPeeker analysis workflows and is referenced by all process skills. **Note:** DataPeeker uses SQLite (`data/analytics.db`), but this process applies to any SQL database. For SQLite-specific commands, see the `using-sqlite` skill. ## Prerequisites - **CSV file accessible** on local filesystem - **Database** with SQL support (DataPeeker uses SQLite at `data/analytics.db`) - **Workspace created** for analysis session (via `just start-analysis` or equivalent) - **Understanding** that this skill creates `raw_*` tables, not final tables (cleaning-data handles finalization) ## Data Import Process Create a TodoWrite checklist for the 5-phase data import process: ``` Phase 1: CSV Discovery & Profiling - pending Phase 2: Schema Design & Type Inference - pending Phase 3: Basic Standardization - pending Phase 4: Import Execution - pending Phase 5: Quality Assessment & Reporting - pending ``` Mark each phase as you complete it. Document all findings in numbered markdown files (`01-csv-profile.md` through `05-quality-report.md`) within your analysis workspace directory. --- ## Phase 1: CSV Discovery & Profiling
Details
- Skill name
importing-data- Repository
- tilmon-engineering/claude-skills
- Path
plugins/datapeeker/skills/importing-data/SKILL.md- License
- MIT
- Repo updated
- 22 May 2026
FAQ
What does the Importing Data skill do?
Systematic CSV import process - discover structure, design schema, standardize formats, import to database, detect quality issues (component skill for DataPeeker analysis sessions)
How do I install the Importing Data skill?
Claude Code plugin: /plugin marketplace add tilmon-engineering/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Importing Data popular?
It lives in tilmon-engineering/claude-skills, which has 5 GitHub stars and 2 forks.
Related skills
Analyze Branch
5tilmon-engineering/claude-skills
Use when analyzing another branch's iteration journals to extract findings, decisions, and insights from divergent work
Branch Status
5tilmon-engineering/claude-skills
Use when user wants detailed status report for single autonomy branch including iteration timeline and metrics progression
Checkpoint Iteration
5tilmon-engineering/claude-skills
Use when saving current iteration progress mid-conversation, before context compaction, or at interim pause points
Using Sqlite
5tilmon-engineering/claude-skills
Use when working with SQLite databases in DataPeeker analysis sessions - querying data, importing CSVs, exploring schemas, formatting output, or optimizing performance. Provides task-oriented guidance for effective SQLite CLI usage in data analysis workflows.
SQL Optimization
9sandbaseai/workbuddy-skill
Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
Using Typedb
5tilmon-engineering/claude-skills
Use when interacting with a TypeDB 3.x database via the typedb MCP tools (typedb-query, typedb-database_schema, etc.) - covers schema-first workflow, transaction types, TypeQL 3.x syntax (which differs materially from 2.x), and the most common failure modes
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.