JQ / JSONPath
Experiment with jq filters and JSONPath expressions against your own data and see the result instantly.
Features
- jq paths, pipes, .[] and common functions
- JSONPath with wildcards and recursive descent
- Clickable examples
- Copy results as JSON
How to use it
- Paste JSON.
- Type a jq filter (starting with .) or a JSONPath (starting with $).
- Copy the matching values.
FAQ
Which jq features are supported?
Paths, .[], pipes, keys, length, type, to_entries and values.
More developer tools
API Studio
Build, test and automate HTTP requests right in your browser.
- API Studio: Build, test and automate HTTP requests: collections, environments, tests and a runner.
Diagrams
Draw cloud architectures and watch the data flow.
- Architecture Builder: Draw cloud architectures and data flows with AWS, Azure, GCP and 1,000+ components.
CI/CD
See, edit and check your CI/CD pipelines.
- Pipeline Studio: See and edit your Bitbucket pipelines as a metro map, with checks for mistakes Bitbucket would reject.
Data
Query, browse and edit data files and SQLite databases.
- Database Studio: Query, browse and edit CSV, Excel, Parquet and SQLite files with SQL, right in your browser. Nothing is uploaded.
System Design
Simulate traffic through a system design and find its limits.
- System Design Simulator: Design a system, send it traffic and watch where it melts: latency, errors and the bottleneck.
Team Knowledge
Every error your team has hit, and how it was fixed.
- Error Memory: Search every error your team has hit and how it was fixed; log new ones with their fix.
Formatters & Beautifiers
Make messy payloads, queries and markup readable.
- JSON & Log Formatter: Repair, beautify and deep-decode JSON, Python dicts and log lines.
- SQL Formatter: Pretty-print queries for 12 SQL dialects.
- XML / HTML Beautifier: Beautify or minify HTML and XML, with validation.
- JSON Diff: Compare two payloads side by side or as a change list.
- SQL Diff: Compare queries, scripts or schemas as SQL, with schema changes and the migration.
- JQ / JSONPath: Filter JSON with jq or JSONPath expressions.
Encoders & Decoders
Look inside tokens, encodings and escaped text.
- JWT Debugger: Decode tokens, check expiry and verify HMAC signatures.
- Base64 / Hex / Binary: Convert text and files between Base64, hex and binary.
- URL / Query Parser: Split, edit and rebuild URLs and query strings.
- HTML & Unicode Entities: Encode and decode HTML entities and Unicode escapes.
Generators
IDs, hashes, keys, placeholder text and typed code.
- UUID / ULID / Hash: Generate UUIDs and ULIDs; hash text or files.
- Lorem Ipsum: Placeholder paragraphs, sentences or words.
- RSA / EC Key Pair: RSA and EC key pairs as PEM or JWK, via WebCrypto.
- Schema & Code Generator: Turn sample JSON into TypeScript, Zod, Go, Rust, SQL and more.
Converters
Move data between formats, times and color spaces.
- Unix Timestamp ↔ Date: Convert Unix timestamps to dates and back.
- Color Converter: HEX, RGB, HSL and OKLCH with WCAG contrast checks.
- Cron Parser: Explain cron expressions and list upcoming runs.
- Format Converter: Convert between JSON, YAML, TOML, XML and CSV.
API & Debugging
Reproduce requests, read errors and sanitise logs.
- Log → cURL: Rebuild a runnable cURL from logs, HAR or fetch calls.
- HTTP Status Codes: Status codes with causes and fixes.
- Payload Redactor: Strip secrets and personal data before you share.
- Regex Tester: Test patterns live and explain them token by token.