JSON MCP Server
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@JSON MCP Server query https://dummyjson.com/products and return average price by category"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
JSON MCP Server (@gongrzhe/server-json-mcp@1.0.3)
A JSON Model Context Protocol (MCP) server implementation for querying and manipulating JSON data. This server enables LLMs to interact with JSON data through a set of standardized tools.
Installation & Usage
# Using npx with specific version (recommended)
npx @gongrzhe/server-json-mcp@1.0.3
# Install specific version globally
npm install -g @gongrzhe/server-json-mcp@1.0.3
# Run after global installation
server-json-mcpRelated MCP server: Fetch JSONPath MCP
Components
Tools
query
Query JSON data using JSONPath syntax with extended operations
Input:
url(string): URL of the JSON data sourcejsonPath(string): JSONPath expression with optional operations
filter
Filter JSON data using conditions
Input:
url(string): URL of the JSON data sourcejsonPath(string): Base JSONPath expressioncondition(string): Filter condition
Supported Operations
Array Operations
Slicing:
$[0:5],$[-3:],$[1:4]Sorting:
$.sort(price),$.sort(-price)Distinct:
$.distinct()Transformations:
Map:
$.map(fieldName)Flatten:
$.flatten()Union:
$.union([1,2,3])Intersection:
$.intersection([1,2,3])
String Operations
Case:
$.toLowerCase(),$.toUpperCase()Tests:
$.startsWith('test'),$.endsWith('test')Search:
$.contains('test'),$.matches('pattern')
Numeric Operations
Math:
$.math(+10),$.pow2()Rounding:
$.round(),$.floor(),$.ceil()Functions:
$.abs(),$.sqrt()
Date Operations
Format:
$.format('YYYY-MM-DD')Check:
$.isToday()Modify:
$.add(1, 'days')
Aggregation Operations
Group:
$.groupBy(category)Stats:
$.sum(price),$.avg(price),$.min(price),$.max(price)
Configuration
Usage with Claude Desktop
To use this server with the Claude Desktop app, add the following configuration to your claude_desktop_config.json:
{
"json": {
"command": "npx",
"args": [
"@gongrzhe/server-json-mcp@1.0.3"
]
}
}Alternatively, you can use the node command directly if you have the package installed:
{
"json": {
"command": "node",
"args": [
"path/to/build/index.js"
]
}
}Development
Building from Source
Clone the repository
Install dependencies:
npm installBuild the project:
npm run build
Notes
All JSONPath expressions start with
$representing the root objectArray indices are zero-based
String values in operations should be wrapped in quotes
Date operations support 'days', 'months', and 'years' units
Numeric operations support basic arithmetic operators (+, -, *, /)
License
MIT
Available Tools
2 toolsTool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 2 tools
Both tools operate on JSON data to extract subsets, and 'filter' is essentially a restricted form of JSONPath querying, so an agent could reasonably pick either for a filtering need. The descriptions do differentiate them by mechanism (JSONPath syntax vs. conditions), which helps, but the boundary is fuzzy.
Both names are single lowercase verbs (query, filter) following the exact same convention. There is no mixing of styles or verb forms.
Two tools is thin for a server whose domain (JSON manipulation) typically involves parsing, validation, transformation, and mutation. It is defensible for a narrowly scoped read-only query server, but borderline.
The surface offers only read/extract operations; there is no parsing, validation, path construction, or any modification of JSON (set/merge/delete). Agents needing to inspect or transform JSON beyond querying and filtering will hit dead ends.
Maintenance
Related MCP Connectors
Exactly 50 data transformation and live web verification tools for AI agents.
Turn any public webpage into JSON with AI, save it as a live JSON API, and call it from your agent.
Verified websites as JSON commands for AI agents over plain curl or MCP.
500+ deterministic tools for AI agents: math, conversion, validation, hashing, encoding, date/time.
Related MCP Servers
- AlicenseCqualityFmaintenanceA Model Context Protocol server implementation that enables LLMs to query and manipulate JSON data using JSONPath syntax with extended operations for filtering, sorting, transforming, and aggregating data.290MIT
- AlicenseAqualityBmaintenanceEnables efficient extraction of specific data from JSON APIs using JSONPath patterns, reducing token usage by up to 99% compared to fetching entire responses. Supports single and batch operations for both JSON extraction and raw text retrieval from URLs.44MIT
- AlicenseBqualityBmaintenanceEnables natural language interaction with JSON files, providing tools to load, query, aggregate, transform, and export data directly from AI editors.2684 PyPI3MIT
- AlicenseNot gradedqualityCmaintenanceProvides tools to validate, format, and query JSON strings via MCP. Enables AI agents to work with JSON data without needing keys or internet.70 npmMIT