explore-data

Profiles datasets to assess structure, quality, distributions, and analysis opportunities.

6|1|Updated Sep 3, 2026
One-click install
npx skills add https://github.com/jasonzhu0922-sketch/agentloop --skill explore-data-jasonzhu0922-sketch
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: explore-data
Source: https://github.com/jasonzhu0922-sketch/agentloop/tree/main/packages/agentloop-skills/skills/explore-data
Command: npx skills add https://github.com/jasonzhu0922-sketch/agentloop --skill explore-data-jasonzhu0922-sketch

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? When you encounter a new table or data file, you often don't know its shape, quality, or which dimensions and metrics are worth analyzing. This Skill generates a comprehensive data profile so you can understand a dataset before writing analysis queries. ## Core Features & Use Cases - Automated Data Profiling: Computes row counts, null rates, cardinality, distributions, percentiles, and date ranges for every column, grouped by type (dimensions, metrics, dates, IDs). - Data Quality Detection: Flags high null rates, placeholder values, duplicates, inconsistent formats, impossible values, and suspicious distributions using a structured quality assessment framework. - Analysis Recommendations: Identifies the best dimension and metric columns, foreign key candidates, hierarchies, and suggests 3-5 concrete follow-up analyses. - Use Case: You connect a data warehouse and point the Skill at an unfamiliar orders table. It returns a profile showing 2.3M rows, flags a discount column with 40% nulls and negative amounts, and recommends a revenue trend analysis by region. ## Quick Start Ask the assistant to profile the table or uploaded file you want to understand, for example by saying: run explore-data on the orders table and summarize its quality issues.

Frequently Asked Questions about explore-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I profile a new dataset before analyzing it?

Run a data profiling pass that computes row counts, null rates, distinct counts, and value distributions for every column. This Skill automates that workflow for warehouse tables or uploaded files like CSV, Excel, Parquet, and JSON, then summarizes results grouped by column type.

How to check data quality issues in a SQL table?

Check null rates per column, duplicate natural keys, placeholder values like 'N/A' or 999999, negative amounts, and future dates. The Skill applies a quality framework that flags columns over 5% nulls as warnings and over 20% as alerts, plus consistency and accuracy checks.

Can I profile a CSV or Excel file without a database?

Yes, the Skill reads uploaded CSV, Excel, Parquet, or JSON files directly, infers column types from the data, and runs the same profiling checks it would against a warehouse table. No database connection is required for file-based profiling.

What statistics should I compute for numeric columns?

Compute min, max, mean, median, standard deviation, percentiles (p1 through p99), zero counts, and unexpected negative counts. These reveal distribution shape, skew, and outliers that affect whether averages are meaningful for the column.

Does data profiling work on very large tables?

For tables over 100M rows, profiling queries use sampling by default rather than full scans. You can request exact counts when needed, but sampled profiles are usually sufficient to understand structure and spot quality issues.