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
Components
Tools
- query
- filter
Supported Operations
Array Operations
- Slicing:
$[0:5],$[-3:],$[1:4]
- Sorting:
$.sort(price),$.sort(-price)
- Distinct:
$.distinct()
- Transformations:
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:Alternatively, you can use the node command directly if you have the package installed:
Development
Building from Source
- Clone the repository
- Install dependencies:
- Build the project:
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
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
Components
Tools
- query
- filter
Supported Operations
Array Operations
- Slicing:
$[0:5],$[-3:],$[1:4]
- Sorting:
$.sort(price),$.sort(-price)
- Distinct:
$.distinct()
- Transformations:
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:Alternatively, you can use the node command directly if you have the package installed:
Development
Building from Source
- Clone the repository
- Install dependencies:
- Build the project:
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