SQL Buddy – Database Management Made Easy

Descripción

Your one-stop solution for WordPress database management. Edit your table data with a clean and straightforward user interface.

SQL Buddy is a WordPress plugin that makes it easy to manage your database table contents right from your WordPress dashboard.

The Dashboard screen gives you a detailed overview of all your WordPress tables, along with useful data like the number of records, and the size of the table.

The Tables screen allows you to search for a specific table, or view the table rows. Clicking on a row presents options to edit and save the column values, or delete the row. You are also able to control which table columns to display, as well as options to filter the table data.

Each screen has pagination controls for navigating through a large number of tables or rows.

Features

  • View a list of all your database tables, including details like number of records, data usage, and index usage per table.
  • Navigate through table records quickly, or search for specific tables by name.
  • Filter table records using custom query conditions
  • Choose which table columns to display on a per-table basis
  • View the full contents of a single table record with one click.
  • Easily edit the record contents or delete a table record

Why Use a Database Management Plugin?

While not common, there are often situations where you might need to make changes to your WordPress database. Perhaps you’ve moved from a staging environment to live, and you need to update your site URL, or you need to clean up some data left behind by a deleted plugin. Whatever the reason, a solid solution for browsing and editing your WordPress database is a vital tool in any site owner’s belt.

You could use the database management tool your web host provides, which is typically based on PHPMyAdmin, but the user interface is clumsy and not all that intuitive. You could try an application like Navicat, SQLyog, or TablePlus, but these require you to know your database access credentials.

SQL Buddy is the WordPress plugin that gives you the ability to manage your database directly from your WordPress dashboard, without needing to worry about database credentials, installing third-party applications, or navigating a confusing user interface.

Built by WordPress Database Experts

We’re Delicious Brains, the team behind WP Migrate DB and WP Migrate DB Pro. For the last 15 years, we’ve helped WordPress developers migrate their database, site files and themes, and plugins between multiple different environments. We pride ourselves on being WordPress database experts, so you don’t have to be.

SQL Buddy is everything we require from a WordPress database management plugin. A beautiful, intuitive interface, coupled with straightforward yet powerful features.

Capturas

  • Dashboard screen
  • Tables screen
  • Edit table row screen

Instalación

From your WordPress dashboard

  1. Visit Plugins > Add New
  2. Search for «SQL Buddy»
  3. Install and Activate SQL Buddy from your Plugins page
  4. Click on SQL Buddy in the «Tools» menu item, to manage your database

Preguntas frecuentes

What support is provided?

Limited free support is provided through the WordPress.org support forums

Reseñas

23 de febrero de 2024
Very nice, easy plugin.Now, I don't have to switch to phpmyadmin anymore. I wonder, would it be possible to also add the function to add records in a chosen table?
31 de octubre de 2023
This is a very nice and easy to use tool that I install on my local dev sites. Especially useful when using Docker or similar because I can't keep track of all exposed MariaDB-ports...
12 de octubre de 2023
Wonder why not making a pro version, its so good. Here is a snippet I made, to add a couple features I needed 1. it adds a modal button so its easier to edit data and 2. it starts with a default filter (manually replace the wp_jet_cctin the code with your value). Absolutely untested. Would be nice to be able to jump from one field to another by pressing arrows. add_action('admin_footer', 'my_sql_buddy_script'); function my_sql_buddy_script() { $current_screen = get_current_screen(); // Only run the script on the specific admin page if ($current_screen->base === 'tools_page_sql-buddy-dashboard') { ?> <style> .modal { display: none; position: fixed; top: 0; left: 0; width: 100%; height: 100%; background-color: rgba(0, 0, 0, 0.7); z-index: 9999; } .modal-content { position: relative; margin: auto; top: 50px; width: 65%; max-height: calc(100% - 100px); overflow: auto; background-color: white; border: 2px solid #ccc; padding: 20px; } </style> <script type="text/javascript"> jQuery(document).ready(function($) { let isModal = false; const checkForDivs = () => { const sideDrawerDiv = $('.SideDrawer__Drawer-sc-e94xql-0.bJHKLb'); const innerDiv = $('.inner'); if (sideDrawerDiv.length && innerDiv.length) { if (sideDrawerDiv.find('button.open-modal').length === 0 && !isModal) { addOpenButton(sideDrawerDiv); } } }; const addOpenButton = (targetDiv) => { const openButton = $('<button class="open-modal">Open Modal</button>'); openButton.click(openModal); targetDiv.prepend(openButton); }; const addCloseButton = (targetDiv) => { const closeButton = $('<button>Close Modal</button>'); closeButton.click(closeModal); targetDiv.prepend(closeButton); }; const openModal = () => { $('button.open-modal').remove(); $('body').append('<div class="modal"><div class="modal-content"></div></div>'); $('.modal-content').html($('.SideDrawer__Drawer-sc-e94xql-0.bJHKLb').html()); addCloseButton($('.modal-content')); $('.modal').show(); $(document).on('keydown', handleEscape); $('.modal').on('click', handleClickOutside); isModal = true; }; const closeModal = () => { $('.modal').remove(); $(document).off('keydown', handleEscape); isModal = false; checkForDivs(); }; const handleEscape = (e) => { if (e.key === 'Escape') { closeModal(); } }; const handleClickOutside = (e) => { if ($(e.target).hasClass('modal')) { closeModal(); } }; const modalInterval = setInterval(checkForDivs, 500); let interval; const checkForInput = () => { const inputElement = document.querySelector('input[type="text"][placeholder="Search for table…"]'); if (inputElement) { console.log('Input element found.'); if (inputElement.value !== 'wp_jet_cct') { let nativeInputValueSetter = Object.getOwnPropertyDescriptor(window.HTMLInputElement.prototype, "value").set; nativeInputValueSetter.call(inputElement, 'wp_jet_cct'); let inputEvent = new Event('input', { bubbles: true }); inputElement.dispatchEvent(inputEvent); console.log('Value set and React input event triggered.'); clearInterval(interval); } } else { console.log('Input element not found.'); } }; interval = setInterval(checkForInput, 500); }); </script> <?php } }
3 de octubre de 2022
This plugin performs a crucial service missing from WordPress itself: the ability to visualize the database, and make changes. I can't stress enough that this plugin is not for folks who have are beginners or otherwise not familiar with WordPess databases, but for those who are, this plugin can shave hours off of troubleshooting problems by letting you see directly into the data.
15 de septiembre de 2022
I came across this plugin in watching an unrelated presentation and was curious, as I often find myself using phpMyAdmin, or another tool to see the database content related to my sites. Right away I am impressed with the simplicity and ease of accessing, with the option to make quick updates (just be careful what you change, eh, as with great power comes great responsibility). Great work. Great plugin.
Leer todas las 10 reseñas

Colaboradores y desarrolladores

«SQL Buddy – Database Management Made Easy» es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Colaboradores

«SQL Buddy – Database Management Made Easy» ha sido traducido a 2 idiomas locales. Gracias a los traductores por sus contribuciones.

Traduce «SQL Buddy – Database Management Made Easy» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

1.0.0

Initial release