Importing Data

Systematic CSV import process - discover structure, design schema, standardize formats, import to database, detect quality issues (component skill for DataPeeker analysis sessions)

5 stars 2 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add tilmon-engineering/claude-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add tilmon-engineering/claude-skills --skill importing-data
Manual install
git 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-data

Personal 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
Read the full skill on GitHub

Details

Skill name
importing-data
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

5

tilmon-engineering/claude-skills

Use when analyzing another branch's iteration journals to extract findings, decisions, and insights from divergent work

Git & Code Review

Branch Status

5

tilmon-engineering/claude-skills

Use when user wants detailed status report for single autonomy branch including iteration timeline and metrics progression

Git & Code Review

Checkpoint Iteration

5

tilmon-engineering/claude-skills

Use when saving current iteration progress mid-conversation, before context compaction, or at interim pause points

Other

Using Sqlite

5

tilmon-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.

Databases

SQL Optimization

9

sandbaseai/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.

Databases

Using Typedb

5

tilmon-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

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.