PrestaShop Database Cleaner
KLN-DB Cleaner — Database cleanup and optimisation module for PrestaShop 1.7 to 9. Speed up your shop by automatically removing obsolete data (abandoned carts, logs, connections, heavy stats, cache) and shrinking your MySQL database size.
⚠️ Important: KLN-DB Cleaner runs irreversible actions (data deletion, table optimisation, advanced cleanup). The user is fully responsible for the operations launched. A full backup of the database is strongly recommended before any use.
Module preview
In-depth information
Smart cleanup of obsolete data
Removes abandoned carts (without orders), guest ghosts, expired connections, old logs and bulky stats. Configurable period (months) with batches of 1,000 records.
Safe removal of expired promotions
Automatically cleans up expired cart rules (cart_rule) and specific prices (specific_price) via the PrestaShop ORM to ensure integrity across all related tables.
Full control and maximum security
No automatic actions: every operation requires manual validation. Protected by unique token for CRONs, strict validation of allowed tables, restrictions on TRUNCATE for sensitive tables.
Customisable CRON automation
Configure CRON tasks with secured URLs (auth tokens). Pick the action (truncate/delete), tables and retention period. Optional, to be enabled manually.
Full interface with detailed stats
View total database size, size of each table (MB), record counts and thresholds. Real-time progress bar: deleted/total and percentage.
Systematic backup recommendation
Before any deletion, the module explicitly reminds you that a full backup is required. Actions are permanent and KLN-WEB is not responsible for misconfigured cleanup.
Technical specifications
| PrestaShop version | 1.7.x — 9.x |
|---|---|
| PHP | 7.4+ recommended |
| Database | MySQL 5.7+ / MariaDB 10.2+ |
| Compatibility | Multi-shop, Multilingual |
| Required modules | None |
| Module size | ~15 MB |
Benefits for your shop
- Improved performance: database 30 to 70% lighter, faster SQL response times.
- Greater stability: fewer overloaded tables, fewer crashes from cache or logs.
- Simpler maintenance: a single click to clean up, or an automatic CRON job.
- No manual SQL: everything goes through the interface, secured and traced.
- Long-term compatibility: tracks PrestaShop versions from 1.7 to 9.