JSON Manipulation
Query and manipulate JSON data from URLs using JSONPath expressions. Provides filtering, sorting, and transformation capabilities for structured data analysis.
Provides a JSON manipulation interface using JSONPath syntax for querying, transforming, and analyzing structured data across diverse datasets.
What it does
- Query JSON data using JSONPath syntax
- Filter JSON datasets with custom conditions
- Sort and slice array data
- Transform data with map, flatten, and grouping operations
- Perform string and numeric operations on JSON fields
- Calculate aggregations like sum and statistics
Best for
About JSON Manipulation
JSON Manipulation is a community-built MCP server published by gongrzhe that provides AI assistants with tools and capabilities via the Model Context Protocol. Manipulate and analyze JSON data with JSON Manipulation using JSONPath syntax. Query arrays and explore JSONPath example It is categorized under databases, analytics data. This server exposes 2 tools that AI clients can invoke during conversations and coding sessions.
How to install
You can install JSON Manipulation in your AI client of choice. Use the install panel on this page to get one-click setup for Cursor, Claude Desktop, VS Code, and other MCP-compatible clients. This server runs locally on your machine via the stdio transport.
License
JSON Manipulation is released under the MIT license. This is a permissive open-source license, meaning you can freely use, modify, and distribute the software.
Tools (2)
Query JSON data using JSONPath syntax
Filter JSON data using conditions
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-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": {
"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 install - Build the project:
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
Alternatives
Related Skills
Browse all skillsRead, write, edit, and format Excel files (.xlsx). Create spreadsheets, manipulate data, apply formatting, manage sheets, merge cells, find/replace, and export to CSV/JSON/Markdown. Use for any Excel file manipulation task.
Parse SQLite databases into structured JSON data. Use when exploring unknown database schemas, understanding table relationships, and extracting map data as JSON.
Python library for working with geospatial vector data including shapefiles, GeoJSON, and GeoPackage files. Use when working with geographic data for spatial analysis, geometric operations, coordinate transformations, spatial joins, overlay operations, choropleth mapping, or any task involving reading/writing/analyzing vector geographic data. Supports PostGIS databases, interactive maps, and integration with matplotlib/folium/cartopy. Use for tasks like buffer analysis, spatial joins between datasets, dissolving boundaries, clipping data, calculating areas/distances, reprojecting coordinate systems, creating maps, or converting between spatial file formats.
Create new scientific tools for ToolUniverse framework with proper structure, validation, and testing. Use when users need to add tools to ToolUniverse, implement new API integrations, create tool wrappers for scientific databases/services, expand ToolUniverse capabilities, or follow ToolUniverse contribution guidelines. Supports creating tool classes, JSON configurations, validation, error handling, and test examples.
Analyze git repositories to build a security ownership topology (people-to-file), compute bus factor and sensitive-code ownership, and export CSV/JSON for graph databases and visualization. Trigger only when the user explicitly wants a security-oriented ownership or bus-factor analysis grounded in git history (for example: orphaned sensitive code, security maintainers, CODEOWNERS reality checks for risk, sensitive hotspots, or ownership clusters). Do not trigger for general maintainer lists or non-security ownership questions.
Conduct comprehensive, systematic literature reviews using multiple academic databases (PubMed, arXiv, bioRxiv, Semantic Scholar, etc.). This skill should be used when conducting systematic literature reviews, meta-analyses, research synthesis, or comprehensive literature searches across biomedical, scientific, and technical domains. Creates professionally formatted markdown documents and PDFs with verified citations in multiple citation styles (APA, Nature, Vancouver, etc.).