JSON-MCP-Server

# 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. <a href="https://glama.ai/mcp/servers/9g137c4b4k"> <img width="380" height="200" src="https://glama.ai/mcp/servers/9g137c4b4k/badge" alt="JSON Server MCP server" /> </a> ## Installation & Usage ```bash # 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 { "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 { "json": { "command": "node", "args": [ "path/to/build/index.js" ] } } ``` ## Development ### Building from Source 1. Clone the repository 2. Install dependencies: ```bash npm install ``` 3. Build the project: ```bash 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