ES
↑↓ navigate Enter open Esc close
Database & WordPress

DB Cleaner & SQL Optimizer

Generate SQL queries to clean your WordPress or PrestaShop: revisions, expired transients and table optimization.

Important: Always perform a full database backup before executing any SQL queries. DELETE queries are permanent and irreversible. Run the SELECT COUNT(*) versions first to see how many records will be removed.
Platform

Default WordPress prefix is wp_. Default PrestaShop prefix is usually ps_.

Select items to clean
Post Revisions
Old draft versions auto-saved when editing posts.
High impact
Expired Transients
Expired plugin cache entries stored in options table.
High impact
Spam & Trash Comments
Comments marked as spam or moved to trash.
Medium impact
Trashed Posts
Posts, pages, and custom post types in trash.
Medium impact
Orphan Postmeta
Postmeta entries without associated post.
Low impact
WooCommerce Sessions
Expired customer sessions in woocommerce_sessions table.
Medium impact
Generated SQL Queries

Related Tools & Calculators

Complementary utilities within the same thematic cluster to enhance your workflow.

Explore all Developer Tools tools →

SQL Formatter & Beautifier

Format, beautify, and minify SQL queries for MySQL, PostgreSQL, and SQLite to improve query readability.

Open tool

CSV Cleaner & Normalizer

Clean, trim spaces, remove duplicate rows, and normalize delimiters in CSV files prior to importing into databases.

Open tool

JSON Formatter & Validator

Format, validate, and beautify your JSON code instantly. Shows detailed syntax errors with line and column to...

Open tool

Configure which categories of cookies and data processing you wish to allow. Essential cookies cannot be disabled as they are required for basic technical operations.

1. Technical & Essential (Required) Always Active

Essential for security, rate limiting prevention, theme persistence, and session management.

Self-hosted analytics in European servers. Aggregated traffic measurement without third-party data sharing.

Standard non-intrusive banner/square ads and invalid traffic protection. Tags load only with this consent active.

Share this tool

Help others by sharing this free tool.

X (Twitter) LinkedIn Email