SQL Parameterizer
Replace inline values with ?, $1, or :p1 placeholders and emit the bind list.
Parameterized SQL
Bind values (4)
| Index | Type | Value |
|---|---|---|
| $1 | string | 2024-01-01 |
| $2 | string | active |
| $3 | number | 18 |
| $4 | string | %@example.com |
What it does
Replaces inline string and number literals in your query with the placeholder style of your driver — ?, $1…$N, or :p1…:pN — and emits the extracted values as an ordered list you can paste into the bind step.
Limits
This is a regex-aware tokenizer, not a full SQL parser. It will replace values inside VALUES lists, WHEREcomparisons, and function arguments. Identifiers (table/column names) are left alone.
You might also like
- Escape / UnescapeEscape or unescape strings for JSON, JavaScript, HTML attribute, XML, and SQL contexts.
- SQL CREATE TABLE GeneratorInfer column types from sample data and emit CREATE TABLE for PostgreSQL, MySQL, SQLite, or SQL Server.
- SQL DiffCompare two SQL queries or schemas after canonical formatting — ignore whitespace and casing noise.
- SQL Escape / UnescapeSafely quote string literals for ANSI, MySQL, or PostgreSQL — and reverse it.