a apiary.
THE EVERYDAY UTILITY COLLECTION Local by default

LESS FRICTION. MORE FLOW.

Little tools.
Big time savers.

For the small tasks between the important ones.
Fast, free utilities that keep your data in your hands.

↗ No signup◇ Private by designϟ Ready when you are

PICK A TOOL. GET IT DONE.

Your everyday essentials

50 tools · always free
What are you working with?

Paste or type content for local tool suggestions. Nothing is read from your clipboard automatically, saved or sent anywhere.

All 50 tools

JSON & XML

XPath Tester

Query XML with XPath 1.0 and explicit namespace mappings locally.

Open tool
JSON & XML

JSONPath Tester

Find JSON values and paths with RFC 9535 JSONPath queries.

Open tool
Developer

Regex Tester

Test JavaScript regular expressions, inspect captures and preview replacements locally.

Open tool
JSON & XML

JSON ↔ YAML Converter

Convert JSON and conservative YAML 1.2 locally, with explicit conversion limits.

Open tool
JSON & XML

XML ↔ JSON Converter

Convert XML and JSON using explicit attributes, text and repeated-element mappings.

Open tool
JSON & XML

JSON Schema Validator

Validate JSON against a local Draft 2020-12 schema and inspect failing paths.

Open tool
Developer

Data Extractor

Extract useful values from text using presets or a bounded custom regular expression.

Open tool
CSV & Data

CSV to SQL INSERT

Map delimited columns to escaped SQL INSERT batches for five database dialects.

Open tool
Developer

UUID / ULID Generator

Generate random UUID v4, timestamped UUID v7 and ULID values locally.

Open tool
JSON & XML

XML Test Data Generator

Create bulk XML test records from any XML template using editable tables and field naming patterns.

Open tool
CSV & Data

Delimited File Generator

Create and download CSV, TSV or custom-delimited files from spreadsheet rows or an editable table.

Open tool
JSON & XML

XML to SQL Script

Map an XML template to static values, columns and expressions, then generate Oracle SQL that builds the XML.

Open tool
JSON & XML

XML to SQL INSERT

Map XML records and fields to SQL INSERT statements for your database dialect.

Open tool
SQL

SQL to XML Builder

Use an XML template to generate a query that populates elements from table columns.

Open tool
Text

Compare Lists

Find the differences and shared values between two lists.

Open tool
Text

Remove Duplicate Lines

Clean up repeated lines while keeping your original order.

Open tool
SQL

SQL IN Clause Generator

Turn a list of values into a safely escaped SQL IN expression.

Open tool
JSON & XML

JSON Formatter & Validator

Validate, format and minify JSON without sending it anywhere.

Open tool
Developer

Unix Timestamp Converter

Convert timestamps and dates with explicit UTC handling.

Open tool
Text

Sort Lines

Put lines in order, with natural number sorting and whitespace options.

Open tool
Text

Change Text Case

Convert text into eight useful cases, from titles to variable names.

Open tool
Text

Find & Replace

Replace the first or every occurrence of plain text in your content.

Open tool
Text

Text Counter

Count characters, words and lines as you type.

Open tool
SQL

SQL Quote List

Format values as a quoted SQL list, without the IN wrapper.

Open tool
SQL

SQL CASE Builder

Turn two-column mappings into a SQL CASE expression.

Open tool
CSV & Data

CSV Column Extractor

Pick a CSV column and extract its values into a clean list.

Open tool
CSV & Data

CSV ↔ TSV Converter

Convert comma-separated and tab-separated data with quoted fields intact.

Open tool
CSV & Data

CSV to JSON

Turn CSV rows into JSON objects while preserving values as strings.

Open tool
Developer

Base64 Encode / Decode

Encode UTF-8 text or decode Base64, including Unicode characters.

Open tool
SQL

SQL Join Calculator

Calculate join row counts and preview matching and unmatched keys.

Open tool
SQL

SQL Syntax Reference

Find PostgreSQL syntax by keyword or task and copy a useful example.

Open tool
SITS

SITS Delimited List

Build SITS lists with configurable delimiters, suffixes and eVision output.

Open tool
SITS

Remove SCJs

Remove SCJ suffixes from a list, keeping the part before each slash.

Open tool
SITS

Find Duplicates

Separate repeated values from values that occur exactly once.

Open tool
CSV & Data

Transpose CSV / TSV

Swap rows and columns while preserving quoted CSV or TSV values.

Open tool
JSON & XML

XML Formatter & Validator

Read, check and indent XML locally, with useful parsing errors.

Open tool
HTML, CSS & JavaScript

HTML Validator

Check HTML source for common markup errors without rendering it.

Open tool
HTML, CSS & JavaScript

CSS Validator

Check stylesheet syntax and property values without applying styles.

Open tool
Developer

Compare File Contents

Paste two files’ text to see added, removed and unchanged lines.

Open tool
SQL

SQL Syntax Checker

Check SQL syntax, common mistakes and potential performance issues locally for Oracle, SQL Server, PostgreSQL, MySQL/MariaDB and SQLite.

Open tool
SQL

SQL Formatter

Format SQL locally with dialect-aware layout and unchanged tokens.

Open tool
SQL

SQL Minifier

Reduce SQL whitespace while preserving quoted values, hints and line boundaries.

Open tool
HTML, CSS & JavaScript

JavaScript Syntax Checker

Find JavaScript syntax errors with line and column diagnostics.

Open tool
HTML, CSS & JavaScript

JavaScript Formatter

Pretty-print JavaScript locally without executing source.

Open tool
HTML, CSS & JavaScript

JavaScript Minifier

Minify JavaScript with an AST-aware printer and compare character counts.

Open tool
JSON & XML

XML Element Counter

Count XML elements, inspect values and compare lists from local XML.

Open tool
SQL

SQL INSERT Builder

Generate INSERT statements from rows of text, numbers and NULL values for your SQL dialect.

Open tool
SQL

SQL UPDATE Builder

Build UPDATE statements with SET fields, WHERE conditions and an explicit warning for unrestricted changes.

Open tool
SQL

SQL DELETE Builder

Generate DELETE statements with configurable conditions and a warning before copying an unrestricted deletion.

Open tool
SQL

SQL CREATE TABLE Builder

Generate CREATE TABLE statements with column types, defaults and primary keys for your SQL dialect.

Open tool

A growing little collection.

More useful tools, same simple approach.

BUILT TO KEEP THINGS MOVING

Your data stays yours.

Processed locally in your browser. Your data is not uploaded.