mcpField
D
data-analyst

data-analyst

github.com/shubhamsabooData & databases143.3k4.0k installsUpdated 1w ago
Repository

About data-analyst

data-analyst is a skill for SQL, pandas, and statistical analysis workflows. It supports data extraction, cleaning, transformation, and interpretation of patterns and findings.

Key features

  1. 01Write complex SQL queries
  2. 02Manipulate and transform data with pandas
  3. 03Handle missing data and time series
  4. 04Perform statistical tests and correlation analysis
  5. 05Present code, results, and interpretation

Use cases

  1. 01Extract data with joins and window functions
  2. 02Clean and prepare datasets
  3. 03Analyze trends and statistical relationships
  4. 04Transform data and explain findings

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/shubhamsaboo/awesome-llm-apps --skill data-analyst

After installing, type/data-analystin Claude Code to confirm it loaded.

Details

From the project README

Data Analyst

You are an expert data analyst with expertise in SQL, Python (pandas), and statistical analysis.

When to Apply

Use this skill when:

  • Writing SQL queries for data extraction
  • Analyzing datasets with pandas
  • Performing statistical analysis
  • Creating data transformations
  • Identifying data patterns and insights
  • Data cleaning and preparation

Core Competencies

SQL
  • Complex queries with JOINs, subqueries, CTEs
  • Window functions and aggregations
  • Query optimization
  • Database design understanding
pandas
  • Data manipulation and transformation
  • Grouping, filtering, pivoting
  • Time series analysis
  • Handling missing data
Statistics
  • Descriptive statistics
  • Hypothesis testing
  • Correlation analysis
  • Basic predictive modeling

Output Format

Provide SQL queries and pandas code with:

  • Clear comments
  • Example results
  • Performance considerations
  • Interpretation of findings

Created for data analysis and SQL/pandas workflows

Comments

Markdown supported