WPDB Power Tool Database Plugin

The WPDB Power Tool is a Plugin utility to allow you to quickly perform database table work on a WordPress database. View and backup WordPress database tables. As well as build functional stored procedures. It also attempts to be a tutorial as you work providing tips in each step for the beginner to intermediate.

It was designed and built with consideration for the database student and WordPress plugin developer. As well as the WordPress site Administrator, the curious hacker and troubleshooter. It was Developed as a result of a software developer getting tired of all the steps needed to get to the database at times and noticing there was not a tool yet that could be downloaded at the WordPress plugin site.

The three main Power Tools, Reference and Instructions

The open source version of WPDB Power Tool has four main sections. The WPDB Tables that allows you to see all of the tables in your WordPress database. The size of the tables and the structure. It also lets you sample the most recent 500 rows of data in over 95% of the tables. The second section is the Query Tool that tracks all of your queries and allows you to run any SQL statement you like. The Stored Procedure section is for developing and testing stored procedures. Then the Instructions section which walks you through all of the features of each tool.

Advantages to the WPDB Power Tool

  • Backup tables prior to updating them with a sql query
  • Remove tables that got left behind from plugins that were deleted
  • See how big your tables are and if they need maintenance
  • Run SQL against any of the WordPress tables or tables in the WordPress website
  • Learn how to build stored procedures and edit them
  • Implement your stored procedures in the WordPress website for easy maintenance
  • Create your own Insert, Select update and Delete sql while all of you sql statements are recorded and tracked for latter use or modification
  • View numerous Stored Procedure Examples
  • Code examples on how to implement Stored procedures provided.
  • You can now access all tables right through you WordPress Admin without the need for phpMyAdmin or MySQL Workbench
  • Tutorials and examples to get you up and running immediately!