JSON

What is JSON-MCP-Server?

JSON-MCP-Server is a JSON Model Context Protocol (MCP) server implementation designed for querying and manipulating JSON data. It enables Large Language Models (LLMs) to interact with JSON data through a set of standardized tools, providing advanced query capabilities using JSONPath syntax and supporting various operations on arrays, strings, numbers, and dates.

How to use JSON-MCP-Server?

JSON-MCP-Server can be used by installing it globally via npm or by using npx for specific versions. Once installed, it can be run from the command line. For integration with Claude Desktop, specific configurations can be added to claude_desktop_config.json to define the command and arguments for running the server.

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

Configuration with Claude Desktop:

{
  "json": {
    "command": "npx",
    "args": [
      "@gongrzhe/server-json-mcp@1.0.3"
    ]
  }
}

Key Features of JSON-MCP-Server

JSON-MCP-Server provides powerful tools for JSON data manipulation:

• Query Tool: Query JSON data using JSONPath syntax with extended operations. Supports specifying a URL for the JSON data source and a JSONPath expression.
• Filter Tool: Filter JSON data based on conditions. Requires a URL, a base JSONPath expression, and a filter condition.
• Supported Operations:
  • Array Operations: Slicing ($[0:5]), Sorting ($.sort(price)), Distinct ($.distinct()), Transformations (Map, Flatten, Union, Intersection).
  • String Operations: Case conversion ($.toLowerCase()), Tests ($.startsWith('test')), Search ($.contains('test')).
  • Numeric Operations: Math ($.math(+10)), Rounding ($.round()), Functions ($.abs()).
  • Date Operations: Format ($.format('YYYY-MM-DD')), Check ($.isToday()), Modify ($.add(1, 'days')).
  • Aggregation Operations: Grouping ($.groupBy(category)), Statistical calculations (Sum, Avg, Min, Max).

Use Cases of JSON-MCP-Server

• LLM Integration: Enables LLMs to programmatically interact with and process JSON data, facilitating data-driven responses and actions.
• Data Extraction and Transformation: Efficiently extract specific data points from complex JSON structures and transform them as needed for various applications.
• Data Analysis: Perform filtering, sorting, and aggregation on JSON datasets for analytical purposes.
• Automation: Automate tasks involving JSON data manipulation in workflows.

FAQ about JSON-MCP-Server

• Q: What do JSONPath expressions start with?
  • A: All JSONPath expressions start with $ representing the root object.
• Q: Are array indices zero-based?
  • A: Yes, array indices are zero-based.
• Q: How should string values in operations be handled?
  • A: String values in operations should be wrapped in quotes.
• Q: What units are supported for date operations?
  • A: Date operations support 'days', 'months', and 'years' units.
• Q: What basic arithmetic operators are supported for numeric operations?
  • A: Numeric operations support basic arithmetic operators (+, -, *, /).

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