JSON Tools: JavaScript Methods

Run JavaScript directly on JSON files in VS Code. Transform data with expressions, keep a searchable history, view results as JSON, table, or chart, and optionally use AI to generate queries.

Features

• Transform JSON – Use any JavaScript expression (array methods, reduce, custom logic). The active editor’s JSON is available as data.
• Persistent history – Save expressions, name snippets, search, sort, and re-run or edit them. Mark favorites and copy items to the clipboard.
• Result views – See results as JSON, Raw text, or Table. Export as JSON or CSV.
• Charts – Visualize result data as charts when the result is chartable.
• CodeMirror editor – Syntax highlighting, syntax validation, foldable result view, toggle comment, JS beautify, simple autocomplete, bracket/parenthesis support, and Ctrl+D for duplicate selection / add next occurrence.
• Templates – Use {{variableName}} in expressions (e.g. {{fileName}}, {{filePath}}, {{workspaceFolder}}). Built-in variables like {{workspaceFolder}} are available; add more via jsonQueryTools.templateVariables.
• Multiple data sources & aliases – Attach additional files as named sources and reference them via aliases alongside data in your expressions.
• AI query generator – Generate expressions with Ollama (local) or Gemini (cloud). Configure endpoint and API key in settings.
• External libraries – Load external JS libraries in the expression context when needed.
• Performance – Result is streamed in chunks for large outputs.
• Notifications – Toast notification when the result is undefined.
• Export/import scripts – Export and import JavaScript expressions for reuse.

Quick start

1. Open a JSON file (or any file you treat as data).
2. Run JSON Tools: Open Query Editor (jsonQueryTools.openHistory).
3. In the script editor, write a JS expression using data, e.g. data.items.filter(x => x.active).
4. Run it and view the result in JSON, Raw, or Table; optionally export as JSON/CSV or view as a chart.

Configuration

Setting	Description
jsonQueryTools.ollamaEndpoint	Ollama API URL (default: http://localhost:11434)
jsonQueryTools.aiProvider	ollama or gemini
jsonQueryTools.aiApiKey	API key for cloud AI (e.g. Gemini)
jsonQueryTools.templateVariables	Custom key-value pairs for {{variableName}} in expressions

Demo

Contributing

Contributions are welcome. Open a PR for changes or an Issue for bugs and feature requests.

Buy me a coffee