Skip to main content
Glama
tofunori

Claude MCP Data Explorer

by tofunori

Windows용 Claude MCP 데이터 탐색기

Claude를 통한 데이터 탐색을 위한 모델 컨텍스트 프로토콜(MCP) 서버의 TypeScript 구현입니다. 이 서버는 Claude Desktop과 통합되어 CSV 파일을 로드하고 JavaScript 데이터 분석 스크립트를 실행하는 도구를 제공하여 고급 데이터 분석을 지원합니다.

필수 조건

Related MCP server: mcp-csv-analyst

설치(Windows용으로 업데이트됨)

  1. 이 저장소를 복제하세요

    지엑스피1

  2. 종속성 설치

    npm install
  3. 설치 스크립트 빌드 및 실행

    npm run setup

    이렇게 하면:

    • TypeScript 코드를 JavaScript로 빌드합니다.

    • 컴파일된 JavaScript를 사용하도록 Claude Desktop을 구성합니다.

    • 필요한 디렉토리를 생성합니다

  4. Claude Desktop을 다시 시작하고 개발자 모드를 활성화하세요.

    • Claude Desktop을 완전히 닫습니다.

    • Claude Desktop 시작

    • 도움말 → 개발자 모드 활성화로 이동

수동 테스트

다음을 실행하여 서버를 직접 테스트할 수 있습니다.

npm run build
npm run start

서버가 오류 없이 시작될 것입니다. 이 과정을 성공적으로 실행하면 Claude Desktop에서도 서버를 사용할 수 있을 것입니다.

작동 원리

이 MCP 서버는 Claude에게 두 가지 주요 도구를 제공합니다.

  1. load-csv - 분석을 위해 CSV 데이터를 메모리에 로드합니다.

  2. run-script - 데이터 처리 및 분석을 위한 JavaScript 코드를 실행합니다.

또한 클로드가 구조화된 데이터 탐색 과정을 안내하는 프롬프트 템플릿도 포함되어 있습니다.

용법

  1. Claude Desktop 시작

  2. "데이터 탐색" 프롬프트 템플릿을 선택하세요

    • 이 프롬프트는 설정 후 Claude Desktop에 나타납니다.

  3. CSV 파일 경로와 탐색 주제를 입력하세요

    • 예시 파일 경로: C:/Users/YourName/Documents/data.csv

    • 예시 주제: "지역별 판매 추세"

  4. Claude가 귀하의 데이터를 분석하게 하세요

    • Claude는 CSV 파일을 로드하고 자동으로 통찰력을 생성합니다.

    • 서버는 청킹을 사용하여 대용량 파일을 효율적으로 처리합니다.

문제 해결

  1. Claude는 MCP 서버를 표시하지 않습니다.

    • %APPDATA%\Claude\claude_desktop_config.json 의 구성 파일을 확인하세요.

    • dist 디렉토리에 있는 컴파일된 JavaScript 파일을 가리켜야 합니다.

    • npm run build 로 프로젝트를 다시 빌드해보세요.

    • 개발자 모드를 활성화하고 MCP 로그 파일을 확인하세요(개발자 → MCP 로그 파일 열기)

    • 개발자 → 모든 MCP 서버 다시 로드를 사용하여 강제로 새로 고침

  2. 파일 읽기 권한 오류

    • Claude가 CSV 파일 위치에 액세스할 수 있는지 확인하세요.

    • 절대 경로와 함께 슬래시( / ) 또는 이스케이프된 백슬래시( \\ )를 사용해 보세요.

  3. 스크립트의 JavaScript 오류

    • 스크립트가 허용된 모듈과 호환되는지 확인하세요.

    • Claude의 응답에서 오류 메시지를 검토하세요.

특허

MIT 라이센스 - 자세한 내용은 라이센스 파일을 참조하세요.

감사의 말

  • Anthropic의 공식 MCP TypeScript SDK 기반

  • 예시와 영감을 제공해 주신 MCP 커뮤니티에 감사드립니다.

Available Tools

2 tools
load-csvC

Load a CSV file into a DataFrame for analysis

ParametersJSON Schema
NameRequiredDescriptionDefault
csv_pathYesPath to the CSV file to load
df_nameNoName for the DataFrame (optional, defaults to df_1, df_2, etc.)

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the action 'load a CSV file into a DataFrame' but lacks details on permissions needed, error handling (e.g., invalid paths), rate limits, or what happens after loading (e.g., memory usage, persistence). For a tool with no annotation coverage, this is a significant gap.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core action ('Load a CSV file') and purpose ('for analysis'). There is zero waste, making it highly concise and well-structured for quick understanding.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no annotations, no output schema, and a tool that performs data loading (a potentially complex operation with file I/O), the description is incomplete. It doesn't cover behavioral aspects like error conditions, return values, or dependencies, leaving gaps for an AI agent to use it correctly in varied contexts.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents both parameters (csv_path and df_name) with clear descriptions. The description adds no additional meaning beyond implying CSV loading for analysis, which aligns with the schema but doesn't provide extra syntax or format details. Baseline 3 is appropriate when the schema does the heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the verb 'load' and resource 'CSV file', specifying it's for analysis via a DataFrame. It distinguishes from the sibling 'run-script' by focusing on data loading rather than script execution. However, it doesn't explicitly differentiate from potential other data loading tools (none listed), keeping it at 4.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance is provided on when to use this tool versus alternatives. The description implies it's for loading CSV files into DataFrames, but there's no mention of prerequisites (e.g., file accessibility), when not to use it (e.g., for non-CSV files), or alternatives like 'run-script' for other data processing. This leaves usage context vague.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

run-scriptC

Execute a JavaScript script for data analysis and visualization

ParametersJSON Schema
NameRequiredDescriptionDefault
scriptYesJavaScript script to execute

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden of behavioral disclosure. It states the tool executes a JavaScript script but doesn't describe safety aspects (e.g., sandboxing, permissions), performance traits (e.g., execution time limits, resource usage), or what happens upon execution (e.g., output format, side effects). For a tool that runs arbitrary code with no annotation coverage, this is a significant gap.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that directly states the tool's purpose without unnecessary words. It is appropriately sized and front-loaded, with every part contributing essential information (verb, resource, domain).

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity of executing arbitrary JavaScript code, the lack of annotations, and no output schema, the description is incomplete. It doesn't address critical aspects like security implications, error handling, or what the tool returns (e.g., visualization output, analysis results). For a tool with such potential impact, more context is needed.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 100% description coverage, with one parameter 'script' fully documented in the schema. The description adds no additional meaning about parameters beyond what the schema provides (e.g., no examples of script content, no constraints on JavaScript features). With high schema coverage, the baseline score of 3 is appropriate as the description doesn't compensate but doesn't detract either.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose with a specific verb ('Execute') and resource ('JavaScript script'), and specifies the domain ('for data analysis and visualization'). It doesn't distinguish from the sibling tool 'load-csv', which appears to be a different operation, so it doesn't explicitly differentiate from siblings.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives. It mentions the domain (data analysis and visualization) but doesn't specify prerequisites, limitations, or when not to use it. There's no explicit comparison with the sibling tool 'load-csv' or other potential tools.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

  1. 2 tool updates
    • First observedload-csv
    • First observedrun-script

TDQS

B3/5.0

Scored across 2 tools

Disambiguation5/5

The two tools have clearly distinct purposes: one loads CSV data into a DataFrame, while the other executes JavaScript scripts for analysis and visualization. There is no overlap or ambiguity between these functions, making it easy for an agent to select the correct tool.

Naming Consistency4/5

Both tools use a verb-noun pattern (load-csv, run-script), which is consistent and readable. The hyphenated style is maintained throughout, though the specific convention (hyphens vs. underscores) is less important than the consistency, which is good here with only minor deviations from common patterns.

Tool Count2/5

With only two tools, the server feels thin for a 'Data Explorer' purpose, as it lacks essential operations like data querying, filtering, transformation, or exporting. While the tools are functional, the count is too low to adequately cover the expected scope of data exploration and analysis.

Completeness2/5

For a data exploration server, there are significant gaps: no tools for querying data, filtering, aggregating, visualizing beyond scripts, or exporting results. The surface is severely incomplete, as agents cannot perform basic data exploration tasks without relying heavily on external scripts, leading to potential failures in common workflows.

Maintenance

ActivityInactive
ResponsivenessNo issues

Related MCP Connectors

Related MCP Servers

  • A
    license
    A
    quality
    Not graded
    maintenance
    An MCP server that enables AI assistants to load, query, and analyze local CSV files using tools for filtering, aggregation, and grouping. It provides capabilities to describe schemas, calculate statistics, and sample data directly from CSV files.
    6
    -
  • F
    license
    Not graded
    quality
    D
    maintenance
    A local MCP server for analyzing CSV files from your filesystem, particularly suited for chatbot conversation logs. Allows listing, reading, filtering, merging, and statistical analysis of CSV data via natural language.
    -
  • F
    license
    A
    quality
    D
    maintenance
    An MCP server for dataset exploration and analysis, enabling LLM clients to perform summary, correlation, distribution, missing value analysis, data cleaning, and statistical tests directly on CSV files.
    3
    -