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
- Search Phase – The plugin searches through your database tables to find matches
- Review Results – View detailed reports of what will be changed before proceeding
- Replace Phase – Safely execute the replacement with progress tracking
- 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
