Skip to main content

jq Playground

Test jq expressions against JSON data in real time. Explore common snippets, build filters, and copy the ready-to-use command for your terminal.

⚠ This playground simulates common jq operations in JavaScript. For full jq spec, run jq locally. Install jq →

Press Ctrl+Enter to run

Run a filter to see output

Terminal command:

echo '...' | jq '.'

Common Snippets

Quick Reference

. Identity — pretty-print whole input
.key Get object field
.key.nested Get nested field
.key? Optional field (no error if missing)
.[] Iterate array or object values
.[0] First array element
.[-1] Last array element
.[2:5] Array slice (index 2–4)
keys Get object keys as array
values Get object values as array
length Length of array/string/object
type Type of value
has("key") Check if key exists
select(cond) Filter items by condition
map(.field) Map: transform each element
map(select(.active)) Filter array by field
[.[] | .name] Collect results into array
add Sum numbers or concat arrays/strings
unique Remove duplicate values
group_by(.field) Group array by field value
sort_by(.field) Sort array by field
to_entries Object to [{key,value}] array
from_entries [{key,value}] to object
with_entries(.value += 1) Transform object entries
. + {k:v} Merge/add field to object
del(.key) Delete a key from object
empty Produce no output (filter all)
env All environment variables
ascii_downcase Lowercase string
split(",") Split string into array
Share this tool: X / Twitter LinkedIn
✓ 60,000+ developers use DevPlaybook ★★★★★ 4.8 / 5 on Gumroad ✓ MIT licensed · Instant download ✓ No login required

Related Products

on Gumroad
🛠️ $19

Developer Productivity Toolkit

Complete dev environment setup: VS Code settings, keybindings, snippets, shell aliases, Git hooks, tmux config, and Starship prompt. Copy, paste, code faster.

Buy on Gumroad →
🚀 $19

Premium Workflow Pack

Production-grade workflows, architecture guides, and deployment scripts for teams that ship. 10 advanced CI/CD workflows (blue-green, canary, E2E, security), 5 architecture deep-dives, code review checklist, PR process guide, and 5 battle-tested Bash deployment scripts.

Buy on Gumroad →
⚙️ $19

GitHub Actions CI/CD Templates Pack

12 production-ready GitHub Actions workflow templates covering Node.js, Python, Docker, multi-environment deployments, security scanning, and auto-changelog. Copy, paste, ship.

Buy on Gumroad →

You Might Also Need

JSON Diff Viewer

Free JSON diff viewer. Compare two JSON objects side-by-side with color-coded highlights: added lines in green, removed in red. Auto-formats JSON before comparing. Runs in your browser — your data nev

Open free tool →

Fake Data Generator

Generate realistic fake user data for testing and development. Choose locale (en/zh-TW/ja), count (1-100), fields to include, and output format (JSON/CSV/SQL INSERT). 100% browser-based.

Open free tool →

JSON Diff

Free JSON diff tool. Compare two JSON objects side-by-side with color-coded highlights: added lines in green, removed in red. Auto-formats JSON before comparing. Runs in your browser — your data never

Open free tool →

More Free Tools

JSON Diff Viewer Fake Data Generator JSON Diff JSON Formatter Pro JSON Path Finder YAML to JSON Converter CSV to JSON Converter JSON to CSV Converter JSON ↔ YAML Converter JSON Schema Form Builder Protobuf to JSON Converter CSV JSON Transformer JSON Schema to Zod Converter Mock Data Generator NFT Metadata Generator CSS Clip-Path Generator JSON Formatter & Validator JSON Schema Generator TOML to JSON Converter Turso Edge DB Explorer JSON to TypeScript Interface package.json Validator & Audit TOML to JSON Converter SQL ERD Diagram Generator Grafana Dashboard JSON Validator package.json Generator OpenAPI Mock Generator EVM Calldata Decoder Neon DB Query Builder SQL Index Advisor WebSocket Test Client Prisma Schema Visualizer Database Schema Visualizer LLM JSON Schema Builder Grafana Dashboard JSON Builder GraphQL Client Configurator OpenAI Function Calling Generator Database Schema Diff PlanetScale Branch Manager API Request Builder API Response Formatter & Analyzer HTTP API Tester Base64 Encoder & Decoder Base64 Encode / Decode Docker Compose Generator Git Command Builder Image to Base64 Converter JWT Builder JWT Decoder SVG Editor & Optimizer TOML Validator UUID v7 Generator WebSocket Tester YAML Validator & Formatter Dockerfile Generator PWA Manifest Generator JSON-LD Schema Generator Biome Config Generator Package Lock Analyzer Feature Flag Config Generator GCP Service Account Key Checker Azure ARM Template Validator ASCII Table Builder SBOM Generator Redis Command Tester Docker Run Command Builder JWT Debugger Pro CI/CD Pipeline Generator TypeScript tsconfig.json Generator Chrome Extension Manifest Generator NATS Connection String Builder OAuth2 Flow Visualizer mTLS Certificate Chain Builder Database Index Analyzer YAML Validator Pro API Mock Server Config Generator npm Package Stats AES Encryptor / Decryptor SQL to TypeScript Types Database Index Advisor AI Agent Memory Planner RAG Chunking Calculator MCP Endpoint Tester IPFS CID Version Converter ArgoCD Application Generator Kubernetes Resource Calculator MCP Server Config Builder LangGraph Workflow Visualizer AWS IAM Policy Generator GCP Service Account Key Auditor RAG Chunking Calculator Expo App Config Generator TypeScript Discriminated Union Builder Embedding Storage Calculator RAG Chunk Size Optimizer LLM Prompt Template Builder PostgreSQL Connection String Builder

Related Articles

Apr 4, 2026 · 13 分鐘

jq 命令列 JSON 處理完全指南：範例與實戰大全

jq 是處理 JSON 資料的終極 CLI 工具。本文涵蓋篩選、轉換、陣列操作、條件判斷、格式化輸出，以及與 curl 結合的實戰 API 資料處理範例。
Apr 1, 2026 · 11 min read

20 Best CLI Tools Every Developer Needs in 2026

The definitive list of CLI tools that actually improve developer productivity in 2026: navigation, file ops, search, git, system monitoring, terminal setup, and dev utilities — with install commands and real usage examples.
Mar 28, 2026 · 15 min read

Aider AI: The Ultimate Terminal-Based AI Coding Assistant for 2026

Complete guide to Aider AI coding assistant. Setup, best practices, model options, and how this terminal-based tool compares to GUI editors for serious developer workflows.
Mar 25, 2026 · 10 min read

How to Format JSON in VS Code, Terminal, and Online (2026 Guide)

Learn how to format JSON in VS Code, the terminal with jq and Python, and instantly online. This 2026 guide covers every method with working code examples and shortcuts.
Mar 24, 2026 · 7 min read

CSV to JSON Online: Convert Spreadsheet Data in One Click

Convert CSV to JSON online free — paste spreadsheet data and get valid JSON instantly. Handles headers, quoted commas, custom delimiters, and type coercion.

Enjoying this tool? Get more like it.

Weekly developer tool guides, productivity playbooks & AI tricks. Free. No spam.

DevPlaybook Pro 7 days free

Unlock AI-Powered Dev Tools

  • ⚡ AI Code Review, Doc Generator & SQL Builder
  • ⚡ All premium templates & early access
  • ⚡ Member discounts on Gumroad products
Start Free Trial →

$9/mo after trial · Cancel anytime

Want the full toolkit?

Get DevPlaybook Pro

Every template, guide, boilerplate, and automation script in one bundle. 13 premium products — grab them all at once and save big.

$79
$241 separately Save $162 (67% off)
Get DevPlaybook Pro — $79 →

MIT licensed · Instant download · No subscription

See what's included → Browse all deals →