Bill Erickson

This plugin extends <a href="https://wordpress.org/plugins/display-posts-shortcode" rel="ugc">Display Posts</a> by letting you break your content down by month or year. You can use all of the <a href="https://displayposts.com/docs/parameters/" rel="nofollow ugc">Display Posts parameters</a> to customize the query.
Month Listing
<pre><code>[display-posts display_by_month="true" posts_per_page="999" title="Posts by Month"]
</code></pre>
Use the <code>display_by_month</code> parameter to break it down by month. To list all your content, use a high <code>posts_per_page</code>, like 999. You can also add an optional <code>title</code> to appear above the listing.
Year Listing
<pre><code>[display-posts display_by_year="true" posts_per_page="999" title"Posts by Year"]
</code></pre>
Use the <code>display_by_month</code> parameter to break it down by year. To list all your content, use a high <code>posts_per_page</code>, like 999. You can also add an optional <code>title</code> to appear above the listing.
Filters
If you’re a developer, you can use the following filters to customize the markup:
<ul>
<li><code>display_posts_date_view_heading_tag</code> – The heading tag used for date headings. Default is h4.</li>
<li><code>display_posts_date_view_heading_class</code> – The class added to the heading tag. Default is .display-posts-date.</li>
<li><code>display_posts_date_view_month_format</code> – The date format used for month headings. Default is ‘F Y’.</li>
<li><code>display_posts_date_view_year_format</code> – The date format used for year headings. Default is ‘Y’.</li>
</ul>

Display Posts – Date View

List your content broken down by month or year. This is an extension of the Display Posts plugin.

Olar Marius

Justin Watt

Instead of needing a tool like <a href="http://www.phpmyadmin.net/home_page/index.php" rel="nofollow ugc">phpMyAdmin</a> 
or the mysql command line client to view and modify your WordPress database, 
the SQL Executioner allows you to run arbitrary SQL queries against your 
WordPress database from within the Admin. In many cases this allows you to bypass 
the inherent limitations of the WordPress Admin interface, and use the full expressive 
power of SQL to analyze and update your blog’s database.
To use simply install and visit the Tools > SQL Executioner page.
If you’re interested in contributing to the code behind this plugin, it’s also hosted on GitHub: 
https://github.com/justincwatt/wp-sql-executioner

SQL Executioner

This plugin seems to me simple but very useful.

Simple and efficient

I use this plugin on a daily basis to run quick queries in the database while developing. Very very helpful!!!

Amazing Tool

Execute arbitrary SQL queries against your WordPress database from the Admin.

Display Posts – Date View vs SQL Executioner