PHPackages                             andkirby/mage-db-helper - 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. andkirby/mage-db-helper

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

andkirby/mage-db-helper
=======================

Database Helpers (Magento)

v2.0.0(9y ago)1711[1 issues](https://github.com/andkirby/db-helpers/issues)MITPHPPHP >=5.3.2

Since May 3Pushed 9y ago1 watchersCompare

[ Source](https://github.com/andkirby/db-helpers)[ Packagist](https://packagist.org/packages/andkirby/mage-db-helper)[ RSS](/packages/andkirby-mage-db-helper/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependencies (1)Versions (7)Used By (0)

Magento Database Helpers
========================

[](#magento-database-helpers)

Overview
--------

[](#overview)

There are DB procedures/functions to help work with Magento DB.

Composer installation
---------------------

[](#composer-installation)

```
$ composer global require andkirby/mage-db-helper
```

`global` parater can be ommited if you won't use this installation globally.

Install scripts
---------------

[](#install-scripts)

```
$ mage-db-helper install -d dbname -u dbuser -p password1
```

If parameter `--mysql-password (-p)` (MySQL password) is ommited you may set it in dialog to make this command secured. Also you may skip asking password with parameter `--no-password (-o)`;

### More

[](#more)

To get full help about parameters please use standard `--help (-h)` parameter.

```
$ mage-db-helper install -h
```

Usage Helpers in Database
-------------------------

[](#usage-helpers-in-database)

There are available helpers:

- `DropAllTables`,
- `ResetBaseUrl`.
- `ResetAdmin`.

### `DropAllTables`

[](#dropalltables)

Remove all tables from database. It useful to prevent reinstalling exists procedures (like these ones).

```
CALL dbname.DropAllTables();
```

### `ResetBaseUrl`

[](#resetbaseurl)

Reset base URLs in `core_config` table. It useful when you migrate database.

```
CALL dbname.ResetBaseUrl('old-server.example.com', 'new-one.example.com');
```

### `ResetAdmin`

[](#resetadmin)

Reset password, username (set to `admin`) and locking of first admin user (ID #1) in `admin_user` table. It useful to reset admin user quickly.

```
CALL dbname.ResetAdmin('your-new-password');
```

Note: `dbname` could be omitted in examples if you run `use dbname;` before.

###  Health Score

23

—

LowBetter than 27% of packages

Maintenance0

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity62

Established project with proven stability

 Bus Factor1

Top contributor holds 100% 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 ~148 days

Recently: every ~185 days

Total

6

Last Release

3294d ago

Major Versions

v1.2.0 → v2.0.02017-05-12

### Community

Maintainers

![](https://www.gravatar.com/avatar/79af1435892dd9111c06a5e386fd69b577a71f3fbcc3f20aab50db8e5abc8ce2?d=identicon)[andkirby](/maintainers/andkirby)

---

Top Contributors

[![andkirby](https://avatars.githubusercontent.com/u/1828532?v=4)](https://github.com/andkirby "andkirby (27 commits)")

### Embed Badge

![Health badge](/badges/andkirby-mage-db-helper/health.svg)

```
[![Health](https://phpackages.com/badges/andkirby-mage-db-helper/health.svg)](https://phpackages.com/packages/andkirby-mage-db-helper)
```

###  Alternatives

[spatie/laravel-backup

A Laravel package to backup your application

6.0k21.8M191](/packages/spatie-laravel-backup)[ssch/typo3-rector

Instant fixes for your TYPO3 PHP code by using Rector.

2592.8M263](/packages/ssch-typo3-rector)[guikingone/scheduler-bundle

A Symfony bundle that allows to schedule and create repetitive tasks

114217.4k](/packages/guikingone-scheduler-bundle)[worksome/foggy

Foggy is a tool for making database dumps with some data removed/changed.

26571.7k1](/packages/worksome-foggy)[psx/sql

Generate type-safe PHP classes from your database

1773.4k4](/packages/psx-sql)[bartlett/php-compatinfo-db

Reference Database of all functions, constants, classes, interfaces on PHP standard distribution and about 110 extensions

1183.0k1](/packages/bartlett-php-compatinfo-db)

PHPackages © 2026

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