JSON Tools for AI Developers · Runs locally

For AI developers JSON Workbench

Natural language generation · Schema · Zod · OpenAPI · Function Calling · MCP · 30+ tools

JSONPath query

The API doc says $.data.list[*].id, and hunting through the response by hand is slow. A path pulls matching nodes in one shot.

Paste JSON on the left, write $.users[*].name in the path box, click Query.

Common dots, indexes, and wildcards are covered. If a filter looks wrong, fix the path against Tree view.

The query runs locally. Responses with personal data don't need to be redacted first.

Get the root right first

Some responses wrap in data or result. Miss one level and you get empty. Use Tree view when you are unsure, then write the path.

Be careful with wildcards

$.users[*].name pulls every name. Use [0] for the first only. If a filter is wrong, widen first, then tighten.

How to use it

  1. Paste JSON data.
  2. Write a JSONPath, for example $.users[*].name.
  3. Click Query and read the match list.
  4. If it's empty, fix the path against Tree view. Don't assume the field is missing.
  5. Once it's stable, put the expression in a test or script. Use NL Query for ad-hoc questions.

When to use it

  • Pull every id from a list for reconciliation.
  • Take one deeply nested error code.
  • Show a teammate what a path in the docs actually hits.
  • Format the query result and use it as a new fixture.

Keep in mind

  • The implementation covers common syntax, not every dialect.
  • Queries are read-only.
  • Data is not uploaded.

FAQ

Which syntax is supported?

Dot access, array indexes, * wildcards, and common filters. Rare implementation details follow this page's result.

Why didn't it find anything?

Wrong path, different field-name case, or the value is an object instead of an array. Confirm in Tree view first.

When should I use NL Query instead?

Use this page if you already write paths. Use NL Query if you want natural language first.

Is the data uploaded?

No.

Is $ required?

It means the root. Most expressions are less ambiguous if they start with $.

Can I change matched values?

No. Copy the result and edit it yourself.

Are filters supported?

Common comparisons, yes. Split especially complex predicates into two steps or use a script.

Is result order stable?

It follows traversal order. Don't treat this as a sort tool.