Dataset Aggregate, Group By & Pivot

Server Details

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON...

The last two health checks of this connector failed. If this server requires authentication, missing or expired test credentials may be the cause. A test profile lets Glama authenticate for health checks and discover tools; it is separate from your personal connections.

If you are the author, claim ownership, then add or update a test profile under Admin → Test Profile.

Status: Unhealthy
Uptime: 0.0% over the last 24 hours
OAuth: Works in Glama
Last Tested: 2026-11-10 08:14
Transport: Streamable HTTP
URL
ChatGPT: –
Claude: –

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

Related MCP Connectors

Dataset Cleaner & Exporter
io.github.Nero-Engine
Returns a deduplicated, flattened and cleaned copy of any Apify dataset, file or Google Sheet by...
Data Platforms File Systems Workplace & Productivity
1
https://mcp.apify.com/?tools=nerolabs/dataset-cleaner-exporter
Dataset Join & Merge (VLOOKUP for Datasets)
io.github.Nero-Engine
Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields...
Data Platforms App Automation
1
https://mcp.apify.com/?tools=nerolabs/dataset-join-merge
Dataset Filter & Transform
io.github.Nero-Engine
Returns rows of any Apify dataset, CSV/Excel/JSON file URL or Google Sheet that pass filter...
Data Platforms Research & Data
1
https://mcp.apify.com/?tools=nerolabs/dataset-filter-transform
Google Sheets Import & Export (Ctrio Lab)
com.ctriolab
Google Sheets via Apify: write Apify datasets or JSON rows to a sheet, or read a sheet as JSON.
Workplace & Productivity Data Platforms App Automation
1
https://mcp.apify.com?tools=ctriolab/google-sheets-import-export

Related MCP Servers

DataFrame Analyst MCP
Research & Data Data Platforms Developer Tools
DiederichSolis
F
license
Not graded
quality
D
maintenance
Enables analysis of datasets from CSV/Excel files, Google Sheets, and Google Drive with comprehensive data profiling tools including schema inference, missing value reports, correlation analysis, and outlier detection. Supports exporting analytical reports in multiple formats to local storage or Google Drive.
Updated a year ago (2025-09-23 23:47 UTC)
-
datatomcp
Databases Data Platforms Workplace & Productivity
datatomcp
A
license
Not graded
quality
C
maintenance
Enables AI agents and MCP clients to query, filter, group and total CSV files and Google Sheets hosted remotely, returning exact database-computed results instead of model estimates. Datasets stay read-only and private, with OAuth sign-in and no installation required.
Updated 5 days ago (2026-11-05 20:38 UTC)
MIT
MCP Tabular Data Analysis
Databases Research & Data Data Platforms
K02D
F
license
A
quality
D
maintenance
Enables comprehensive analysis of CSV files and SQLite databases through tools for statistics, correlations, anomaly detection, pivot tables, time series analysis, visualization, and automated insights discovery.
Updated a year ago (2025-12-05 08:35 UTC)
16
-
Excel MCP Server
Data Platforms Finance Research & Data
ishayoyo
A
license
C
quality
C
maintenance
Enables conversational data analysis of Excel/CSV files through natural language queries, powered by 395 Excel functions via HyperFormula and multi-provider AI. Supports advanced analytics, bulk operations, financial modeling, and large file processing with intelligent chunking.
Updated 3 months ago (2026-08-22 17:47 UTC)
35
29 npm
38
MIT