JSON MCP Server
A Model Context Protocol server implementation that enables LLMs to query and manipulate JSON data using JSONPath syntax with extended operations for filtering, sorting, transforming, and aggregating data.
What is JSON MCP Server?
JSON MCP Server is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to model context protocol server implementation that enables llms to query and manipulate json data using jsonpath syntax with extended operations for filtering, sorting, transforming, and aggregating da...
A Model Context Protocol server implementation that enables LLMs to query and manipulate JSON data using JSONPath syntax with extended operations for filtering, sorting, transforming, and aggregating data.
This server falls under the Search & Data Extraction category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- A Model Context Protocol server implementation that enables
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx json-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use JSON MCP Server
JSON MCP Server is a Model Context Protocol server that enables AI assistants to query, filter, transform, and aggregate JSON data from any URL using JSONPath syntax and extended operations. It exposes two primary tools — query and filter — that support array slicing, sorting, grouping, string matching, date operations, and mathematical aggregation on remote JSON datasets. Developers and data analysts use it to let their AI assistant work with live JSON APIs or large data files without manual parsing or preprocessing.
Prerequisites
- Node.js 18+ installed
- npx available (comes with Node.js)
- A remote JSON URL or API endpoint to query
- An MCP-compatible client such as Claude Desktop, Cursor, or Windsurf
Install or run the JSON MCP Server via npx
The server can be run directly with npx without a global install. Use the versioned package name for stability.
npx @gongrzhe/[email protected]Add the server to your MCP client configuration
Register the JSON MCP Server in your MCP client config file (e.g. claude_desktop_config.json).
{
"mcpServers": {
"json": {
"command": "npx",
"args": ["@gongrzhe/[email protected]"]
}
}
}Restart your MCP client
Restart Claude Desktop or your chosen MCP client to load the JSON MCP Server. The query and filter tools will appear automatically.
Query JSON data using JSONPath
Use the query tool by providing a URL pointing to a JSON resource and a JSONPath expression. Extended operations like $.sort(field), $.groupBy(field), and $.map(field) are supported beyond standard JSONPath.
Filter JSON data with conditions
Use the filter tool to narrow down JSON array results with conditions such as price > 100, status == 'active', or name.contains('widget'). Combine with JSONPath to target nested fields.
JSON MCP Server Examples
Client configuration
Example claude_desktop_config.json for the JSON MCP Server.
{
"mcpServers": {
"json": {
"command": "npx",
"args": ["@gongrzhe/[email protected]"]
}
}
}Prompts to try
Example prompts using the query and filter tools with a public JSON API.
- "Query https://jsonplaceholder.typicode.com/posts with JSONPath $[0:5] to get the first 5 posts"
- "Sort the posts from https://jsonplaceholder.typicode.com/posts by userId using $.sort(userId)"
- "Filter https://jsonplaceholder.typicode.com/users where address.city contains 'ville'"
- "Group products from [your API URL] by category using $.groupBy(category)"
- "Get all unique user IDs from https://jsonplaceholder.typicode.com/posts using $.map(userId) then apply distinct"Troubleshooting JSON MCP Server
JSONPath query returns empty results
Verify the JSONPath expression against the actual JSON structure. Use $ to target the root, $.field for object keys, and $[*].field for array elements. Tools like jsonpath.com can help you test expressions before using them in prompts.
npx fails to fetch or install the package
Ensure you are using the exact versioned package name: @gongrzhe/[email protected]. Check your npm registry access and internet connection. If behind a corporate proxy, set the HTTP_PROXY environment variable.
URL fetch errors when querying remote JSON
The URL must be publicly accessible and return valid JSON. HTTPS URLs are preferred. If the endpoint requires authentication or returns non-JSON content types, the tool will not be able to parse the response.
Frequently Asked Questions about JSON MCP Server
What is JSON MCP Server?
JSON MCP Server is a Model Context Protocol (MCP) server that model context protocol server implementation that enables llms to query and manipulate json data using jsonpath syntax with extended operations for filtering, sorting, transforming, and aggregating data. It connects AI assistants to external tools and data sources through a standardized interface.
How do I install JSON MCP Server?
Follow the installation instructions on the JSON MCP Server GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with JSON MCP Server?
JSON MCP Server works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is JSON MCP Server free to use?
Yes, JSON MCP Server is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
JSON MCP Server Alternatives — Similar Search & Data Extraction Servers
Looking for alternatives to JSON MCP Server? Here are other popular search & data extraction servers you can use with Claude, Cursor, and VS Code.
TrendRadar
★ 58.0kA real-time hotspot monitoring and news aggregation assistant that provides AI-powered analysis of trending topics across multiple platforms via the Model Context Protocol. It enables users to track news and receive automated notifications through va
Scrapling
★ 52.7k🕷️ An adaptive Web Scraping framework that handles everything from a single request to a full-scale crawl!
PDF Math Translate
★ 33.9k[EMNLP 2025 Demo] PDF scientific paper translation with preserved formats - 基于 AI 完整保留排版的 PDF 文档全文双语翻译，支持 Google/DeepL/Ollama/OpenAI 等服务，提供 CLI/GUI/MCP/Docker/Zotero
GPT Researcher
★ 27.2kAn autonomous agent that conducts deep research on any data using any LLM providers
Agent Reach
★ 20.1kGive your AI agent eyes to see the entire internet. Read & search Twitter, Reddit, YouTube, GitHub, Bilibili, XiaoHongShu — one CLI, zero API fees.
Xiaohongshu
★ 13.7kMCP for xiaohongshu.com
Browse More Search & Data Extraction MCP Servers
Explore all search & data extraction servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up JSON MCP Server in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use JSON MCP Server?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.