/ Verzeichnis / Playground / csv-data-summarizer-claude-skill
● Community coffeefuelbump ⚡ Sofort

csv-data-summarizer-claude-skill

von coffeefuelbump · coffeefuelbump/csv-data-summarizer-claude-skill

Drop a CSV, get summary stats, missing-data flags, and quick charts — without writing pandas.

A focused Claude skill that auto-activates on CSV files: it profiles the columns (dtype, null %, uniques), prints summary statistics, flags missing-data patterns, and generates a few quick visualizations using pandas and matplotlib. Designed as a good first-look tool before deeper analysis.

Warum nutzen

Hauptfunktionen

Live-Demo

In der Praxis

csv-data-summarizer-claude-skill.replay ▶ bereit
0/0

Installieren

Wählen Sie Ihren Client

~/Library/Application Support/Claude/claude_desktop_config.json  · Windows: %APPDATA%\Claude\claude_desktop_config.json
{
  "mcpServers": {
    "csv-data-summarizer-claude-skill": {
      "command": "git",
      "args": [
        "clone",
        "https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill",
        "~/.claude/skills/csv-data-summarizer-claude-skill"
      ],
      "_inferred": true
    }
  }
}

Öffne Claude Desktop → Settings → Developer → Edit Config. Nach dem Speichern neu starten.

~/.cursor/mcp.json · .cursor/mcp.json
{
  "mcpServers": {
    "csv-data-summarizer-claude-skill": {
      "command": "git",
      "args": [
        "clone",
        "https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill",
        "~/.claude/skills/csv-data-summarizer-claude-skill"
      ],
      "_inferred": true
    }
  }
}

Cursor nutzt das gleiche mcpServers-Schema wie Claude Desktop. Projektkonfiguration schlägt die globale.

VS Code → Cline → MCP Servers → Edit
{
  "mcpServers": {
    "csv-data-summarizer-claude-skill": {
      "command": "git",
      "args": [
        "clone",
        "https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill",
        "~/.claude/skills/csv-data-summarizer-claude-skill"
      ],
      "_inferred": true
    }
  }
}

Klicken Sie auf das MCP-Servers-Symbol in der Cline-Seitenleiste, dann "Edit Configuration".

~/.codeium/windsurf/mcp_config.json
{
  "mcpServers": {
    "csv-data-summarizer-claude-skill": {
      "command": "git",
      "args": [
        "clone",
        "https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill",
        "~/.claude/skills/csv-data-summarizer-claude-skill"
      ],
      "_inferred": true
    }
  }
}

Gleiche Struktur wie Claude Desktop. Windsurf neu starten zum Übernehmen.

~/.continue/config.json
{
  "mcpServers": [
    {
      "name": "csv-data-summarizer-claude-skill",
      "command": "git",
      "args": [
        "clone",
        "https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill",
        "~/.claude/skills/csv-data-summarizer-claude-skill"
      ]
    }
  ]
}

Continue nutzt ein Array von Serverobjekten statt einer Map.

~/.config/zed/settings.json
{
  "context_servers": {
    "csv-data-summarizer-claude-skill": {
      "command": {
        "path": "git",
        "args": [
          "clone",
          "https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill",
          "~/.claude/skills/csv-data-summarizer-claude-skill"
        ]
      }
    }
  }
}

In context_servers hinzufügen. Zed lädt beim Speichern neu.

claude mcp add csv-data-summarizer-claude-skill -- git clone https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill ~/.claude/skills/csv-data-summarizer-claude-skill

Einzeiler. Prüfen mit claude mcp list. Entfernen mit claude mcp remove.

Anwendungsfälle

Praxisnahe Nutzung: csv-data-summarizer-claude-skill

How to get a first look at a new CSV without writing pandas

👤 Analysts, PMs, anyone inheriting someone else's data ⏱ ~10 min beginner

Wann einsetzen: You got handed a CSV and need to understand what's in it before doing anything else.

Voraussetzungen
  • Python 3.10+ with pandas and matplotlib — pip install pandas matplotlib
  • Skill cloned — git clone https://github.com/coffeefuelbump/csv-data-summarizer-claude-skill ~/.claude/skills/csv-data-summarizer-claude-skill
Ablauf
  1. Point Claude at the file
    Summarize data/sales_2024.csv — columns, nulls, and basic stats.✓ Kopiert
    → Per-column dtype, null %, min/max or top values
  2. Ask for missing-data diagnosis
    Which columns have systematic nulls? Any row-level patterns?✓ Kopiert
    → Specific columns flagged, not vague 'some nulls'
  3. Request quick visuals
    Save histograms for all numeric columns into ./charts/.✓ Kopiert
    → PNG files on disk

Ergebnis: A one-page mental model of the dataset in under 5 minutes.

Fallstricke
  • Huge CSVs blow the token budget — Have Claude read a sample (nrows=10000) for exploration, run stats on the full file in Python
  • Dtype misinference (dates read as strings) — Tell Claude which columns are dates — pandas parse_dates helps
Kombinieren mit: filesystem

Use the summarizer as a data-quality gate in a pipeline

👤 Data engineers validating incoming CSVs ⏱ ~30 min intermediate

Wann einsetzen: You receive a daily CSV and want to flag anomalies before downstream steps.

Ablauf
  1. Baseline the expected shape
    Record the summary for last week's file as the baseline.✓ Kopiert
    → Baseline JSON saved
  2. Compare today against baseline
    Compare today's CSV to the baseline — flag null-rate shifts >5%, new/missing columns, dtype changes.✓ Kopiert
    → Diff report with specific anomalies
  3. Fail loudly if bad
    If any flags are critical, exit non-zero so CI fails.✓ Kopiert
    → Non-zero exit + readable reason

Ergebnis: Bad data caught before it pollutes the warehouse.

Fallstricke
  • Threshold too sensitive — noisy failures — Calibrate on 30 days of baselines before enforcing
Kombinieren mit: github

Kombinationen

Mit anderen MCPs für 10-fache Wirkung

csv-data-summarizer-claude-skill + filesystem

Run against a directory of CSVs and save each report next to the file

For every CSV under data/, save a matching *_profile.md file summarizing it.✓ Kopiert
csv-data-summarizer-claude-skill + jupyter

Drop the profile into a notebook for further exploration

Take the profile and create a Jupyter notebook with the loaded DataFrame and starter cells.✓ Kopiert

Werkzeuge

Was dieses MCP bereitstellt

WerkzeugEingabenWann aufrufenKosten
csv-profile path to CSV First step on any new CSV pandas runtime
missing-data-report profile After profiling 0
quick-charts profile + output dir When you want visuals alongside stats matplotlib runtime

Kosten & Limits

Was der Betrieb kostet

API-Kontingent
none
Tokens pro Aufruf
~2–5k tokens per CSV (plus the data sample Claude reads)
Kosten in €
free
Tipp
Pass nrows and a narrowed column list — don't feed Claude the whole 50MB file

Sicherheit

Rechte, Secrets, Reichweite

Credential-Speicherung: none
Datenabfluss: none — local pandas only

Fehlerbehebung

Häufige Fehler und Lösungen

ModuleNotFoundError: pandas

pip install pandas matplotlib in the env where Claude Code runs scripts.

Prüfen: python -c 'import pandas, matplotlib; print(pandas.__version__)'
UnicodeDecodeError on load

Tell Claude the encoding (e.g. 'encoding=latin-1') or normalize the file first.

Prüfen: file -I path/to.csv
Charts look off for skewed data

Ask for log-scale or clipped histograms

Alternativen

csv-data-summarizer-claude-skill vs. andere

AlternativeWann stattdessenKompromiss
jupyterYou want full interactive analysis, not just a profileHeavier; needs a kernel
excelThe data is better in Excel (pivot tables, formulas)Harder to automate

Mehr

Ressourcen

📖 Offizielle README auf GitHub lesen

🐙 Offene Issues ansehen

🔍 Alle 400+ MCP-Server und Skills durchsuchen