Data Analysis AI Skills — SQL, Pandas, Excel, Visualization (2026) | Skills and Servers
Category · 22 Skills

Data Analysis Skills — SQL, Pandas, Excel Analysis, Visualization (2026)

Every AI Skill in our directory that reasons about data — SQL queries you can trust, Pandas transformations that don't invent columns, Excel models that reconcile, statistical tests with the right assumptions, and visualizations that make the story clear. Each Skill has been installed, tested against real messy data, and documented for Claude, ChatGPT, Cursor, and Cline.

22
Skills
6
Sub-types
5
Providers
100%
Human-tested
Last updated August 15, 2026

1What this category covers

Data Analysis Skills sit between raw data and business decisions. They accept structured input (CSV files, database rows, Excel workbooks, JSON payloads) and produce answers — a query result, a cleaned dataset, a summary statistic, a chart, a forecast. Under the hood most of these Skills wrap well-known Python libraries (pandas, numpy, scipy, statsmodels, plotly, matplotlib) or delegate to a database engine directly.

The value the Skill layer adds is discipline — refusing to invent columns that aren't in the data, checking dtypes before applying operations that require specific types, flagging when a query result seems surprisingly large or small, and asking clarifying questions when the input is ambiguous ("which date column did you mean?"). Plain LLM output for data work is notoriously prone to hallucinated columns and quietly incorrect aggregations; Skills lock the discipline in.

What lives here vs. elsewhere: if the Skill's output is a data artifact (a query, a cleaned frame, a chart, a summary stat), it belongs here. If it produces a document that contains data (a PDF report with charts), that lives in Document Creation. If it fetches data from a live web source, that lives in Web & API. If it's an autonomous multi-step research workflow, see Research & Analysis.

2When you should reach for a Data Analysis Skill

  • You have a CSV, Excel file, or database and want AI to answer specific questions about the data without hand-writing the queries.
  • You need to clean messy data (date formats, encoding, dedupe, categorical values) before loading it into a downstream system.
  • You're building a recurring report — same shape, different data — and want an AI to keep it updated without you rewriting the pipeline every week.
  • You want AI-generated statistical work (t-tests, regressions, forecasts) with the assumption checks a human analyst would do.
  • You need visualizations that are correct rather than beautiful-but-misleading — the Skill layer keeps chart choices honest.

3Featured Skills this month

Our editorial picks — heaviest tested, highest reader ratings.

4All 22 Data Analysis Skills

Filter by sub-type, search by name, sort by recency or alphabetical.

Showing 22 of 22 Skills
SQLAug 1

SQL Anti-Pattern Detector

Scan SQL files for common anti-patterns: implicit cross-joins, missing WHERE, N+1 patterns, unsafe LIMIT ordering.

View →
PandasAug 8

Pandas to SQL Converter

Convert Pandas operations to equivalent SQL for pushing computation down to the database rather than in-memory.

View →
PandasAug 6

Pandas Memory Optimizer

Analyze a DataFrame's memory usage and suggest dtype changes, categorical conversions, or chunked processing.

View →
StatisticsAug 7

Regression Analysis with Diagnostics

Fit linear or logistic regression, produce coefficient table with confidence intervals, run diagnostic checks (residuals, collinearity, leverage).

View →
VisualizationAug 10

Chart Generator with Honest Axes

Produce Plotly or matplotlib charts. Refuses to truncate y-axes to exaggerate differences; annotates the actual data range clearly.

View →
CleaningAug 8

Fuzzy Record Deduplication

Detect near-duplicate records using edit distance + phonetic matching. Presents candidates for human review before merging.

View →

5Related MCP servers

MCP servers our team pairs with Data Analysis Skills for full workflows.

MCP Server

Postgres MCP Server

Query Postgres databases in natural language. Pairs with the SQL Skills for read-only exploration workflows.

MCP Server

MySQL MCP Server

Sister database server for MySQL / MariaDB / Aurora MySQL. Same tool surface as Postgres MCP.

MCP Server

SQLite MCP Server

Local file-based database. Great for prototyping data models before productionizing.

MCP Server

Google Sheets MCP Server

Read from and write to Google Sheets. Pairs with Excel-adjacent Skills for cloud-first teams.

MCP Server

AWS S3 MCP Server

Read raw data files from S3 for cleaning and analysis without downloading locally.

6Related Learn guides

Longer-form tutorials for the concepts behind these Skills.

7Comparisons worth reading

Head-to-head reviews that touch on Data Analysis workflows.

8Frequently asked questions

Every Skill in this category starts with a schema discovery step — it reads the actual columns, dtypes, and sample rows from the input before proposing any query or transformation. Skills refuse to reference columns that don't exist in the input. If you ask for something that requires a column not present, the Skill will ask you to point to the right column rather than guess. This is the single biggest quality difference between Skill-mediated data work and plain LLM prompting.
For read-only workflows, yes — most Skills default to read-only and clearly flag when they would write. For write workflows, we strongly recommend using a database user or file copy with limited permissions rather than production write access. See the individual Skill pages for per-Skill safety notes. The CSV Data Cleaning Skill in particular is idempotent (safe to re-run) and always produces a transformation report so you can audit changes.
For SQL and Pandas: Claude Opus 4.7 and GPT-5 are near-tied at the top, with Claude slightly better on complex CTEs and GPT-5 slightly better on window functions. For financial modeling and statistical analysis: Claude Opus 4.7 is the recommended default due to extended-thinking benefits on multi-step reasoning. For high-volume cleaning jobs: DeepSeek V4 is competitive with GPT-5 mini at much lower cost. See each Skill's Provider Compat table for per-Skill notes.
Depends on the Skill. SQL Skills that operate on a live database benefit hugely from having Postgres MCP or MySQL MCP connected — the Skill can read schemas and verify assumptions. For file-based work (CSV cleaning, Excel formulas), no MCP server is required; the Skills work purely on the files you provide. See each Skill's Related MCP Servers section for specific recommendations.
Claude for Excel and ChatGPT Advanced Data Analysis are provider-specific AI features that run in a specific product surface. These Skills are provider-agnostic — they work on Claude, GPT-5, Gemini, Mistral, etc., via the standard Skills format. The value trade-off: provider-native features often have deeper integration (one-click Excel access from Copilot); Skills give you portability and consistency across whichever AI provider you're using. Most teams use both — provider-native for in-product work, Skills for cross-tool AI workflows.

Working on a real Data Analysis problem?

Our sister sites cover errors and code recipes across the AI ecosystem. Bookmark them for when a Skill hits an edge case.

Visit AI Error Hub

Share with