Sigma Search & Replace

Description

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

Technical details