# Data Pad

> Use when: the user provides a CSV, JSON, or NDJSON file and wants analysis, filtering, aggregation, or exploration. Also use when you have structured data from an API and want to query it.

- **Type:** Skill
- **Install:** `agentstack add skill-jansenanalytics-claudex-data-pad`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [JansenAnalytics](https://agentstack.voostack.com/s/jansenanalytics)
- **Installs:** 0
- **Category:** [Data & Analytics](https://agentstack.voostack.com/c/data-and-analytics)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [JansenAnalytics](https://github.com/JansenAnalytics)
- **Source:** https://github.com/JansenAnalytics/claudex/tree/main/skills/data-pad

## Install

```sh
agentstack add skill-jansenanalytics-claudex-data-pad
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Data Pad Skill

Use when: the user provides a CSV, JSON, or NDJSON file and wants analysis, filtering, aggregation, or exploration. Also use when you have structured data from an API and want to query it.

## Load data

```
node ${DATA_PAD_HOME:-$HOME/projects/data-pad}/load.cjs --file  [--table name] [--db name] [--overwrite]
node ${DATA_PAD_HOME:-$HOME/projects/data-pad}/load.cjs --file data.csv --table customers --db analysis
```

## Supported formats: .csv, .json, .ndjson

## Also supports: --url https://... (fetches JSON from URL)

## Run a query

```
node ${DATA_PAD_HOME:-$HOME/projects/data-pad}/query.cjs "SQL here" [--db name]
node ${DATA_PAD_HOME:-$HOME/projects/data-pad}/query.cjs "SELECT country, SUM(revenue) FROM customers GROUP BY country ORDER BY 2 DESC LIMIT 10"
```

## Explore schema

```
node ${DATA_PAD_HOME:-$HOME/projects/data-pad}/describe.cjs [--db name]
```

## List all databases

```
node ${DATA_PAD_HOME:-$HOME/projects/data-pad}/list-dbs.cjs
```

## Export results

```
node ${DATA_PAD_HOME:-$HOME/projects/data-pad}/export.cjs "SELECT ..." --out results.csv [--db name]
```

## Output formats for query

- `--csv` machine-readable CSV
- `--json` JSON array
- (default: pretty ASCII table)

## Common SQL patterns

```sql
-- Top N by value
SELECT name, revenue FROM customers ORDER BY revenue DESC LIMIT 10

-- Aggregation
SELECT country, COUNT(*) as count, AVG(revenue) as avg_rev FROM customers GROUP BY country

-- Filter + count
SELECT COUNT(*) FROM orders WHERE status = 'failed' AND amount > 100

-- Join (if you have multiple tables)
SELECT c.name, SUM(o.amount) FROM customers c JOIN orders o ON c.id = o.customer_id GROUP BY c.id
```

## Databases are stored at

`${DATA_PAD_HOME:-$HOME/projects/data-pad}/databases/`

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [JansenAnalytics](https://github.com/JansenAnalytics)
- **Source:** [JansenAnalytics/claudex](https://github.com/JansenAnalytics/claudex)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-jansenanalytics-claudex-data-pad
- Seller: https://agentstack.voostack.com/s/jansenanalytics
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.