csv-insight-mcp/
├── sample_data/
│   └── messy_sales.csv          # sample dataset for demos
├── src/
│   └── csvinsight/
│       ├── __init__.py          # package exports
│       ├── __main__.py          # `python -m csvinsight` entrypoint
│       └── server.py            # core server (Tools, Resources, Prompts)
├── tests/
│   └── test_server.py           # pytest smoke tests
├── .vscode/
│   └── mcp.json                 # VS Code Copilot Chat MCP config
├── pyproject.toml
└── README.md

+-------------------------------------------------------------------------------+
|                                  MCP CLIENT                                   |
|         (VS Code Copilot Chat / Claude Desktop / Cursor IDE / Custom AI)      |
+-------------------------------------------------------------------------------+
                                       ▲
                                       │ JSON-RPC 2.0 (stdio)
                                       ▼
+-------------------------------------------------------------------------------+
|                       CSV INSIGHT & CLEANER MCP SERVER                        |
|                                                                                 |
|   [TOOLS]                     [RESOURCES]                 [PROMPTS]           |
|   • inspect_csv               • csv://current             • analyze_dataset   |
|   • summarize_csv               (dataset snapshot)         • clean_and_report |
|   • preview_csv               • csv://cleaning-report                        |
|   • clean_csv                   (before/after report)                        |
|   • get_cleaning_report                                                       |
|   • export_cleaned_csv                                                        |
+-------------------------------------------------------------------------------+
                                       │
                                       ▼
                            Python / pandas Engine
                         (in-memory dataframe, per session)

# Clone and enter the project
git clone https://github.com/your-username/csv-insight-mcp.git
cd csv-insight-mcp

# Install in editable mode
pip install -e .

# Run tests
pytest -v

# Run the server directly over stdio
python -m csvinsight

{
  "servers": {
    "csv-insight-cleaner": {
      "type": "stdio",
      "command": "python",
      "args": ["-m", "csvinsight"],
      "cwd": "${workspaceFolder}"
    }
  }
}

{
  "mcpServers": {
    "csv-insight-cleaner": {
      "command": "python",
      "args": ["-m", "csvinsight"],
      "cwd": "/absolute/path/to/csv-insight-mcp"
    }
  }
}

"Analyze this CSV." (paste contents of messy_sales.csv)
   → inspect_csv → rows, columns, 1 duplicate row, 1 empty row, 2 missing emails

"What problems does it have?"
   → AI explains the data-quality section in plain language

"Clean the safe issues."
   → clean_csv → duplicates & empty rows removed, columns standardized

"What did you change?"
   → get_cleaning_report → before/after row counts + list of changes

"Give me the cleaned file."
   → export_cleaned_csv → ready-to-save CSV text

pytest -v