A
licenseNot graded
qualityB
maintenanceEnables AI agents to query Excel, CSV, Parquet, and NDJSON files as SQL tables, joining data across formats and sheets and exporting results to CSV or Excel.
1
Apache 2.0
Dataset Join & Merge (VLOOKUP for Datasets)
Server Details
Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields...
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
- 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
Join two lists of JSON rows on a key, like SQL or VLOOKUP: left, inner, full, anti joins, union.
Returns what was added, removed or changed between two Apify datasets, files, Google Sheets or...
Merge many Apify datasets, CSV files and Google Sheets into one list with duplicates removed.
Merge Apify datasets and remove duplicates by any fields, keeping the first or the newest copy.
Related MCP Servers
- AlicenseAqualityBmaintenanceEnables extraction of structured item lists from public web pages using the user's own OpenAI, Anthropic, Gemini, or Groq key through an Apify actor, returning one row per item with validation flags.1MIT
- AlicenseNot gradedqualityCmaintenanceEnables 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.MIT
- AlicenseAqualityBmaintenanceLets an agent query JSON files too large for its context: JSONPath with aggregation pipes, schema, field profiles, samples, identity-keyed diff, CSV and spreadsheet export, and checks that gate a file. Int64 IDs and decimals keep their exact digits, and zstd, Base64-Zstd and PostgreSQL bytea payloads open directly.412238 npm2MIT
Try in Browser
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd
Glama MCP Gateway
Add one secure layer between your agents and this server.