JSON
FreeJSON 处理服务器，支持 JSONPath 查询和多种操作。
FreeFree tier
Inputs: url
About JSON
JSON-MCP-Server is a Model Context Protocol (MCP) server that enables LLMs to query and manipulate JSON data using JSONPath syntax with extended operations. It provides a set of standardized tools for querying, filtering, transforming, aggregating, and performing string, numeric, and date operations on JSON data from URLs. The server supports array slicing, sorting, distinct values, mapping, flattening, union, intersection, string case conversion and matching, numeric math and rounding, date formatting and modification, and aggregation functions like groupBy, sum, avg, min, max. It is designed for easy integration with Claude Desktop and other MCP-compatible clients.
Key Features
Query JSON data using JSONPath syntax with extended operations
Filter JSON data with conditional expressions
Array operations: slicing, sorting, distinct, map, flatten, union, intersection
String operations: case conversion, startsWith, endsWith, contains, matches
Numeric operations: math, rounding, absolute value, square root
Date operations: format, isToday, add days/months/years
Aggregation operations: groupBy, sum, avg, min, max
Pros & Cons
Pros
- Open source under MIT license, free to use and modify
- Easy installation via npx or npm global install
- Supports a wide range of JSON operations beyond standard JSONPath
- Works seamlessly with Claude Desktop via MCP protocol
- Provides standardized tools for LLM interaction with JSON data
Cons
- Repository is archived and read-only as of March 2026, indicating no further development
- Requires a URL to a JSON source; no direct file input or local file support mentioned
- Limited to operations that can be expressed as JSONPath strings
Best For
Enabling LLMs to query and extract specific data from JSON APIsFiltering and transforming JSON datasets for analysisPerforming mathematical and date calculations on JSON fieldsAggregating JSON data for reporting or summarizationIntegrating with Claude Desktop for interactive JSON manipulation
FAQ
How do I install JSON-MCP-Server?
You can install it via npx: npx @gongrzhe/server-json-mcp@1.0.3, or install globally: npm install -g @gongrzhe/server-json-mcp@1.0.3 and then run server-json-mcp.
How do I use it with Claude Desktop?
Add the configuration to your claude_desktop_config.json: either using npx command or node path to the built index.js.
What operations are supported for arrays?
Array operations include slicing (e.g., $[0:5]), sorting (e.g., $.sort(price)), distinct, map, flatten, union, and intersection.
Can I perform date manipulations?
Yes, date operations include formatting (e.g., $.format('YYYY-MM-DD')), checking if a date is today, and adding units like days, months, or years.