Wrapping every line of a list the same way (quoting it, adding a trailing comma, turning it into a SQL value) is mechanical work that still goes wrong by hand once the list runs past a few lines. This applies the same prefix and suffix to every line, with presets for the patterns that come up constantly in day-to-day development work.

When you'd use this

Building a SQL `IN ('a', 'b', 'c')` list from a column of IDs pasted from a spreadsheet, quoting a list of strings for a code array literal, or adding a trailing comma to turn a plain list into valid syntax for whatever format you're pasting it into.

Common errors

The SQL IN list preset quotes each value with single quotes and joins them with a comma. If your values already contain a single quote (an apostrophe in a name, for instance), escape that separately. This tool doesn't know your target SQL dialect's escaping rules.

Frequently asked questions