GROUP BY and pivot tables for JSON rows: 11 functions, date buckets, top N, totals, messy numbers.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add --transport http dataset-aggregate-pivot https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp~/.codex/config.toml
[mcp_servers.dataset-aggregate-pivot]
url = "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
# codex mcp add dataset-aggregate-pivot --url https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp~/.cursor/mcp.json
{
"mcpServers": {
"dataset-aggregate-pivot": {
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}.vscode/mcp.json
{
"servers": {
"dataset-aggregate-pivot": {
"type": "http",
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"dataset-aggregate-pivot": {
"httpUrl": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}claude_desktop_config.json · Customize › Connectors › Add custom connector
{
"mcpServers": {
"dataset-aggregate-pivot": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
]
}
}
}.trae/mcp.json
{
"mcpServers": {
"dataset-aggregate-pivot": {
"url": "https://dataset-aggregate-pivot.nerolabs.workers.dev/mcp"
}
}
}