Download and import the JSON preset
Save `regex-and-sql-deconstructor.json` and import it via the Vezz me extension popup.
Regex & SQL Deconstructor Prompt: token-by-token breakdowns and edge-case audits.
Download the Regex & SQL Deconstructor JSON preset for Vezz me. Highlight any gnarly regular expression, SQL query, or awk/jq one-liner for a token-by-token breakdown.
Best fit
Best for backend developers, data engineers, and SREs reviewing regular expressions, complex SQL queries, `jq` filters, and cron schedules.
On-screen walkthrough
How this looks on a real webpage.
Instead of switching tabs and rebuilding context, highlight the exact passage that slowed you down and press your shortcut (default: Ctrl+Shift+X or Cmd+Shift+X on macOS, fully customizable in settings).
1. Highlighted on page (GitHub Pull Request — Order Fraud Filter Query)
SELECT user_id, amount FROM orders WHERE user_id NOT IN (SELECT user_id FROM blacklisted_users) AND coupon_code ~ '^(?=.*[A-Z])(?=.*\d)[A-Z\d]{8,12}$';
Ctrl+Shift+X“Deconstruct this expression token-by-token and flag any edge-case bugs.”
2. Vezz me on-screen answer overlay
1. **Plain-English Goal**: Selects orders from non-blacklisted users whose coupon is an 8–12 char uppercase alphanumeric string with >=1 letter and >=1 digit.
2. **Token Breakdown**: `^(?=.*[A-Z])` requires an uppercase letter; `(?=.*\d)` requires a digit; `[A-Z\d]{8,12}$` enforces 8–12 uppercase/digit chars.
3. **Test Cases**: Matches `"SAVE2026"`; rejects `"save2026"` (lowercase) and `"VIP26"` (<8 chars).
4. **CRITICAL SQL BUG (`NOT IN` + `NULL`)**: If `blacklisted_users.user_id` contains even a **single `NULL`**, `NOT IN` evaluates to `UNKNOWN` and the entire query returns **0 rows**! Rewrite using `NOT EXISTS (SELECT 1 FROM blacklisted_users b WHERE b.user_id = orders.user_id)`.
3. Suggested follow-up questions in thread
- “Rewrite this regex without lookaheads so it compiles in Go's RE2 engine.”
- “What composite index on `orders` would optimize this query?”
Importable Prompt Preset
Use this custom prompt in Vezz me.
Copy the system prompt below or download the .json preset file to import it directly into the Vezz me Chrome or Firefox extension.
Vezz me Custom Prompt Preset
Regex & SQL Deconstructor
Forces the AI to generate concrete failing test inputs and check for classic silent killers like SQL `NOT IN (NULL)` and Regex catastrophic backtracking.
Deconstruct the selected regular expression, SQL query, shell pipeline, or cron expression: 1) Plain-English Goal: state in 1 sentence what it matches or computes, 2) Token/Clause Execution Breakdown: explain each token, lookaround, CTE, or window clause in logical execution order, 3) Concrete Test Cases: show 2 inputs that MATCH/SUCCEED and 2 subtle edge cases that FAIL, and 4) Bug & Performance Audit: flag any ReDoS backtracking risk, SQL NULL traps (like `NOT IN` with nullable columns), or index bypasses, with a safer rewrite.Step-by-step workflow
How to run this workflow in place.
Highlight any regex, SQL query, jq filter, or cron schedule
Select the expression inside a GitHub PR diff, Metabase/Superset editor, or Stack Overflow answer.
Review the failing test cases and NULL/ReDoS audit
Verify the generated edge cases before merging the expression to production.
Key details
Why this approach works better than switching tabs.
Frequently asked questions
Common questions about developer syntax preset.
Does this preset also work for bash/awk/jq and cron expressions?
Yes! The prompt explicitly handles regex, SQL, shell pipelines (`awk`, `sed`, `jq`), and cron schedules.
Can I ask it to convert the regex to a specific flavor (PCRE, JS, Rust, Go RE2)?
Yes—just mention your target runtime if you need a rewrite without lookarounds (e.g., for Go `regexp` / RE2).
Is this preset free?
All Vezz me JSON prompt presets are 100% free to download, customize, and share.
Related workflows & guides
Explore connected pages.
Ready to try this workflow on your own reading?
Install Vezz me free, highlight text on any webpage, and press your customizable shortcut (default: Ctrl+Shift+X or Cmd+Shift+X on Mac) to get an answer right beside the source.
