jq-mcp-server

berrydev-ai/jq-mcp-server

3.2

If you are the rightful owner of jq-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Python MCP server that wraps jq queries over large JSON files, providing tools for JSON querying and JSON Schema retrieval.

Tools

  1. query_json

    Run jq query on a JSON file

  2. get_jsonschema

    Retrieve a JSON Schema file to assist LLM reasoning

Orca MCP Setup Guide for Windows

Overview

This guide walks you through setting up Claude Desktop to work with Orca data using the jq MCP server for JSON querying.

Prerequisites

Before starting, install these required components:

1. Claude Desktop

  • Download from claude.ai
  • Install and set up your account

2. Install VS Code

Only needed if you plan to modify code or prefer using VS Code for file editing.

winget install -e --id Microsoft.VisualStudioCode

3. Install jq

jq is the library that will be used to parse and query the JSON file

winget install --id jqlang.jq

Download the latest orca.json

Step 1: Set Up Data Directory

mkdir C:\Data
cd C:\Data

Step 2. Prepare JSON File for editing within VS Code

code orca.json

This opens VS Code with a new orca.json file in the Data folder

Step 3: Download Orca Data from orca

  1. Go to the Orca Project Report in your browser (ask Paul)

  2. Configure Export Settings - Ensure all checkboxes are checked:

    • ✅ Strip nulls
    • ✅ Skip soft deleted rows
    • ✅ Strip time information

  3. Copy JSON Data

    • Click in the JSON section
    • Press Ctrl + A to select all
    • Press Ctrl + C to copy
    • Paste into VS Code orca.json file
    • Save the file

  4. Get File Path

    • Right-click on orca.json in VS Code file tree
    • Select "Copy full path"
    • Path should be: C:\Data\orca.json

Install Claude Desktop Extensions

Claude Desktop Extensions are a brand new feature which allows the installation and configuration of MCP servers to be done easily via dragging/dropping a pre-packaged MCP server into Claude's settings.

Step 1. Install Filesystem Extension

  1. Open Claude Desktop → hamburger menu
  2. Go to File → Settings (or Ctrl + ,)
  3. Select Extensions tab
  4. Install the Filesystem extension
  5. Add C:\Data as an allowed directory

Step 2. Install jq MCP Extension

  1. Download the extension file: jq-mcp-server.dxt
  2. Verify the file is in your Downloads folder
  3. Return to Claude Desktop Settings → Extensions
  4. Drag and drop the jq-mcp-server.dxt file into the Extensions window
  5. Confirm it's enabled and close settings

Chat with Claude about Orca

Chatting with Claude regarding the orca schema requires a simple prompt to initiate the conversation:

Using the `jq` tool only, please give me information on the file `C:\Data\orca.json`.
Note that this file is 20+ MB.