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

20 tools · always free

All 20 tools

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 Finder

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

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.