Title: atec Database Author: docjojo Published: October 19, 2024 Last modified: March 24, 2026 --- Search plugins ![](https://ps.w.org/atec-database/assets/banner-772x250.png?rev=3172292) ![](https://ps.w.org/atec-database/assets/icon.svg?rev=3172104) # atec Database By [docjojo](https://profiles.wordpress.org/docjojo/) [Download](https://downloads.wordpress.org/plugin/atec-database.1.1.34.zip) * [Details](https://pcd.wordpress.org/plugins/atec-database/#description) * [Reviews](https://pcd.wordpress.org/plugins/atec-database/#reviews) * [Installation](https://pcd.wordpress.org/plugins/atec-database/#installation) * [Development](https://pcd.wordpress.org/plugins/atec-database/#developers) [Support](https://wordpress.org/support/plugin/atec-database/) ## Description atec Database is a powerful plugin that gives you full control over your WordPress database. Features include: * List all database tables with info (size, type, engine, rows)* Optimize, truncate, or drop any table * Clean up spam comments, trashed posts/pages, post revisions, and expired transients * Browse and manage `wp_options` entries * Set or unset autoload flag per option This plugin is lightweight and safe — all destructive actions require confirmation. ### Specifications * Database access: Uses core WPDB methods ### Third-Party Services ### Integrity check Once, when activating the plugin, an integrity check is requested from our server– if you give your permission. Source: https://atecplugins.com/ Privacy policy: https:// atecplugins.com/privacy-policy/ ## Screenshots * [[ * All tables * [[ * Comments * [[ * Posts * [[ * Revisions * [[ * Transients * [[ * Options * [[ * Individual table ## Installation 1. Upload the plugin to `/wp-content/plugins/` or install via the WP admin panel. 2. Activate the plugin from the Plugins menu. 3. Select “atec Database” link in admin menu bar. ## FAQ ### Can I break my database with this? Only if you drop essential tables. Be cautious with destructive operations like DROP or TRUNCATE. ### Does this plugin optimize InnoDB tables? Yes. It uses `OPTIMIZE TABLE` where supported. ### Can I remove autoloaded options? Yes, you can toggle the autoload flag for individual `wp_options` entries. ## Reviews ![](https://secure.gravatar.com/avatar/d49c6f2c9c97d616e262c19b80ac95ce47ae471ef39684a0bdccdeacd35011c2? s=60&d=retro&r=g) ### 󠀁[A hidden gem to maintain your WordPress database](https://wordpress.org/support/topic/a-hidden-gem-to-maintain-your-wordpress-database/)󠁿 [Boston Tom](https://profiles.wordpress.org/tneveu/) July 16, 2025 1 reply The atec Database plugin is a fantastic little tool that saved me hours of frustration. After trying several other database management plugins—some of which caused more harm than good—atec came to the rescue. With just one click, it cleared over 7,000 post revisions that were bloating my database. The tabbed interface makes it easy to navigate between cleanup tasks, from optimizing tables to fixing indexes and cleaning up comments. You can search, multi-select, and trash orphaned items, and more—no more going into your hosting company’s control panel and using the cumbersome PHPMyAdmin. It even helped me remove leftover clutter from plugins I’d tried once and forgotten about. And for advanced users, there’s an option to run SQL commands directly or upload SQL files. Deleting transients and fixing auto-loaded options is a snap. If you’re relatively new to WordPress databases, atec Database is a safe, user-friendly way to optimize your site. Always make a backup of your DB (it’s good practice) before doing major cleaning. While the plugin is free, the “Pro” version unlocks a ton of extra features. Even better, it gives you access to the Pro versions of over 45 atec plugins via the Deploy plugin. You’ll need to explore their site to see how much is included. The coding genius behind the plugins is incredibly responsive and helpful and is an email away, whether through the plugin support page or their site. And be sure to check out the caching plugins. My site speed improved by over 500%! Can’t beat that for the price. ![](https://secure.gravatar.com/avatar/c131d1fc640702864679d342c9b3ce585db4e8c0afd4c14cc676cdf864de6006? s=60&d=retro&r=g) ### 󠀁[Everything you need](https://wordpress.org/support/topic/everything-you-need-55/)󠁿 [docjojo](https://profiles.wordpress.org/docjojo/) October 19, 2024 Plugin has everything you need to manage, clean up and optimize the WP tables.- List all tables with table info (size, type, engine and number of items).- Optimize, truncate or drop tables.- Delete SPAM in comments, trashed pages/posts, revisions and timed out transients.- List all options and selectively remove some and set autoload option.Well-arranged features, fast and reliable – no gimmicks. [ Read all 2 reviews ](https://wordpress.org/support/plugin/atec-database/reviews/) ## Contributors & Developers “atec Database” is open source software. The following people have contributed to this plugin. Contributors * [ docjojo ](https://profiles.wordpress.org/docjojo/) [Translate “atec Database” into your language.](https://translate.wordpress.org/projects/wp-plugins/atec-database) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/atec-database/), check out the [SVN repository](https://plugins.svn.wordpress.org/atec-database/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/atec-database/) by [RSS](https://plugins.trac.wordpress.org/log/atec-database/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 1.1.34 [2026.03.23] * Dashboard undefined issue #### 1.1.33 [2025.12.09] * WP 6.9 tested #### 1.1.32 [2025.12.06] * Minor fixes #### 1.1.31 [2025.12.02] * WP 6.9 tested #### 1.1.30 [2025.12.02] * WP 6.9 tested #### 1.1.29 [2025.11.04] * SVN cleanup #### 1.1.28 [2025.09.27] * Plugin prefix fixed for all #### 1.1.27 [2025.09.09] * Fixed get_plugin_base_root on WIN #### 1.1.26 [2025.08.10] * SVN update and WP clean upload #### 1.1.25 [2025.08.06] * get_plugin_base_root 👈 one level up #### 1.1.24 [2025.08.06] * Fixed get_plugin_base_root on WIN #### 1.1.23 [2025.08.03] * Changes after review #### 1.1.22 [2025.07.30] * WP_PLUGIN_DIR #### 1.1.21 [2025.07.23] * Line 424 in INIT fixed #### 1.1.20 [2025.07.22] * SVN update #### 1.1.19 [2025.07.19] * Framework changes, new ALIAS class #### 1.1.18 [2025.07.09] * $is_table #### 1.1.17 [2025.07.08] * Revisions: $max_age #### 1.1.16 [2025.07.08] * CAST revision age #### 1.1.13 [2025.07.03] * Framework change: Dashboard, SVG #### 1.1.12 [2025.06.28] * Framework change: progress(); ALIAS class #### 1.1.11 [2025.06.26] * Framework change: Removed mixed …$args #### 1.1.10 [2025.06.26] * Framework change, admin_debug_all() #### 1.1.9 [2025.06.25] * New SQL Tab #### 1.1.8 [2025.06.24] * Framework change | License check improved #### 1.1.7 [2025.06.20] * Minor fixes #### 1.1.6 [2025.06.19] * Fixed LOADER for windows #### 1.1.5 [2025.06.19] * fixed flush() #### 1.1.4 [2025.06.19] * normalize_path #### 1.1.3 [2025.06.18] * Nonce issus fixed #### 1.1.2 [2025.06.17] * SVN Update #### 1.1.1 [2025.06.17] * Integrity Fix #### 1.1.0 [2025.06.15] * AWF NextStep #### 1.0.55 [2025.06.15] * Framework change #### 1.0.54 [2025.05.30] * AWF update #### 1.0.40 [2025.05.29] * Framework: New DASHBOARD, removed WIDGET #### 1.0.39 [2025.05.23] * Framework testing #### 1.0.38 [2025.05.15] * new autoloader #### 1.0.37 [2025.05.03] * INIT::maybe_load_assets(**DIR**, \’atec_wpdp\’); #### 1.0.36 [2025.04.30] * AWF now fully namespaced #### 1.0.34 [2025.04.23] * NAMESPACE implemented #### 1.0.33 [2025.04.06] * Framework change #### 1.0.32 [2025.03.28] * class:: fix #### 1.0.31 [2025.03.18] * Added Indexes #### 1.0.30 [2025.03.16] * New style.css and check.css #### 1.0.29 [2025.03.04] * Framework changes #### 1.0.28 [2025.02.15] * (function() { #### 1.0.27 [2025.02.10] * New atec-fs filesystem #### 1.0.26 [2025.02.03] * Updated atec-check.js #### 1.0.25 [2025.02.02] * Framework changes (atec-check) #### 1.0.24 [2025.01.29] * define(\’ATEC_TOOLS_INC\’,true); // just for backwards compatibility #### 1.0.23 [2025.01.26] * switched require_once -> require #### 1.0.22 [2025.01.17] * Check button replaced #### 1.0.21 [2025.01.16] * SVN cleanup #### 1.0.20 [2025.01.08] * Added \”delete\” for table row #### 1.0.19 [2024.12.24] * Fixed style sheet #### 1.0.18 [2024.12.21] * Fixed: atec-wpdb-del-timedout.php not found #### 1.0.17 [2024.12.21] * Clean up #### 1.0.15 [2024.12.21] * New styles, cleaned up .svg #### 1.0.14 [2024.12.17] * Fixed sanitize_text_field($id) #### 1.0.13 [2024.12.07] * Framework update #### 1.0.12 [2024.12.01] * New Column CHECK TABLE #### 1.0.11 [2024.11.27] * Improved plugin activation routine #### 1.0.10 [2024.11.22] * Optimized atec-*-install.php routine #### 1.0.9 [2024.11.24] * remove options with plugin selection #### 1.0.6, 1.0.7, 1.0.8 [2024.10.19] * review – license #### 1.0.3 [2024.09.08] * Options * Tables_in_wordpress fix #### 1.0.2 [2024.08.09] * review #### 1.0.1 [2024.08.03] * Pagination #### 1.0 [2024.08.02] * Initial Release ## Meta * Version **1.1.34** * Last updated **2 weeks ago** * Active installations **90+** * WordPress version ** 4.9 or higher ** * Tested up to **6.9.4** * PHP version ** 7.4 or higher ** * Language * [English (US)](https://wordpress.org/plugins/atec-database/) * Tags * [cleanup](https://pcd.wordpress.org/plugins/tags/cleanup/)[database](https://pcd.wordpress.org/plugins/tags/database/) [Optimize](https://pcd.wordpress.org/plugins/tags/optimize/)[wp db](https://pcd.wordpress.org/plugins/tags/wp-db/) [wp options](https://pcd.wordpress.org/plugins/tags/wp-options/) * [Advanced View](https://pcd.wordpress.org/plugins/atec-database/advanced/) ## Ratings 5 out of 5 stars. * [ 2 5-star reviews ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/atec-database/reviews/?filter=1) [Add my review](https://wordpress.org/support/plugin/atec-database/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/atec-database/reviews/) ## Contributors * [ docjojo ](https://profiles.wordpress.org/docjojo/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/atec-database/)