badasswp

This plugin helps you migrate legacy SQL database tables to WordPress’ Custom Post Types (CPT). It provides a user-friendly UI interface that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.
If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!
<h4>✔️ Features</h4>
Our plugin comes with everything you need to easily migrate SQL tables to CPTs.
✔️ Import & Convert to CPT feature. 
✔️ Quick & Lightening Fast uploads. 
✔️ Friendly, User Interface (UI). 
✔️ Custom Post Type Capabilities. 
✔️ Error Loggging Capabilities. 
✔️ Custom Hooks to help you customize plugin behaviour. 
✔️ Available in mutiple langauges such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages. 
✔️ Backward compatible, works with most WP versions.
<h4>✨ Getting Started</h4>
Head over to the SQL to CPT options page. Upload an SQL file of your choice by clicking on the Import SQL File. This would analyse your SQL table and show you the table name and table columns you are about to import. Once ready, click on the Convert to CPT button to complete the process.
On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!
You can get a taste of how this works, by using the <a href="https://tastewp.com/create/NMS/8.0/6.7.0/sql-to-cpt/twentytwentythree?ni=true&origin=wp" rel="nofollow ugc">demo</a> link.
<h4>⚡ Why SQL to CPT ?</h4>
<ol>
<li>Because you need something that works great and fast!</li>
<li>Because you want to port your data across platforms easily.</li>
<li>Because you don’t want to spend hours building custom software for this.</li>
<li>Because you think SQL to CPT is cool.</li>
</ol>
NB: At the moment, the SQL to CPT plugin currently does not provide a way for users to import more than one SQL table at a time, this feature should be available in future releases as well as the option to remove unused CPTs.
<h4>🔌🎨 Plug and Play or Customize</h4>
The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.
Want to add your personal touch? All of our documentation can be found <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">here</a>. You can override the plugin’s behaviour with custom logic of your own using <a href="https://github.com/badasswp/sql-to-cpt?tab=readme-ov-file#hooks" rel="nofollow ugc">hooks</a>.
<h3>Contribute</h3>
If you’d like to contribute to the development of this plugin, you can find it on <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">GitHub</a>.
To build, clone repo and run <code>yarn install && yarn build</code>

SQL To CPT

Import & Convert SQL tables to Custom Post Types (CPT). Migrate legacy SQL table data to WordPress custom post types of your choice. It's super fast!

Delicious Brains

Brad Touesnard

⚠️ WARNING
SQL Buddy is no longer actively maintained.
This software is still free to use under the license provided, but users should be aware that it is not currently maintained. No additional releases, including security releases, will be made available.
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.
<h3>Features</h3>
<ul>
<li>View a list of all your database tables, including details like number of records, data usage, and index usage per table.</li>
<li>Navigate through table records quickly, or search for specific tables by name.</li>
<li>Filter table records using custom query conditions</li>
<li>Choose which table columns to display on a per-table basis</li>
<li>View the full contents of a single table record with one click.</li>
<li>Easily edit the record contents or delete a table record</li>
</ul>
<h3>Why Use a Database Management Plugin?</h3>
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.
<h3>Built by WordPress Database Experts</h3>
We’re Delicious Brains, the team behind <a href="https://wordpress.org/plugins/wp-migrate-db/" rel="ugc">WP Migrate DB</a> and <a href="https://deliciousbrains.com/wp-migrate-db-pro/" rel="nofollow ugc">WP Migrate DB Pro</a>. 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.

SQL Buddy – Database Management Made Easy

I've used a couple of manage-your-database-inside-the-WordPress-dashboard type plugins before. They're really handy for things like changing the admin email when the previous admin has long since disappeared and you can't confirm the email address for the change. Delighted to see this plugin from the Delicious Brains team - they're plugins are superb, reliable, and trustworthy - exactly what you want when you need a plugin to modify your database. The plugin is simple and really easy to use. No nonsense. Will add this plugin to my favourites.

Easy to use plugin by a trusted developer

This is an excellent plugin if you need quick access to the database to make small changes when developing your WordPress site. The UI is snappy and very easy to use. Normally I'd be concerned with security with a plugin like this, but I can't think of a team I trust more than Delicious Brains to build a secure and easy-to-use database plugin for WordPress. They know their stuff.

Easy, fast, reliable

Very nice!

Awesome!

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. 

Simple and powerful


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...


So convinient

Essential plugin for developers

Your one-stop solution for easy WordPress database management

SQL To CPT vs SQL Buddy – Database Management Made Easy