JSON ServerBLOCK

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/[email protected]

# Install specific version globally
npm install -g @gongrzhe/[email protected]

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