databasesanalytics-data

JSON Manipulation▌

by gongrzhe

Manipulate and analyze JSON data with JSON Manipulation using JSONPath syntax. Query arrays and explore JSONPath example

Provides a JSON manipulation interface using JSONPath syntax for querying, transforming, and analyzing structured data across diverse datasets.

github stars

★ 89

GitHub npm

Extended JSONPath with 20+ operationsWorks with remote JSON URLs

best for

/ Data analysts working with JSON APIs
/ Developers processing structured data feeds
/ Automating data extraction and transformation tasks

capabilities

/ 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

what it does

Query and manipulate JSON data from URLs using JSONPath expressions. Provides filtering, sorting, and transformation capabilities for structured data analysis.

about

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

MIT

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.

readme

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 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

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