MCP Server

data-transform

io.github.lazymac2x/data-transform
Data & Analytics Developer Tools Public & reachable MCP 2026-07-28

What this MCP does

Transforms and analyzes structured data through CSV, JSON, XML, filtering, sorting, flattening, field selection, and statistics tools.

csv_to_json
Parse CSV text into a JSON array of objects.
Input schema
{'type': 'object', 'required': ['csv'], 'properties': {'csv': {'type': 'string', 'description': 'CSV text to parse'}, 'delimiter': {'type': 'string', 'description': 'CSV delimiter (default: comma)'}}}
filter
Filter a JSON array by a query object. Supports >, <, ! prefixes for comparisons.
Input schema
{'type': 'object', 'required': ['data', 'query'], 'properties': {'data': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Array of objects to filter'}, 'query': {'type': 'object', 'description': 'Filter criteria (e.g. {"age":">30","status":"active"})'}}}
flatten
Flatten a nested JSON object into dot-notation keys.
Input schema
{'type': 'object', 'required': ['data'], 'properties': {'data': {'type': 'object', 'description': 'Nested object to flatten'}}}
json_to_csv
Convert a JSON array of objects to CSV text. Optionally specify a delimiter.
Input schema
{'type': 'object', 'required': ['data'], 'properties': {'data': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Array of objects to convert'}, 'delimiter': {'type': 'string', 'description': 'CSV delimiter (default: comma)'}}}
json_to_xml
Convert a JSON object or array to XML string.
Input schema
{'type': 'object', 'required': ['data'], 'properties': {'data': {'description': 'JSON data to convert to XML'}, 'rootName': {'type': 'string', 'description': 'Root element name (default: root)'}}}
pick
Pick specific fields from each object in a JSON array.
Input schema
{'type': 'object', 'required': ['data', 'fields'], 'properties': {'data': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Array of objects'}, 'fields': {'type': 'array', 'items': {'type': 'string'}, 'description': 'Field names to keep'}}}
sort
Sort a JSON array by a field.
Input schema
{'type': 'object', 'required': ['data', 'field'], 'properties': {'data': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Array of objects to sort'}, 'field': {'type': 'string', 'description': 'Field name to sort by'}, 'order': {'enum': ['asc', 'desc'], 'type': 'string', 'description': 'Sort order (default: asc)'}}}
stats
Compute statistics (count, sum, mean, min, max, median) for a numeric field.
Input schema
{'type': 'object', 'required': ['data', 'field'], 'properties': {'data': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Array of objects'}, 'field': {'type': 'string', 'description': 'Numeric field to compute stats for'}}}
unflatten
Unflatten a dot-notation JSON object back into nested structure.
Input schema
{'type': 'object', 'required': ['data'], 'properties': {'data': {'type': 'object', 'description': 'Flat dot-notation object to unflatten'}}}
validate
Validate a JSON string and return type, size, or error.
Input schema
{'type': 'object', 'required': ['data'], 'properties': {'data': {'type': 'string', 'description': 'JSON string to validate'}}}
Added
validate
Sept. 17, 2026, 12:43 p.m.
Added
stats
Sept. 17, 2026, 12:43 p.m.
Added
sort
Sept. 17, 2026, 12:43 p.m.
Added
pick
Sept. 17, 2026, 12:43 p.m.
Added
filter
Sept. 17, 2026, 12:43 p.m.
Added
unflatten
Sept. 17, 2026, 12:43 p.m.
Added
flatten
Sept. 17, 2026, 12:43 p.m.
Added
json_to_xml
Sept. 17, 2026, 12:43 p.m.
Added
csv_to_json
Sept. 17, 2026, 12:43 p.m.
Added
json_to_csv
Sept. 17, 2026, 12:43 p.m.