Wrapping every line of a list the same way - quoting it, adding a trailing comma, turning it into a SQL value - is mechanical but easy to get wrong by hand on anything longer than 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 with a comma - if your values already contain a single quote (an apostrophe in a name, for instance), that needs escaping separately, since this tool doesn't know your target SQL dialect's escaping rules.

Frequently asked questions