Json Mcp Server

What is Json Mcp Server about?

Json Mcp Server offers a standardized MCP interface for querying and manipulating JSON documents. It supports rich JSONPath syntax with additional array, string, numeric, date, and aggregation operations, allowing language models to work with structured data without custom code.

How to use Json Mcp Server?

1. Installation – run the server with npx:

   npx @gongrzhe/server-json-mcp@1.0.3
   

   Or install globally (npm install -g @gongrzhe/server-json-mcp@1.0.3) and start it with server-json-mcp.
2. Integration – configure your LLM client (e.g., Claude Desktop) to invoke the json tool, pointing to the server command.
3. Tool usage – call the query or filter tools, providing a url to the JSON source and a jsonPath expression (optionally with a condition for filtering).

Key features of Json Mcp Server

• Extended JSONPath with slicing, sorting, distinct, map, flatten, union, intersection, etc.
• String utilities such as case conversion, starts/ends with, contains, regex match.
• Numeric functions including arithmetic, rounding, absolute, sqrt, power.
• Date handling for formatting, checking today, and adding time units.
• Aggregation: groupBy, sum, avg, min, max.
• Two built‑in tools – query for general JSONPath queries and filter for condition‑based extraction.
• Easy installation via npx and straightforward configuration for Claude Desktop or custom clients.

Use cases of Json Mcp Server

• LLM‑driven data extraction: Retrieve specific fields from large JSON APIs without writing parsing code.
• Report generation: Compute aggregates (sum, average) and group data directly in the server.
• Data transformation pipelines: Apply map, flatten, and union operations to restructure JSON before further processing.
• Chatbot assistants: Enable conversational agents to answer questions about JSON datasets by issuing queries on‑the‑fly.
• Rapid prototyping: Experiment with complex JSONPath expressions via a simple HTTP‑based MCP endpoint.

FAQ from the Json Mcp Server

• Q: Do I need to run a separate HTTP server? A: The package launches an MCP server process that listens on a default port; no additional setup is required.
• Q: Can I use the server offline? A: Yes, as long as the JSON source URLs are reachable (local files or network resources).
• Q: How are authentication tokens handled? A: If your JSON source requires headers, pass them through environment variables or extend the server code; the base package does not include built‑in auth.
• Q: Is the server compatible with other LLM platforms? A: The MCP protocol is generic; any client that can call external tools (e.g., OpenAI function calling, Claude tools) can integrate with it.
• Q: What version of Node.js is required? A: Node 14+ is recommended.

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