SQL VALUES Generator

Runs in browser Database

Produce (v1, v2), (v3, v4) tuples from CSV/TSV data for multi-row INSERTs, MERGE sources and CTEs with proper escaping.

Privacy: This tool runs entirely in your browser. Your input never leaves your device.

How to use SQL VALUES Generator

  1. Paste tabular data with a header row.
  2. Pick the output style and dialect.
  3. Copy the VALUES list or derived table.

SQL VALUES Generator features

  • CSV/TSV rows to (v1, v2), (v3, v4) tuples
  • Derived-table and CTE output with column aliases
  • INSERT statement output for quick seeding
  • Type-aware literals (numbers, booleans, NULL, quoted text)
  • Dialect-specific syntax: MySQL ROW(), Oracle SELECT … FROM DUAL

SQL VALUES Generator example

Derived table for a JOIN

Input:

sku,price
MT-100,89.9
MT-220,249

Output:

SELECT * FROM (
  VALUES
    ('MT-100', 89.9),
    ('MT-220', 249)
) AS v (sku, price)

Frequently asked questions about SQL VALUES Generator

What can I do with a VALUES list?

Use it as the body of a multi-row INSERT, as an inline table in a JOIN (SELECT * FROM (VALUES …) AS v(a, b)), as a MERGE source or as a CTE for testing queries without creating tables.

Which output styles exist?

Plain tuples, a derived table with column aliases, a CTE (WITH v AS …) and a full INSERT statement. MySQL uses ROW(…) syntax and Oracle uses SELECT … FROM DUAL with UNION ALL.

How are types inferred?

Each column is inspected: integers and decimals stay unquoted, booleans map to the dialect representation, empty or NULL cells become NULL and everything else is quoted text.