JSON MCP Server
by GongRzhe
Query and filter JSON data with JSONPath and advanced operations
data Node.js Beginner Self-hostable No API key
⭐ 87 stars 📅 Updated: 1y ago
Description
An MCP server for JSON handling and processing. Provides 2 tools — query and filter — that operate on remote JSON data via URL using JSONPath syntax. Supports rich operations including array manipulation (slicing, sorting, distinct, flattening, union, intersection), string operations (case conversion, pattern matching), numeric operations (arithmetic, rounding), date operations (formatting, date arithmetic), and aggregation (grouping, sum, average, min/max).
✅ Best for
AI assistants that need to query and analyze remote JSON APIs with advanced filtering
⏭️ Skip if
You only need to read local JSON files or prefer a GraphQL-based approach
💡 Use cases
- Querying remote JSON APIs with JSONPath expressions
- Filtering and transforming JSON datasets with complex conditions
- Aggregating JSON data for reports (sum, average, group by)
- Performing date arithmetic and formatting on JSON date fields
- Array operations like sorting, deduplication, and intersection
👍 Pros
- ✓ Rich operation set beyond basic JSONPath (array, string, numeric, date, aggregation)
- ✓ No API key required — works with any public JSON URL
- ✓ Simple 2-tool interface with powerful underlying capabilities
- ✓ Lightweight Node.js package
👎 Cons
- ✗ Only fetches JSON from URLs — cannot process local files
- ✗ Two generic tools may be less discoverable than named operations
- ✗ No caching of fetched JSON data
🔧 Exposed tools (2 tools)
| Tool | Category | Description |
|---|---|---|
| query | data-query | Query JSON data using JSONPath syntax with extended operations |
| filter | data-query | Filter JSON data using conditions with flexible predicate support |
💡 Tips & tricks
Use the query tool with JSONPath extended operations for complex transformations. The filter tool accepts conditions for row-level filtering on arrays.
Quick info
- Author
- GongRzhe
- License
- MIT
- Runtime
- Node.js 18+
- Transport
- stdio
- Category
- data
- Difficulty
- Beginner
- Self-hostable
- ✅
- Auth
- —
- Docker
- —
- Version
- 1.0.3
- Updated
- Mar 13, 2025
Client compatibility
- ❓ Claude Code
- ❓ Cursor
- ❓ VS Code Copilot
- ❓ Gemini CLI
- ❓ Windsurf
- ❓ Cline
- ❓ JetBrains AI
- ❓ Warp
Platforms
🍎 macOS 🐧 Linux 🪟 Windows