Building 5 Client-Side Developer Utilities for Laravel & MySQL 8.4 (Zero Backend, Web Crypto API)
Whenever I'm working on high-volume Laravel and MySQL 8.4 applications, I constantly run into small, repetitive checks—verifying whether an ALTER TABLE statement supports ALGORITHM=INSTANT, ordering composite index colum
Whenever I'm working on high-volume Laravel and MySQL 8.4 applications, I constantly run into small, repetitive checks—verifying whether an ALTER TABLE statement supports ALGORITHM=INSTANT, ordering composite index columns properly, sizing Horizon worker RAM limits, or testing webhook HMAC signatures without pasting production secrets into a third-party server.
To keep all of these in one fast, zero-telemetry place, I built tools.gulfaraz.me (open-source on GitHub at gulfaraz-arshad/laratools).
Architecture: 100% Client-Side Execution
Every tool runs strictly in the browser using vanilla JavaScript, Tailwind CSS, and native browser APIs:
- Zero backend servers: Static deployment on GitHub Pages with instant load times.
- No telemetry or tracking: No payloads or signing keys ever leave your machine.
-
Native Web Crypto API: Cryptographic operations run directly via
window.crypto.subtle.
What's Inside the Suite
-
MySQL 8.4
ALGORITHM=INSTANTDDL Checker Paste aCREATE TABLEorALTER TABLEstatement to verify whether MySQL 8.4 executes it instantly via metadata-only changes or falls back to anINPLACE/COPYtable rebuild. - Composite Index Builder Orders multi-column indexes using the Equality → Range → Sort rule and outputs both raw SQL and Laravel Blueprint migration syntax.
-
Webhook HMAC-SHA256 / SHA1 Debugger
Computes and verifies webhook signatures locally using
window.crypto.subtleand generates constant-timehash_equals()verification snippets for Laravel controllers/middleware. -
JSON to PHP 8.2+
final readonlyDTO Generator Converts raw API or webhook JSON payloads into strict-typed PHP 8.2+final readonlyData Transfer Objects complete withfromArray()andtoArray()methods. -
Laravel Horizon & Redis Worker Calculator
Estimates queue throughput, backlog drain times, and worst-case memory footprint (
workers × memory_limit) to help prevent OOM kills in production.
Try It Out
You can test all five utilities at tools.gulfaraz.me or inspect/fork the source code on GitHub.
If you have ideas for additional Laravel or MySQL utilities—or edge cases in MySQL 8.4 DDL rules—drop a comment below!
Originally published by Dev.to WebDev. Aggregated on AIWithGhost for educational purposes — full credit and traffic to the original publisher.