Fabricio Carella

<p>This plugin will allow you to execute any type of SQL query into the WordPress’s DB connecting through the driver provided by the MySQLi extension without the need to use another tool like phpMyAdmin.</p>
<p>It also gives you the ability to export the results in a CSV format file.</p>
<p>In order to access this plugin’s admin page (Tools -> Run SQL Query), your account needs to have the <code>install_plugins</code> capability, that means a Super Admin in the multi-site installation or an Admin in a single site.</p>
<p>Feel free to contribute:<br />
https://github.com/Sefirost/run-sql-query</p>
<p>Use on you own risk. Under no circumstances will the Author of this plugin assume responsibility or liability for any damages or destructive effects on the database resulting from the queries executed using this tool.</p>


Run SQL Query

Run SQL Query is a simple plugin to quickly execute any type of SQL query into the WordPress's DB and export the results in a CSV format file.

Jacques Malgrange

<p>This lightweight plugin makes it easy to install the millions of GEONAMES Data on your WordPress site.<br />
It allows :</p>
<ul>
<li>Install data from one or more file (place & postal code) ;</li>
<li>Choose column to install to avoid excessive enlargement of the base ;</li>
<li>Choose type of data to install (city, park, road…) ;</li>
<li>Remove all the data.</li>
<li>Check data in the database.</li>
<li>Edit and change datas from Dashboard.</li>
<li>Display the places on OpenStreetMap.</li>
</ul>
<p>A shortcode is also available to create a city region and country taxonomy.</p>
<p>This plugin will give you plenty of ideas to improve the quality of your website.</p>
<p>Official <a href="http://www.geonames.org/" rel="nofollow ugc">GeoNames</a> website.</p>
<h3>1.9.1</h3>
<p>05/12/2024</p>
<ul>
<li>Fix XSS vulnerability in shortcode attributes</li>
<li>Fix translation issue with WP 6.7</li>
</ul>
<h4>1.9</h4>
<p>18/10/2024 – Fix XSS vulnerability on geoSearch field</p>
<h4>1.8</h4>
<p>08/02/2022</p>
<ul>
<li>Update Leaflet 1.7.1.</li>
<li>Update SumoSelect 3.4.2.</li>
<li>Split admin sidet in a specific file.</li>
</ul>
<h4>1.7</h4>
<p>21/03/2020</p>
<ul>
<li>Fix issue with very long line in Geoname DB.</li>
<li>Add nonce.</li>
<li>Braces style standardisation in the code.</li>
</ul>
<h4>1.6</h4>
<p>14/03/2019 – Add Postal code database.</p>
<h4>1.5.1</h4>
<p>27/01/2018 – Curl used by default if exists in place of File_Get_Content.</p>
<h4>1.5</h4>
<p>12/01/2018 – Add tab to edit and change datas.</p>
<h4>1.4</h4>
<p>24/06/2017</p>
<ul>
<li>Add Taxonomy.</li>
<li>Add shortcode to create taxonomy in the site.</li>
<li>Add template to customize the taxonomy form.</li>
<li>Ability to download multiple files in one click.</li>
<li>Check the database with a taxonomy form and display the place on OpenStreetMap.</li>
<li>Multisite.</li>
</ul>
<h4>1.3</h4>
<p>09/10/2015 – Fix “Fatal error: Out of memory (allocated xxx) (tried to allocate xxx bytes)”.</p>
<p>07/06/2016 – 1.3.1 – Fix error when reactivate (header already sent…).</p>
<h4>1.2</h4>
<p>06/08/2015 – Fix installation bug.</p>
<h4>1.1</h4>
<p>01/12/2014 – Add Ajax hook.</p>
<h4>1.0</h4>
<p>25/11/2014 – First stable version.</p>


WP GeoNames

Allows you to insert all or part of the global GeoNames database in your WordPress base.

Run SQL Query vs WP GeoNames