JSON

JSON

JSON MCP server for querying and manipulating JSON data via JSONPath-based tools.

81
Stars
20
Forks
0
Releases

Overview

This JSON MCP server implements a JSON Model Context Protocol (MCP) server for querying and manipulating JSON data. It exposes two tools: query and filter. The query tool accepts url and jsonPath, while the filter tool accepts url, jsonPath, and condition. The server uses JSONPath expressions augmented with a broad set of operations across arrays, strings, numbers, dates, and aggregations. Supported operations include array slicing, sorting, distinct, map, flatten, union, and intersection; string case conversion, prefix/suffix tests, contains and matches; numeric math, rounding, absolute values, and common functions like abs() and sqrt(); date formatting, isToday checks, and adding time units such as days, months, and years. Aggregation supports groupBy and calculations like sum, avg, min, and max. The README documents input shapes, usage patterns, and notes (e.g., JSONPath expressions start with $, array indices are zero-based, and string literals must be quoted). It also provides configuration guidance for Claude Desktop and direct node usage, plus development steps to build from source. This server is designed for MCP workflows, enabling LLMs to reason over JSON data through standardized tools.

Details

Owner
GongRzhe
Language
JavaScript
License
MIT License
Updated
2025-12-07

Features

Query tool

Query JSON data using JSONPath syntax with extended operations.

Filter tool

Filter JSON data using conditions.

Array operations

Supports slicing, sorting, distinct, map, flatten, union, and intersection on arrays.

String operations

Includes toLowerCase, toUpperCase, startsWith, endsWith, contains, and matches.

Numeric operations

Supports arithmetic operators (+, -, *, /) and functions like abs() and sqrt(), plus rounding.

Date operations

Format, isToday, and add time units (days, months, years).

Aggregation operations

GroupBy and calculations like sum, avg, min, max.

Easy installation and usage

Install and run via npm/npx commands; includes Claude Desktop configuration guidance.

Audience

LLMsEnable LLMs to query and transform JSON data via JSONPath-based tools.
DevelopersIntegrate the MCP server into applications to provide JSON data querying/manipulation capabilities.
Data scientistsUse in MCP workflows to process and transform JSON datasets.

Tags

JSONMCPserverJSONPathqueryfilterarray-operationsstring-operationsnumeric-operationsdate-operationsaggregationClaude DesktopLLMNode.jsnpm