JSON Manipulation
About
Provides a JSON manipulation interface using JSONPath syntax for querying, transforming, and analyzing structured data across diverse datasets.
Details
- Author
- gongrzhe
- Repository
- GongRzhe/JSON-MCP-Server
- GitHub stars
- 32
- Downloads
- 3,537
- License
- MIT License
- Categories
- AI, Design, Developer Tools, Search, Frontend, Infrastructure
Jump to
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
JSON ManipulationCommand (node, npx, python, etc.)npxArguments-
Argument 1
@gongrzhe/server-json-mcp@1.0.3
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
Argument 1
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
npm install -g @gongrzhe/server-json-mcp@1.0.3
server-json-mcp
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"
]
}
}
query
Query JSON data using JSONPath syntax with extended operations. Input: url (string): URL of the JSON data source, jsonPath (string): JSONPath expression with optional operations.
filter
Filter JSON data using conditions. Input: url (string): URL of the JSON data source, jsonPath (string): Base JSONPath expression, condition (string): Filter condition.
- query
- Query JSON data using JSONPath syntax with extended operations
- Input:
- url (string): URL of the JSON data source
- jsonPath (string): JSONPath expression with optional operations
- filter
- Filter JSON data using conditions
- Input:
- url (string): URL of the JSON data source
- jsonPath (string): Base JSONPath expression
- condition (string): Filter condition
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"json manipulation": {
"env": {},
"args": [
"@gongrzhe/server-json-mcp@1.0.3"
],
"shell": false,
"command": "npx"
}
}
}Linux
{
"env": [],
"args": [
"@gongrzhe/server-json-mcp@1.0.3"
],
"shell": false,
"command": "npx"
}Macos
{
"env": [],
"args": [
"@gongrzhe/server-json-mcp@1.0.3"
],
"shell": false,
"command": "npx"
}Windows
{
"env": [],
"args": [
"/c",
"npx",
"@gongrzhe/server-json-mcp@1.0.3"
],
"shell": true,
"command": "cmd"
}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.
<a href="https://glama.ai/mcp/servers/9g137c4b4k">
</a>
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-mcp
Components
Tools
- query
- Query JSON data using JSONPath syntax with extended operations
- Input:
- url (string): URL of the JSON data source
- jsonPath (string): JSONPath expression with optional operations
- filter
- Filter JSON data using conditions
- Input:
- url (string): URL of the JSON data source
- jsonPath (string): Base JSONPath expression
- condition (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
1. Clone the repository
2. Install dependencies:
npm install
3. Build the project:
npm run build
Notes
1. All JSONPath expressions start with $ representing the root object
2. Array indices are zero-based
3. String values in operations should be wrapped in quotes
4. Date operations support 'days', 'months', and 'years' units
5. Numeric operations support basic arithmetic operators (+, -, *, /)
License
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
