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
bash# 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-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])
- Map:
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{ "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{ "json": { "command": "node", "args": [ "path/to/build/index.js" ] } }
Development
Building from Source
- Clone the repository
- Install dependencies:
bash
npm install - Build the project:
bash
npm run build
Notes
- All JSONPath expressions start with
$representing the root object - Array 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
