SQL placeholder converter

Convert anonymous ? parameters to PostgreSQL $1 numbering, or convert numbered parameters to ?. Preserve quoted text and comments without executing SQL.

01 Input

YOUR INPUT

02 Output

LOCAL RESULT

QUICK GUIDE / 34

How to use

Select Load example to restore the sample, or replace the labeled inputs with your own values.
Review the options and select Run tool. No input is sent to a server.
The parameter-order report maps each output placeholder to its original binding. For $2, $1, $2 the ? binding order is 2, 1, 2.
Inspect the result, then copy or download it. Clear removes visible inputs and output.

A worked example

Load example restores these values.

Direction:
? to $n

SQL text:
SELECT * FROM users WHERE id = ? AND note = '?' -- ? stays
AND active = ?;

Expected result

SELECT * FROM users WHERE id = $1 AND note = '?' -- ? stays
AND active = $2;

Parameter order: 1, 2

Scope & limitations

Handles single/double/backtick quotes, PostgreSQL dollar quotes and nested block comments. Bare ? is treated as a parameter, including PostgreSQL JSON operators; do not use that direction on SQL using ? operators. Backslash-escaped strings and bracket identifiers are rejected; this is not a dialect translator.

Preparing offline tools…Everything runs on your device.

SQL placeholder converter

01 Input

02 Output

Related tools

.env checker & comparison

.gitignore rule tester

EditorConfig generator