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 |
</>Use this tool programmaticallycurl · JavaScript · MCP
Same tool, callable from any HTTP client or from Claude (via MCP). Anonymous: 100 req/day per IP. Sign up for 1,000 req/day.
curl
curl https://api.b-e-a-d.com/tools/sql-parameterizer/run \
-H "Content-Type: application/json" \
-d '{
"input": "your input here",
"style": "dollar"
}'JavaScript (fetch)
const res = await fetch("https://api.b-e-a-d.com/tools/sql-parameterizer/run", {
method: "POST",
headers: { "Content-Type": "application/json" },
body: JSON.stringify({
"input": "your input here",
"style": "dollar"
}),
});
const data = await res.json();
console.log(data.result);MCP (Claude Desktop / Claude Code)
# In Claude Desktop / Claude Code, add to your MCP config:
{
"mcpServers": {
"bead": {
"command": "npx",
"args": ["-y", "mcp-remote", "https://mcp.b-e-a-d.com"]
}
}
}
# Then ask Claude to call:
mcp__bead__bead_sql_parameterizerFull reference: developer docs · OpenAPI spec
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.