Lucid Search & Replace
A WordPress database search-and-replace tool that safely handles serialized PHP data, with a visual preview before anything changes.
🔗 Visit Lucid Search & Replace
Description
Anyone who's migrated a WordPress site between domains knows the classic trap: you run a database search-and-replace to swap the old URL for the new one, and suddenly parts of your site break because WordPress stores some settings as “serialized” PHP data — a format that embeds the exact character length of each string. If a naive find-and-replace changes the text without recalculating those lengths, the serialized data becomes corrupted and WordPress can't read it anymore. Lucid Search & Replace exists specifically to avoid that trap.
It's a WordPress plugin, distributed through the WordPress.org plugin directory, that unserializes affected data, performs the replacement, and correctly re-serializes it with valid length prefixes — including handling JSON embedded inside serialized fields, escaped slashes, and base64-encoded content. Before anything is changed, it shows a preview of every match grouped by table and column; it processes large sites in background batches to avoid timeouts, automatically backs up affected rows for one-click rollback, and protects user/login tables by default. It supports regex, case-sensitive matching, multisite installs, WP-CLI, and exports a CSV log of every operation.
💬 Our review
The short version: if you've ever corrupted a WordPress site's settings with a careless search-and-replace during a domain migration, this plugin is built to solve exactly that problem safely — the catch is it has zero GitHub stars and no visible track record yet, so test it on a staging copy before running it against production data.
Against the raw WP-CLI `search-replace` command, Lucid Search & Replace's real advantage is the preview-before-execute workflow and automatic backup/rollback — WP-CLI's version works but gives you no visual confirmation before it commits changes, and recovering from a mistake means restoring from your own backup. Against other WordPress search-replace plugins in this space (several exist with more established user bases), this one's specific claim to fame is more thorough serialized-data handling, including JSON-in-serialized-data and base64 edge cases that simpler plugins sometimes miss. It's free either way, so the real decision is trust: given the low adoption so far, always back up your database independently before running any bulk operation on production, regardless of which tool you use. Reasonable pick for a WordPress developer doing frequent migrations who wants preview-first safety; if you're doing a one-off simple change, WP-CLI alone might be sufficient.
💰 Pricing
📊 Global score
🤖 AI-enriched data
Gratuit, plugin WordPress.org, licence GPL-2.0-or-later.
Pros
Gère correctement les données sérialisées PHP, JSON imbriqué et base64
Aperçu des correspondances avant toute modification
Backups automatiques avec rollback en un clic
Gratuit, compatible WP-CLI et multisite
Cons
Zéro étoile GitHub, aucun historique de production visible
Toujours sauvegarder la base indépendamment avant une opération en masse
Communauté plus restreinte que les plugins de search-replace établis