PHPackages                             vse/dbtool - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. vse/dbtool

ActivePhpbb-extension[Database & ORM](/categories/database)

vse/dbtool
==========

A phpBB extension that allows you to check, optimize and repair phpBB's MySQL database tables from a phpMyAdmin-like interface in the Administration Control Panel or from the CLI.

1.2.2(6mo ago)9608GPL-2.0-onlyPHPPHP >=5.4CI passing

Since Jun 7Pushed 3mo ago2 watchersCompare

[ Source](https://github.com/iMattPro/dbtool)[ Packagist](https://packagist.org/packages/vse/dbtool)[ Docs](https://github.com/iMattPro/dbtool)[ RSS](/packages/vse-dbtool/feed)WikiDiscussions master Synced today

READMEChangelog (9)Dependencies (2)Versions (11)Used By (0)

[![alt text](https://camo.githubusercontent.com/bdf3084c234fa180b4a9dfc74c3f19eac5abb21b81dcbf0d5584b32d927a8b0e/68747470733a2f2f696d61747470726f2e6769746875622e696f2f6c6f676f2f64617461626173655f636865636b5f312e706e67 "DB Tool")](https://camo.githubusercontent.com/bdf3084c234fa180b4a9dfc74c3f19eac5abb21b81dcbf0d5584b32d927a8b0e/68747470733a2f2f696d61747470726f2e6769746875622e696f2f6c6f676f2f64617461626173655f636865636b5f312e706e67) Database Optimize & Repair Tool for phpBB
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[](#-database-optimize--repair-tool-for-phpbb)

A phpBB extension that will allow you to check, optimize and repair phpBB's MySQL database tables in the Administration Control Panel or from the Command Line Interface.

[![Build Status](https://github.com/iMattPro/dbtool/actions/workflows/tests.yml/badge.svg)](https://github.com/iMattPro/dbtool/actions)[![codecov](https://camo.githubusercontent.com/67def1ae69b0b50795313cd7ff93c3e335af6c57787377b98c69678a445e2451/68747470733a2f2f636f6465636f762e696f2f67682f694d61747450726f2f6462746f6f6c2f6272616e63682f6d61737465722f67726170682f62616467652e7376673f746f6b656e3d686c4d6e4774537a6845)](https://codecov.io/gh/iMattPro/dbtool)[![Maintainability](https://camo.githubusercontent.com/ab9b0888df759539c9f86f261c3dbe50d03a4a496481b0b7a4ffd57e104aa70b/68747470733a2f2f716c74792e73682f6261646765732f36366130613831332d343833342d343137352d386566632d3462366230343631643033352f6d61696e7461696e6162696c6974792e737667)](https://qlty.sh/gh/iMattPro/projects/dbtool)[![Latest Stable Version](https://camo.githubusercontent.com/cf15ddfe40f2ec7bb05d7b804eb08c772ca9c849ad3f6a5c1e82b95a582c9c50/68747470733a2f2f706f7365722e707567782e6f72672f7673652f6462746f6f6c2f762f737461626c65)](https://www.phpbb.com/customise/db/extension/database_optimize_and_repair_tool/)

Features
--------

[](#features)

- Optimize, Repair, and Check tables directly from the ACP or the CLI
- Select individual tables or all tables at once
- Displays table size and table overhead values in the ACP
- Option to safely disable board during the optimize/repair process
- Results are logged to the Admin log
- Enhanced JavaScript interactions

Minimum Requirements
--------------------

[](#minimum-requirements)

- phpBB 3.2.0
- PHP 5.4 or higher
- MySQL 4.0.1 or higher (using MyISAM, InnoDB or Archive table types)

Install
-------

[](#install)

1. [Download the latest validated release](https://www.phpbb.com/customise/db/extension/database_optimize_and_repair_tool/).
2. Unzip the downloaded release and copy it to the `ext` directory of your phpBB board.
3. Navigate in the ACP to `Customise -> Manage extensions`.
4. Find `Database Optimize & Repair Tool` under Disabled Extensions and click `Enable`.

Usage
-----

[](#usage)

After installation, you can find the Optimize & Repair Tool in:

`ACP -> Maintenance -> Database -> Optimize & Repair`.

> Use this extension at your own risk! There have been cases with certain shared web hosts where a database table could crash for a huge forum. This extension will perform the same functions on your database as phpMyAdmin, so if you have been using phpMyAdmin on your database with no problems, then it should be safe to use this extension. It is always safest to run a backup of your database before performing any Optimize or Repair functions just in case anything goes wrong.

> Note: InnoDB table types do not support the Repair option.

CLI Usage
---------

[](#cli-usage)

The Optimize & Repair Tool can also be run from the command line interface in phpBB using the `db:tool` command. The tool will prompt you to choose an operation: Optimize, Repair, or Check.

To check, optimize, or repair all tables:

```
php bin/phpbbcli.php db:tool
```

To check, optimize, or repair a specific table:

```
php bin/phpbbcli.php db:tool table_name
```

To disable the board during an operation, use the `--disable-board` or `-D` option:

```
php bin/phpbbcli.php db:tool --disable-board
```

To see help for the Optimize & Repair Tool command:

```
php bin/phpbbcli.php db:tool --help
```

Uninstall
---------

[](#uninstall)

1. Navigate in the ACP to `Customise -> Manage extensions`.
2. Click the `Disable` link for Database Optimize & Repair Tool.
3. To permanently uninstall, click `Delete Data`, then delete the `dbtool` folder from `phpBB/ext/vse/`.

License
-------

[](#license)

[GNU General Public License v2](https://opensource.org/licenses/GPL-2.0)

© 2013 - Matt Friedman

###  Health Score

46

—

FairBetter than 92% of packages

Maintenance75

Regular maintenance activity

Popularity18

Limited adoption so far

Community18

Small or concentrated contributor base

Maturity64

Established project with proven stability

 Bus Factor1

Top contributor holds 93.2% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~528 days

Recently: every ~819 days

Total

9

Last Release

181d ago

PHP version history (2 changes)1.1.0-b1PHP >=5.3.3

1.2.0PHP >=5.4

### Community

Maintainers

![](https://www.gravatar.com/avatar/f27058bb08dbf78f4871638ee8b4a7367938147dc0ee2f6fe9fbc7f9fa945759?d=identicon)[MattF](/maintainers/MattF)

---

Top Contributors

[![iMattPro](https://avatars.githubusercontent.com/u/303711?v=4)](https://github.com/iMattPro "iMattPro (289 commits)")[![Galixte](https://avatars.githubusercontent.com/u/7478287?v=4)](https://github.com/Galixte "Galixte (14 commits)")[![momo-i](https://avatars.githubusercontent.com/u/114382?v=4)](https://github.com/momo-i "momo-i (2 commits)")[![alhitary](https://avatars.githubusercontent.com/u/9897472?v=4)](https://github.com/alhitary "alhitary (2 commits)")[![KotM](https://avatars.githubusercontent.com/u/4082879?v=4)](https://github.com/KotM "KotM (1 commits)")[![phpbb-es](https://avatars.githubusercontent.com/u/516656?v=4)](https://github.com/phpbb-es "phpbb-es (1 commits)")[![vchirikov](https://avatars.githubusercontent.com/u/40987940?v=4)](https://github.com/vchirikov "vchirikov (1 commits)")

---

Tags

phpbb-extensiondatabasemysqlphpbbextensionphpmyadminoptimizerepair

### Embed Badge

![Health badge](/badges/vse-dbtool/health.svg)

```
[![Health](https://phpackages.com/badges/vse-dbtool/health.svg)](https://phpackages.com/packages/vse-dbtool)
```

###  Alternatives

[helsingborg-stad/municipio

A bootstrap theme for creating municipality sites.

4028.5k10](/packages/helsingborg-stad-municipio)[olliejones/index-wp-mysql-for-speed

Speed up your WordPress site by adding high-performance keys (database indexes) to your MySQL database tables.

1491.9k](/packages/olliejones-index-wp-mysql-for-speed)[rah/danpu

Zero-dependency MySQL dump library for easily exporting and importing databases

62414.3k11](/packages/rah-danpu)[moharrum/laravel-adminer

Adminer database management tool for your Laravel application.

451.0k](/packages/moharrum-laravel-adminer)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)