內容簡介
Lucid Search & Replace 是一款安全的資料庫查找與替換外掛，能在進行資料庫修改前提供預覽，並具備撤銷功能，避免因為序列化資料而導致的錯誤，確保網站資料的完整性。
【主要功能】
• 視覺預覽：提供代表性匹配的預覽
• 序列化資料安全：正確處理序列化陣列與物件
• 一鍵撤銷：可在修改後恢復未變更的儲存格
• 自動快取清除：執行後自動清除快取
• 支援大資料庫：背景批次處理以提高效率
• 兼容 WP-CLI：支援腳本化與分階段遷移
外掛標籤
開發者團隊
② 後台搜尋「Lucid Search & Replace – Safe Database Find and Replace with Preview and Undo」→ 直接安裝（推薦）
原文外掛簡介
Changing a domain, moving off a staging URL, or switching to HTTPS means rewriting text all through your database. Most tools do it blind: you type into a box, press go, and hope. When the value is serialized (theme settings, Elementor layouts, WooCommerce data) a plain replace miscounts the length prefix and corrupts the row, and there is no way back.
Lucid Search & Replace is built the other way around. You preview representative matches before anything is written, can take a safety snapshot, and can undo unchanged cells while that snapshot is retained. Nothing about that is held behind an upgrade.
What makes it safe
Visual preview, always free. Up to 20 representative matches per table, grouped by table and column, with the exact characters that change highlighted. Review them, then decide.
Serialized-data safe. The engine walks serialized arrays and objects, replaces inside them, and recalculates the s:N byte-length prefixes so the value stays valid.
Handles the case other tools miss. Page builders store URLs as JSON inside serialized data, with escaped slashes (http:\/\/). A search for http:// never matches that, so the old link silently survives. This engine decodes the JSON, replaces, and re-encodes in the original style. Base64-wrapped values are handled the same way.
Optional snapshot and one-click undo. When enabled at confirmation, affected cells are copied before each write. Undo restores cells that still contain the applied value and reports later edits as conflicts.
Protected by default. Network-global, user, and login tables are excluded from site-level runs. Post GUIDs are left alone unless you ask, because changing them breaks feeds and comments.
Built for real sites
Background batching for large databases. Work runs in bounded batches through Action Scheduler and resumes from durable progress after each completed batch.
Regex, case sensitivity, and exclusions for precise control, all optional behind an Advanced panel so a first-time user is never overwhelmed.
Target specific tables while safely discovering their text columns, or scan every eligible site table.
Automatic cache purge after a run. Regenerates Elementor CSS and clears WP Rocket, LiteSpeed Cache, and W3 Total Cache so the site does not keep serving old URLs.
Downloadable CSV of retained preview excerpts, streamed through an authorized admin route when change logs are enabled.
WP-CLI for scripted and staged migrations.
Multisite aware.
A note on the paid product
The search and replace here is complete and free. If you are moving an entire site rather than rewriting text, SafeGuard handles full migrations with scheduled off-site backups. It is mentioned in the plugin’s own Pro Tools tab and nowhere else. You never need it to use everything on this page.
Source code and build process
The full, uncompiled source lives at https://github.com/ibrahimhajjaj/lucid-search-replace
The admin screen is a TypeScript and React application under src/. The shipped build/index.js and build/style-index.css are generated from it with @wordpress/scripts (webpack). To reproduce them from a checkout:
composer install
npm install
npm run build
npm run package assembles the distributed zip. Translation templates are regenerated with `npm run make-pot`.
Bundled third-party library: Action Scheduler by Automattic (GPL-3.0-or-later), https://github.com/woocommerce/action-scheduler, installed under vendor/ via Composer and used for background batch processing.
