{"id":262118,"date":"2025-11-20T17:45:15","date_gmt":"2025-11-20T17:45:15","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/advance-database-cleaner\/"},"modified":"2026-01-01T18:15:07","modified_gmt":"2026-01-01T18:15:07","slug":"smartpro-database-optimiser-cleaner","status":"publish","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/smartpro-database-optimiser-cleaner\/","author":21071514,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.0","stable_tag":"1.0","tested":"6.9.4","requires":"5.0","requires_php":"7.4","requires_plugins":null,"header_name":"SmartPro Database Optimiser & Cleaner","header_author":"Kirtikumar Solanki","header_description":"Safely clean, optimize, and maintain your WordPress database with ease. Remove revisions, drafts, spam, transients, orphaned data, and unused terms with real-time counts and one-click cleanup.","assets_banners_color":"d4dcef","last_updated":"2026-01-01 18:15:07","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/paypal.me\/kirtikumar89","header_plugin_uri":"","header_author_uri":"https:\/\/profiles.wordpress.org\/solankisoftware\/","rating":5,"author_block_rating":0,"active_installs":10,"downloads":248,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0":{"tag":"1.0","author":"solankisoftware","date":"2026-01-01 18:15:07"}},"upgrade_notice":{"1.0":"

First stable release. Update recommended for better performance and optimized database cleanup.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":1},"assets_icons":{"icon-256x256.png":{"filename":"icon-256x256.png","revision":3400638,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":3400638,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3399939,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3399939,"resolution":"2","location":"assets","locale":""}},"screenshots":{"1":"Dashboard \u2014 Cleanup Tools","2":"Database Table Optimization Interface"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[151,4657,153,1452,247],"plugin_category":[52,54,59],"plugin_contributors":[244270],"plugin_business_model":[],"class_list":["post-262118","plugin","type-plugin","status-publish","hentry","plugin_tags-backup","plugin_tags-clean","plugin_tags-database","plugin_tags-optimize","plugin_tags-performance","plugin_category-performance","plugin_category-security-and-spam-protection","plugin_category-utilities-and-tools","plugin_contributors-solankisoftware","plugin_committers-solankisoftware"],"banners":{"banner":"https:\/\/ps.w.org\/smartpro-database-optimiser-cleaner\/assets\/banner-772x250.png?rev=3400638","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/smartpro-database-optimiser-cleaner\/assets\/icon-256x256.png?rev=3400638","icon_2x":"https:\/\/ps.w.org\/smartpro-database-optimiser-cleaner\/assets\/icon-256x256.png?rev=3400638","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/smartpro-database-optimiser-cleaner\/assets\/screenshot-1.png?rev=3399939","caption":"Dashboard \u2014 Cleanup Tools"},{"src":"https:\/\/ps.w.org\/smartpro-database-optimiser-cleaner\/assets\/screenshot-2.png?rev=3399939","caption":"Database Table Optimization Interface"}],"raw_content":"\n

SmartPro Database Optimiser & Cleaner<\/strong> helps you maintain a faster, cleaner, and more efficient WordPress website by removing unnecessary database clutter and optimizing all database tables.
\nIt features a beautiful modern interface, one-click actions, real-time item counts, and AJAX-powered cleaning for a seamless experience.<\/p>\n\n

This tool also includes an integrated full database backup system<\/strong>, allowing you to download your entire WordPress database in .sql<\/code> format before cleaning.<\/p>\n\n

No technical skills required \u2014 simply open Tools \u2192 SmartPro Database Optimiser & Cleaner<\/strong>, click \u201cClean\u201d, and enjoy improved performance instantly.<\/p>\n\n\n\n

\ud83d\ude80 Key Benefits<\/h3>\n\n
    \n
  • Faster database performance <\/li>\n
  • Reduced storage usage <\/li>\n
  • Ability to safely back up your WordPress database <\/li>\n
  • Clean, modern, user-friendly UI <\/li>\n
  • No page reloads (AJAX-based) <\/li>\n
  • Safe queries using $wpdb<\/code> <\/li>\n
  • No bloat, lightweight, and optimized <\/li>\n<\/ul>\n\n\n\n

    \ud83e\uddf9 Cleanup Features<\/h3>\n\n

    Clean up unnecessary and unused database entries with a single click:<\/p>\n\n

      \n
    • Remove post revisions<\/strong><\/li>\n
    • Delete auto-saved drafts<\/strong><\/li>\n
    • Remove trashed posts<\/strong> and trashed pages<\/strong><\/li>\n
    • Clean spam<\/strong> and trashed comments<\/strong><\/li>\n
    • Remove expired transients<\/strong><\/li>\n
    • Delete all transients<\/strong><\/li>\n
    • Remove orphaned post meta<\/strong><\/li>\n
    • Remove orphaned comment meta<\/strong><\/li>\n
    • Delete orphaned user meta<\/strong><\/li>\n
    • Remove unused tags<\/strong><\/li>\n
    • Delete empty taxonomy terms<\/strong><\/li>\n
    • Optimize all WordPress tables<\/li>\n<\/ul>\n\n

      Each cleanup item displays:\n- Real-time items count<\/strong>\n- Action button<\/strong>\n- Instant results message<\/strong><\/p>\n\n

      Also includes:\n- Clean All<\/strong> button
      \n- Refresh Counts<\/strong> button<\/p>\n\n\n\n

      \ud83d\udee2\ufe0f Database Backup Features<\/h3>\n\n

      Before cleaning, download your full database for safety.<\/p>\n\n

        \n
      • One-click SQL backup download<\/strong><\/li>\n
      • Shows total database size<\/strong><\/li>\n
      • Backups stored in:
        \n \/wp-content\/uploads\/smartpro-database-optimiser-cleaner\/<\/li>\n
      • Backup is generated safely using WordPress standards<\/li>\n<\/ul>\n\n\n\n

        \ud83d\uddc2\ufe0f Database Table Optimization<\/h3>\n\n

        From the Optimize Tables<\/strong> tab, you can:<\/p>\n\n

          \n
        • View every database table <\/li>\n
        • See table size, index size, total size, row count <\/li>\n
        • Optimize each table individually <\/li>\n
        • Or use Optimize All Tables<\/strong><\/li>\n<\/ul>\n\n

          All database optimization is handled using safe, built-in SQL operations.<\/p>\n\n\n\n

          \ud83d\udda5\ufe0f Smart, Modern UI<\/h3>\n\n

          The plugin includes a clean and intuitive interface:<\/p>\n\n

            \n
          • AJAX-powered actions <\/li>\n
          • Smooth progress indicators <\/li>\n
          • Live counts <\/li>\n
          • Field-based table listing <\/li>\n
          • Fully responsive design <\/li>\n
          • Admin-friendly layout <\/li>\n<\/ul>\n\n\n\n

            \ud83d\udd12 Security & Permissions<\/h3>\n\n
              \n
            • Nonce-protected AJAX requests <\/li>\n
            • Sanitized inputs <\/li>\n
            • Works only for administrators <\/li>\n
            • No risky SQL execution <\/li>\n
            • Follows strict WordPress coding standards<\/li>\n<\/ul>\n\n\n
                \n
              1. Upload the plugin folder to the \/wp-content\/plugins\/<\/code> directory <\/li>\n
              2. Activate the plugin through the \u201cPlugins\u201d menu in WordPress <\/li>\n
              3. Go to Tools \u2192 SmartPro Database Optimiser & Cleaner<\/strong> <\/li>\n
              4. Click Refresh Counts<\/strong> <\/li>\n
              5. Clean or optimize the database using the action buttons <\/li>\n<\/ol>\n\n\n
                \n

                \u2753 Is it safe to clean my database?<\/h3><\/dt>\n

                Yes \u2014 all operations use safe WordPress and SQL methods. However, it\u2019s recommended to take a backup using the built-in download tool.<\/p><\/dd>\n

                \u2753 Where are backups stored?<\/h3><\/dt>\n

                Backups are saved inside:
                \n \/wp-content\/uploads\/smartpro-database-optimiser-cleaner\/<\/p><\/dd>\n

                \u2753 Does this plugin work with WooCommerce?<\/h3><\/dt>\n

                Yes. It can clean and optimize WooCommerce database tables safely.<\/p><\/dd>\n

                \u2753 Can this break my site?<\/h3><\/dt>\n

                No. The plugin only removes unnecessary and unused entries. It does not<\/strong> modify posts, pages, users, WooCommerce products, or active content.<\/p><\/dd>\n

                \u2753 Does the plugin use AJAX?<\/h3><\/dt>\n

                Yes \u2014 all cleaning and optimization actions run without page reloads.<\/p>\n\n<\/dd>\n\n<\/dl>\n\n\n

                1.0<\/h4>\n\n
                  \n
                • Initial release <\/li>\n
                • Added full database backup system <\/li>\n
                • Added real-time counts for all cleanup types <\/li>\n
                • Added cleanup tools (revisions, drafts, trash, comments, transients, orphaned meta) <\/li>\n
                • Added table optimization module <\/li>\n
                • Added Clean All and Refresh Counts buttons <\/li>\n
                • Added progress UI and AJAX engine <\/li>\n
                • Stable, optimized, and secure release <\/li>\n<\/ul>","raw_excerpt":"Smart, lightweight tool to clean, optimize, and back up your WordPress database for better speed and performance.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/262118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=262118"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/solankisoftware"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=262118"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=262118"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=262118"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=262118"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=262118"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=262118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}