Sigma Search & Replace

Sigma Search & Replace is a comprehensive WordPress plugin that allows you to search and replace content throughout your WordPress database with ease and safety. Whether you’re migrating a site, changing domain names, or updating content across multiple posts, this plugin provides a user-friendly interface to handle complex database operations.

How It Works

1. Search Phase — The plugin searches through your database tables to find matches
2. Review Results — View detailed reports of what will be changed before proceeding
3. Replace Phase — Safely execute the replacement with progress tracking
4. Completion Report — Get a detailed summary of all changes made

Key Features

• Selective Table Processing — Choose which tables to include in operations
• Two-Step Safety – Search → review → Replace; nothing changes until you click replace.
• Case Sensitive/Insensitive Search — Full control over search sensitivity
• GUID Protection — Option to skip WordPress GUIDs to maintain data integrity
• Serialized-Data Support – Detect and update strings stored inside PHP-serialized arrays or objects without breaking their structure.
• Real-time Search Progress — Live progress tracking with detailed reporting; click Stop to cancel mid-run.
• Real-time Replace Progress — Live progress tracking with detailed reporting; click Stop to cancel mid-run.
• Batch Processing — Handles large databases efficiently with configurable batch sizes
• Detailed Search Preview — Comprehensive user-friendly interface showing exactly what was found and changed
• Detailed Reports & Logs – Per-table hit counts, replacement summaries, and error logs.
• Multisite Ready – Network admin: any site; sub-site admin: own site only.
• Modern React Interface — Clean, intuitive user interface built with React
• REST API Integration — Secure API endpoints for all operations

Perfect For

• Site Migration — Moving WordPress sites to new domains or servers
• URL Updates — Changing domain names or switching between HTTP/HTTPS
• Content Updates — Bulk updating text, links, or other content across your site
• Development — Updating staging site URLs for local development
• Maintenance — Cleaning up old content or updating deprecated information

Safety Features

• Backup Warnings — Multiple reminders to backup your database before making changes
• Dry Run Capability — Preview what will be changed without making actual modifications
• Table Validation — Ensures database tables are valid before processing
• Smart Change Detection — Skips updates if values changed after the search.
• Site URL Safeguard — Automatically detect and delay site URL edits to the end to avoid breaking the process.
• Error Handling — Comprehensive error handling and logging

Technical Features

• Efficient Processing — Handles large databases with memory-conscious batch processing
• Timeout Management — Automatic timeout handling for long-running operations
• Security — Proper authentication and authorization checks
• Logging — Comprehensive logging system for troubleshooting