a apiary.
← All tools

SQL / BROWSER UTILITY

SQL Quote List

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

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

Value type
List options

Good to know

Format one value per input line. Text uses single quotes and escapes apostrophes by doubling them. Numeric mode trims surrounding spaces and accepts signed decimals and exponents. Deduplication compares values after optional trimming. Empty input produces an empty list. This tool formats text only; use parameterized queries in applications.

Example: Alice, Bob and O'Brien on separate lines become 'Alice', 'Bob', 'O''Brien'.