SQL Named Parameter Extractor

How to use this developer tool

1. Paste the sql statement or load a local text file.
2. Adjust the available checks or parsing options.
3. Select Extract Parameters or press Ctrl/Cmd + Enter.
4. Review the summary, detailed output, and structured export before using the result.

What this developer tool does

Extract colon-style named parameters from SQL while ignoring quoted strings, comments, and PostgreSQL type casts. The result includes occurrence counts and line-and-column positions, making it useful when building parameter maps or checking that a query and its bindings stay in sync.

This targets :name placeholders. Positional markers such as ?, $1, and @name are intentionally not included.

Example

The bundled sample demonstrates the expected input. Select Sample, run the analyzer, and compare the detailed output with the summary metrics.

UPDATE users SET display_name = :name
WHERE id = :user_id AND tenant_id = :tenant_id;

Use cases

• Pre-commit and code-review checks
• Query or repository troubleshooting
• Generating copy-ready diagnostics for an issue

Tips for reliable output

• Use the exact text that the target system will receive.
• Keep dialect- or policy-specific options aligned with your project.
• Review warnings even when the main result is valid.
• Save structured JSON when another script needs the findings.
• Confirm destructive operations in the real environment separately.

Processing details

Runs a small lexical scanner over code, string, quoted-identifier, line-comment, and block-comment states.

This targets :name placeholders. Positional markers such as ?, $1, and @name are intentionally not included.