Skip to main content
Glama
JSON Query MCP

JSON Query MCP

by mgraczyk

JSON Query MCP

A Model Context Protocol (MCP) server for querying large JSON files. This server provides tools for working with large JSON data that can be used by LLM models implementing the Model Context Protocol.

Features

  • Query JSON files using JSONPath expressions

  • Search for keys similar to a query string

  • Search for values similar to a query string

Related MCP server: JSON MCP Server

Example

Here is an example of the Cursor Agent using the tool to read a a very large (>1M character) JSON Swagger definition, and extracting a small portion to write a typescript interface.

Example

Usage

npx json-query-mcp

Installation in Cursor

Add the following to your cursor mcp json (on macOS this is /Users/$USER/.cursor/mcp.json)

{
  "mcpServers": {
    ... other mcp servers
    "json-query": {
      "command": "npx",
      "args": [<local path to this repo>],
    },
  }
}

Development

# Run in development mode
npm run dev

# Run tests
npm test

# Format code
npm run format

# Lint code
npm run lint

# Fix lints
npm run fix

License

MIT

Available Tools

3 tools
json_query_jsonpathB

Query a JSON file using JSONPath. Use to get values precisely from large JSON files.

Inputs: file_path (required), jsonpath (required).

json_query_search_keysA

Search for keys in a JSON file. Use when you do not know the path to a key in a large JSON file, but have some idea what the key is.

Inputs: file_path (required), query (required), limit.

json_query_search_valuesA

Search for values in a JSON file. Use when you do not know the path to a value in a large JSON file, but have some idea what the value is.

Inputs: file_path (required), query (required), limit.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.7/5.0

    Scored across 3 tools

    Disambiguation5/5

    Each tool has a clearly distinct purpose: json_query_jsonpath targets precise path-based queries, json_query_search_keys focuses on key discovery, and json_query_search_values handles value discovery. There is no overlap in functionality, making it easy for an agent to select the correct tool based on the query need.

    Naming Consistency5/5

    All tool names follow a consistent verb_noun pattern with 'json_query_' as a prefix, followed by specific descriptors (jsonpath, search_keys, search_values). This uniformity enhances readability and predictability across the tool set.

    Tool Count4/5

    With 3 tools, the server is well-scoped for JSON querying, covering path-based queries, key searches, and value searches. However, it might be slightly thin if more advanced operations like filtering or transformation are expected, but it reasonably covers core query needs.

    Completeness4/5

    The tools provide comprehensive coverage for querying JSON files, including precise path queries and exploratory searches for keys and values. A minor gap exists in lacking tools for JSON manipulation (e.g., update or delete), but this is acceptable given the server's focus on querying rather than editing.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers