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

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

MIT