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
- Upload the plugin to
/wp-content/plugins/or install via the WP admin panel. - Activate the plugin from the Plugins menu.
- 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 TABLEwhere supported. -
Can I remove autoloaded options?
-
Yes, you can toggle the autoload flag for individual
wp_optionsentries.
Reviews
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.
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.
Contributors & Developers
“atec Database” is open source software. The following people have contributed to this plugin.
Contributors
Translate “atec Database” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
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