PHPackages                             idealogica/db-truncate - 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. idealogica/db-truncate

ActiveLibrary[Database & ORM](/categories/database)

idealogica/db-truncate
======================

Truncates MySql database tables to specified number of rows.

1.0.2(9y ago)158MITPHPPHP >=5.3

Since Oct 27Pushed 9y ago1 watchersCompare

[ Source](https://github.com/idealogica/db-truncate)[ Packagist](https://packagist.org/packages/idealogica/db-truncate)[ Docs](https://github.com/idealogica/db-truncate)[ RSS](/packages/idealogica-db-truncate/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (4)Used By (0)

db-truncate
===========

[](#db-truncate)

db-truncate truncates MySql database tables to specified number of rows. It's useful for developing purposes when you want to reduce database size and preserve its structure.

### Installation

[](#installation)

db-truncate requires PHP >= 5.3

```
composer global require idealogica/db-truncate:~1.0.0

```

### Usage

[](#usage)

```
db-truncate [-u username (root)] [-p password] [-h host (localhost)] [-P port] [-S unix socket] [-e comma-separated tables to exclude (changelog)] database [records to keep (500)]

```

### License

[](#license)

db-truncate is licensed under a [MIT License](https://opensource.org/licenses/MIT).

###  Health Score

27

—

LowBetter than 49% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity10

Limited adoption so far

Community4

Small or concentrated contributor base

Maturity60

Established project with proven stability

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 ~216 days

Total

3

Last Release

3424d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/1dfe693e24f13322ee0ab1de94b76274aa9bedfd1f0951913c44a971ad8d4cb8?d=identicon)[idealogica](/maintainers/idealogica)

---

Tags

mysqltabletrimtruncate

### Embed Badge

![Health badge](/badges/idealogica-db-truncate/health.svg)

```
[![Health](https://phpackages.com/badges/idealogica-db-truncate/health.svg)](https://phpackages.com/packages/idealogica-db-truncate)
```

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k578.4M5.6k](/packages/doctrine-dbal)[kirschbaum-development/eloquent-power-joins

The Laravel magic applied to joins.

1.6k25.2M34](/packages/kirschbaum-development-eloquent-power-joins)[scienta/doctrine-json-functions

A set of extensions to Doctrine that add support for json query functions.

58723.9M36](/packages/scienta-doctrine-json-functions)[liqueurdetoile/cakephp-orm-json

Cakephp plugin to provide easy control over JSON type fields in database

1461.1k](/packages/liqueurdetoile-cakephp-orm-json)[cytopia/mysqldump-secure

Secure mysqldump script with encryption, compression, logging, blacklisting and Nagios monitoring integration

1474.7k1](/packages/cytopia-mysqldump-secure)

PHPackages © 2026

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