Recipes

Explained, ready-to-run workflows that chain several tools. Run one here to see what it does, then open it in Pipelines to change its steps, options or input.

DataStarter

Validate, tidy and minify JSON

Accept sloppy JSON5, sort its keys and ship it compact.

Config files written by hand drift: comments, trailing commas, random key order. This normalises them into canonical, diff-friendly minified JSON.

  1. JSON Formatter
  2. JSON Minifier
API & WebIntermediate

Extract with jq, then Base64 it

Pull a sub-document out of an API response and encode it for a header.

Many APIs expect a Base64 JSON blob in a header (e.g. X-Context). jq picks exactly the part you need.

  1. jq Playground
  2. JSON to Base64
DevOpsStarter

Spreadsheet rows to a YAML config

Turn a CSV export into typed JSON, then into YAML you can commit.

Feature flags and environment matrices often live in a spreadsheet. Typed parsing keeps numbers and booleans as real values in the YAML.

  1. CSV to JSON
  2. JSON to YAML
DataStarter

CSV to a formatted MySQL seed script

Infer column types, generate CREATE TABLE and INSERTs, then pretty-print it.

Seeding a dev database from a CSV export is a daily chore; inferring types saves writing the DDL by hand.

  1. CSV to SQL
  2. SQL Formatter
DataIntermediate

SQL over a CSV, printed as a table

Aggregate a CSV with real SQL, then frame the result as a box-drawn table.

Quick reports for a README, a ticket or a terminal — no database, no spreadsheet.

  1. Query CSV
  2. Box Drawing
API & WebIntermediate

Flatten an API response into CSV

Select the records with jq and flatten nested fields into dot-path columns.

Analysts want a spreadsheet; the API gives nested JSON wrapped in metadata.

  1. jq Playground
  2. JSON to CSV
API & WebStarter

Decode a URL-encoded Base64 JSON blob

Percent-decode a query value, Base64-decode it and pretty-print the JSON inside.

State, redirect and tracking parameters often hide JSON behind two layers of encoding.

  1. URL Decode
  2. Base64 Decode
  3. JSON Formatter
SecurityIntermediate

Redact logs, then prove nothing leaked

Mask PII and credentials in logs, then run the secret scanner over the result.

Before attaching logs to a ticket or sharing them with a vendor, redact — and double-check with a second, independent scanner.

  1. Log Workbench
  2. Secret Detector
SecurityIntermediate

Fingerprint JSON canonically

Sort keys, minify, then SHA-256 — so equal documents hash equally.

Cache keys, idempotency keys and change detection need a hash that ignores key order and whitespace.

  1. JSON Minifier
  2. Hash Generator
Text & CodeIntermediate

Replay a query from an ORM log

Inline the bound parameters from a Hibernate log, then format the SQL.

To reproduce a slow or failing query in a SQL client you need the literal statement, not placeholders.

  1. Inline SQL Vars
  2. SQL Formatter
DataAdvanced

RSS/XML feed to a CSV of items

Convert XML to JSON, pick the items with jq, then flatten to CSV.

Legacy systems speak XML; your spreadsheet doesn't.

  1. XML to JSON
  2. jq Playground
  3. JSON to CSV
DevOpsAdvanced

Validate a YAML config against a JSON Schema

Parse YAML to JSON, then validate it with Ajv against your schema.

Catch a typo'd key or a string where a number belongs before the deploy does.

  1. YAML to JSON
  2. Schema Validator
DevOpsStarter

List dependencies from pyproject.toml

Parse TOML, then query it with jq like any JSON document.

Auditing dependencies across repos is easier once config is JSON.

  1. TOML to JSON
  2. jq Playground
Text & CodeStarter

Indented outline to a framed file tree

Turn an indented list into a tree, then put a titled box around it.

Project structures for READMEs and design docs, without drawing a single line by hand.

  1. ASCII Tree
  2. Box Drawing
Text & CodeStarter

Headlines to unique, sorted URL slugs

Slugify each line, drop duplicates and sort.

Generating routes or anchors from a list of titles.

  1. Text Toolbox
  2. Text Toolbox
  3. Text Toolbox
DataIntermediate

Fake users straight into PostgreSQL

Describe a schema once, generate reproducible rows, emit a Postgres seed script.

Realistic, seeded test data for local development and demos — the same rows every time you run it.

  1. Mock Data
  2. CSV to SQL
DataAdvanced

Generate an API fixture and profile it

Fill a JSON template with realistic values, flatten to CSV, then profile every column.

Check that a fixture has the spread you expect — nulls, ranges, distinct values — before you build tests on it.

  1. Random JSON
  2. JSON to CSV
  3. Data Explorer
SecurityStarter

Unique client IPs from an access log

Extract IPv4 addresses with a regex, drop duplicates and sort them naturally.

The first question in any incident: who was hitting us?

  1. Regex Tester
  2. Text Toolbox
  3. Text Toolbox
DevOpsStarter

.env to a Kubernetes ConfigMap, validated

Convert a dotenv file to a ConfigMap manifest, then lint the YAML.

Moving an app from docker-compose to Kubernetes starts with its environment.

  1. Env Toolkit
  2. YAML Validator
API & WebStarter

Offline mock API to a spreadsheet

Call the built-in mock API, then flatten the JSON response to CSV.

Prototype a data export against a fake backend before the real one exists. Edit the routes in Fake JSON API.

  1. Fake JSON API
  2. JSON to CSV
Text & CodeStarter

Placeholder article as HTML

Generate Markdown placeholder copy, then render it to HTML.

Fill a layout with realistic headings, paragraphs and lists while the real copy is being written.

  1. Lorem Ipsum
  2. Markdown Editor