Title: SQL Buddy &#8211; Database Management Made Easy
Author: WP Engine
Published: <strong>2022 年 1 月 12 日</strong>
Last modified: 2025 年 6 月 16 日

---

搜尋外掛

![](https://ps.w.org/sql-buddy/assets/banner-772x250.jpg?rev=2656583)

這個外掛**並未在最新的 3 個 WordPress 主要版本上進行測試**。開發者可能不再對這個
外掛進行維護或提供技術支援，並可能會與更新版本的 WordPress 產生使用上的相容性問題。

![](https://ps.w.org/sql-buddy/assets/icon-256x256.png?rev=2656583)

# SQL Buddy – Database Management Made Easy

 由 [WP Engine](https://profiles.wordpress.org/wpengine/) 開發

[下載](https://downloads.wordpress.org/plugin/sql-buddy.1.0.0.zip)

 * [詳細資料](https://tw.wordpress.org/plugins/sql-buddy/#description)
 * [使用者評論](https://tw.wordpress.org/plugins/sql-buddy/#reviews)
 *  [安裝方式](https://tw.wordpress.org/plugins/sql-buddy/#installation)
 * [開發資訊](https://tw.wordpress.org/plugins/sql-buddy/#developers)

 [技術支援](https://wordpress.org/support/plugin/sql-buddy/)

## 外掛說明

**⚠️ 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.

### 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](https://wordpress.org/plugins/wp-migrate-db/)
and [WP Migrate DB Pro](https://deliciousbrains.com/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.

## 螢幕擷圖

[⌊Dashboard screen⌉⌊Dashboard screen⌉[

Dashboard screen

[⌊Tables screen⌉⌊Tables screen⌉[

Tables screen

[⌊Edit table row screen⌉⌊Edit table row screen⌉[

Edit table row screen

## 安裝方式

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

## 常見問題集

### What support is provided?

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

## 使用者評論

![](https://secure.gravatar.com/avatar/47049d827c71bca5e909113de8e3863f2f139254a9d0edc4bb3c2fd8fbd338f0?
s=60&d=retro&r=g)

### 󠀁[Great plugin for editing records](https://wordpress.org/support/topic/great-plugin-for-editing-records/)󠁿

 [Anton_Th](https://profiles.wordpress.org/anton_th/) 2024 年 8 月 5 日

I have to delete several hundreds of records (all containing ‘acf’). A multi-row
select option would already be enough for me to buy a premium version. Would be 
ideal for cleaning up databases.

![](https://secure.gravatar.com/avatar/cd3ecd85365fe2a81ad9db1428d72a2ba456280583c7ee1dc0eec587e9fbbb8d?
s=60&d=retro&r=g)

### 󠀁[Essential plugin for developers](https://wordpress.org/support/topic/essential-plugin-for-developers-2/)󠁿

 [Ryan Novotny](https://profiles.wordpress.org/ryannovotny/) 2024 年 5 月 24 日

Almost should be part of WP core IMO

![](https://secure.gravatar.com/avatar/527e3b0e474972b74ceddfb6a3aa9e0cec5ee6a9a1903700f1c5f0e13dcf7c51?
s=60&d=retro&r=g)

### 󠀁[Simple and easy DB edits](https://wordpress.org/support/topic/simple-and-easy-db-edits/)󠁿

 [robertstaddon](https://profiles.wordpress.org/robertstaddon/) 2024 年 5 月 17 
日

I was amazed at how simple and easy this plugin makes editing the database right
from your WordPress admin area!

![](https://secure.gravatar.com/avatar/d292174cfce33d6af0c0aa6e8264e0376eb84b0193b34363058a61a4165ec4b6?
s=60&d=retro&r=g)

### 󠀁[This was really needed, great!](https://wordpress.org/support/topic/this-was-really-needed-great/)󠁿

 [dimmez](https://profiles.wordpress.org/dimmez/) 2024 年 4 月 16 日

I was looking for something to correct the data in the options table from the admin
panel. This is exactly what I need!

![](https://secure.gravatar.com/avatar/83f45514b2ea821162d0264cde8bbd75277fa4ad9aca60aea14b0f735fa3d1b4?
s=60&d=retro&r=g)

### 󠀁[Cool plugin!](https://wordpress.org/support/topic/cool-plugin-597/)󠁿

 [Geert Bouckaert](https://profiles.wordpress.org/geert-bouckaert/) 2024 年 2 月
23 日

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?

![](https://secure.gravatar.com/avatar/2ce24492279223e09e666c760384573bc045d78af32a1459b8fcf341f7ab56a1?
s=60&d=retro&r=g)

### 󠀁[So convinient](https://wordpress.org/support/topic/so-convinient/)󠁿

 [Pär Thernström](https://profiles.wordpress.org/eskapism/) 2023 年 10 月 31 日

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…

 [ 閱讀全部 14 則使用者評論 ](https://wordpress.org/support/plugin/sql-buddy/reviews/)

## 參與者及開發者

以下人員參與了開源軟體〈SQL Buddy – Database Management Made Easy〉的開發相關工作。

參與者

 *   [ WP Engine ](https://profiles.wordpress.org/wpengine/)
 *   [ Delicious Brains ](https://profiles.wordpress.org/deliciousbrains/)

〈SQL Buddy – Database Management Made Easy〉外掛目前已有 2 個本地化語言版本。 感謝
[全部譯者](https://translate.wordpress.org/projects/wp-plugins/sql-buddy/contributors)
為這個外掛做出的貢獻。

[將〈SQL Buddy – Database Management Made Easy〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/sql-buddy)

### 對開發相關資訊感興趣？

任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/sql-buddy/)、查看
[SVN 存放庫](https://plugins.svn.wordpress.org/sql-buddy/)，或透過 [RSS](https://plugins.trac.wordpress.org/log/sql-buddy/?limit=100&mode=stop_on_copy&format=rss)
訂閱[開發記錄](https://plugins.trac.wordpress.org/log/sql-buddy/)。

## 變更記錄

#### 1.0.0

Initial release

## 中繼資料

 *  版本 **1.0.0**
 *  最後更新 **1 年前**
 *  啟用安裝數 **5,000+**
 *  WordPress 版本需求 ** 5.3 或更新版本 **
 *  已測試相容的 WordPress 版本 **6.4.8**
 *  PHP 版本需求 ** 5.6 或更新版本 **
 *  語言
 * [English (US)](https://wordpress.org/plugins/sql-buddy/)、[French (France)](https://fr.wordpress.org/plugins/sql-buddy/)、
   及 [Italian](https://it.wordpress.org/plugins/sql-buddy/).
 *  [將這個外掛本地化為你的母語版本](https://translate.wordpress.org/projects/wp-plugins/sql-buddy)
 * 標籤:
 * [database](https://tw.wordpress.org/plugins/tags/database/)[database management](https://tw.wordpress.org/plugins/tags/database-management/)
   [sql](https://tw.wordpress.org/plugins/tags/sql/)
 *  [進階檢視](https://tw.wordpress.org/plugins/sql-buddy/advanced/)

## 評分

 5 星，滿分為 5 星

 *  [  14 個 5 星使用者評論     ](https://wordpress.org/support/plugin/sql-buddy/reviews/?filter=5)
 *  [  0 個 4 星使用者評論     ](https://wordpress.org/support/plugin/sql-buddy/reviews/?filter=4)
 *  [  0 個 3 星使用者評論     ](https://wordpress.org/support/plugin/sql-buddy/reviews/?filter=3)
 *  [  0 個 2 星使用者評論     ](https://wordpress.org/support/plugin/sql-buddy/reviews/?filter=2)
 *  [  0 個 1 星使用者評論     ](https://wordpress.org/support/plugin/sql-buddy/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/sql-buddy/reviews/#new-post)

[查看全部使用者評論](https://wordpress.org/support/plugin/sql-buddy/reviews/)

## 參與者

 *   [ WP Engine ](https://profiles.wordpress.org/wpengine/)
 *   [ Delicious Brains ](https://profiles.wordpress.org/deliciousbrains/)

## 技術支援

使用者可在技術支援論壇提出意見反應或使用問題。

 [檢視技術支援論壇](https://wordpress.org/support/plugin/sql-buddy/)