Gongrzhe JSON MCP Server

🚀 JSON Model Context Protocol (MCP) Server (@gongrzhe/server-json-mcp@1.0.3)

This is an implementation of a JSON Model Context Protocol (MCP) server for querying and manipulating JSON data. It enables Large Language Models (LLMs) to interact with JSON data through a set of standardized tools.

🚀 Quick Start

📦 Installation

# Use a specific version of npx (recommended)
npx @gongrzhe/server-json-mcp@1.0.3

# Install a specific version globally
npm install -g @gongrzhe/server-json-mcp@1.0.3

# Run after global installation
server-json-mcp

✨ Features

💻 Components - Tools

• query

  • Query JSON data using JSONPath syntax, supporting extended operations.
  • Input:
    • url (string): The URL of the JSON data source.
    • jsonPath (string): A JSONPath expression with optional operations.

• filter

  • Filter JSON data based on conditions.
  • Input:
    • url (string): The URL of the JSON data source.
    • jsonPath (string): A basic JSONPath expression.
    • condition (string): The filtering condition.

🛠️ Supported Operations

Array Operations

• Slicing: $[0:5], $[-3:], $[1:4]
• Sorting: $.sort(price), $.sort(-price)
• Deduplication: $.distinct()
• Transformation:
  • Mapping: $.map(fieldName)
  • Flattening: $.flatten()
  • Union: $.union([1,2,3])
  • Intersection: $.intersection([1,2,3])

String Operations

• Case Conversion: $.toLowerCase(), $.toUpperCase()
• Testing: $.startsWith('test'), $.endsWith('test')
• Searching: $.contains('test'), $.matches('pattern')

Numerical Operations

• Mathematical Calculations: $.math(+10), $.pow2()
• Rounding: $.round(), $.floor(), $.ceil()
• Functions: $.abs(), $.sqrt()

Date Operations

• Formatting: $.format('YYYY-MM-DD')
• Checking: $.isToday()
• Modification: $.add(1, 'days')

Aggregation Operations

• Grouping: $.groupBy(category)
• Statistics: $.sum(price), $.avg(price), $.min(price), $.max(price)