Dataset Aggregate & Pivot MCP Server
io.github.Nero-Engine/dataset-aggregate-pivot
What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
What is the Dataset Aggregate & Pivot MCP server?
GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
How to install Dataset Aggregate & Pivot
Copy-paste configuration for popular MCP clients.
{
"mcpServers": {
"dataset-aggregate-pivot": {
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}Related MCP servers
Run one LLM instruction over every row to classify, extract or summarise into new columns.
Turn rows into bar, line, pie and scatter chart images plus an optional PDF or HTML report.

Dedupe, flatten and clean messy JSON rows (emails, phones, URLs, HTML) in one call, as JSON or CSV.

Compare two versions of a JSON row list: what was added, removed or changed, field by field.

Clean, filter and reshape JSON rows in one call: 26 transforms, 25 filters, sort, dedupe, limit.

Dataset Join & Merge
Join two lists of JSON rows on a key, like SQL or VLOOKUP: left, inner, full, anti joins, union.