PHPackages                             dmstr/yii2-db - 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. dmstr/yii2-db

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

dmstr/yii2-db
=============

Database extensions

3.1.0(6mo ago)19618.8k↓25.7%9[1 PRs](https://github.com/dmstr/yii2-db/pulls)6BSD-3-ClausePHPPHP >=7.1

Since Nov 14Pushed 6mo ago10 watchersCompare

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

READMEChangelog (10)Dependencies (3)Versions (87)Used By (6)

Yii 2 Database Toolkit
======================

[](#yii-2-database-toolkit)

[![Latest Stable Version](https://camo.githubusercontent.com/e76f95ec8fc8dc93ada8e6ceecf312a99beffaca22dd278d7b92be189c4e00a5/68747470733a2f2f706f7365722e707567782e6f72672f646d7374722f796969322d64622f762f737461626c652e737667)](https://packagist.org/packages/dmstr/yii2-db)[![Total Downloads](https://camo.githubusercontent.com/be4b061272711b703cd57acdeff4f69065d3e3227c173ea4a80f0f15c087a3b8/68747470733a2f2f706f7365722e707567782e6f72672f646d7374722f796969322d64622f646f776e6c6f6164732e737667)](https://packagist.org/packages/dmstr/yii2-db)[![License](https://camo.githubusercontent.com/17bb4103c6a744ec57b18fd8f90a0f69da5b0015f327708184d0941072078985/68747470733a2f2f706f7365722e707567782e6f72672f646d7374722f796969322d64622f6c6963656e73652e737667)](https://packagist.org/packages/dmstr/yii2-db)

About
-----

[](#about)

### [dmstr\\db\\behaviors\\HydratedAttributes](https://github.com/dmstr/yii2-db/blob/master/db/behaviors/HydratedAttributes.php)

[](#dmstrdbbehaviorshydratedattributes)

Retrieves all eager loaded attributes of a model including relations. Once the extension is installed, simply use it in your code by accessing the corresponding classes by their full namespaced path.

### [dmstr\\db\\mysql\\FileMigration](https://github.com/dmstr/yii2-db/blob/master/db/mysql/FileMigration.php)

[](#dmstrdbmysqlfilemigration)

runs database migrations from `sql` files

- Generic database exentsions
    - Hydrated Attributes
- Database extensions for MySQL
    - File Migration
    - Mysql dump/export/import console controller
- RBAC migrations moved to  since 2.0.0
- Active record access classes moved to  since 2.0.0

Installation
------------

[](#installation)

The preferred way to install this extension is through [composer](http://getcomposer.org/download/).

Either run

```
composer require --prefer-dist dmstr/yii2-db "*"

```

or add

```
"dmstr/yii2-db": "*"

```

to the require section of your `composer.json` file.

Configuration
-------------

[](#configuration)

### [dmstr\\console\\controllers](https://github.com/dmstr/yii2-db/blob/master/console/controllers)

[](#dmstrconsolecontrollers)

Include it in your console configuration

```
   'controllerMap' => [
        'db'         => [
            'class' => 'dmstr\console\controllers\MysqlController',
            'noDataTables' => [
                'app_log',
                'app_session',
            ]
        ],
    ],

```

Usage
-----

[](#usage)

### Commands

[](#commands)

#### `yii migrate ...`

[](#yii-migrate-)

Create a file migration class

```
yii migrate/create \
    --templateFile='@vendor/dmstr/yii2-db/db/mysql/templates/file-migration.php' init_dump

```

#### `yii db ...`

[](#yii-db-)

```
DESCRIPTION

MySQL database maintenance command for current (db) connection

SUB-COMMANDS

- db/create               Create schema
- db/destroy              Remove schema
- db/dump                 Dump schema (all tables)
- db/export               Export tables (INSERT only)
- db/import               Import from file to database and flush cache
- db/index (default)      Displays tables in database
- db/wait-for-connection

To see the detailed information about individual sub-commands, enter:

  yii help

```

Show help

```
yii help db

```

### Examples

[](#examples)

Dry-run command (not available for all commands)

```
yii db/create root secret -n

```

Destroy database

```
yii db/destroy root secret

```

Dump all tables

```
yii db/dump -o /dumps

```

Dump from different connection, exclude logging tables

```
yii db/dump -o /dumps \
  --db=dbReadonly \
  --noDataTables=app_audit_data,app_audit_entry,app_audit_error,app_audit_javascript,app_audit_mail

```

Dump from secondary connection, import into primary (default)

```
yii db/dump -o /dumps   \
    --db=dbReadonly   \
    --noDataTables=app_audit_data,app_audit_entry,app_audit_error,app_audit_javascript,app_audit_mail \
 | xargs yii db/import --interactive=0

```

---

Built by [dmstr](http://diemeisterei.de)

###  Health Score

57

—

FairBetter than 98% of packages

Maintenance66

Regular maintenance activity

Popularity48

Moderate usage in the ecosystem

Community28

Small or concentrated contributor base

Maturity74

Established project with proven stability

 Bus Factor1

Top contributor holds 83.9% 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 ~54 days

Recently: every ~409 days

Total

75

Last Release

208d ago

Major Versions

0.10.1 → 1.0.0-alpha12018-07-18

1.2.1 → 2.0.0-rc12020-05-11

2.0.0-rc2 → 3.0.0-beta12020-12-08

### Community

Maintainers

![](https://www.gravatar.com/avatar/3b4ab2b6685ec71887908ec8cff261a16cd5bb24c69bb8ab52840e220f175f9d?d=identicon)[schmunk](/maintainers/schmunk)

---

Top Contributors

[![schmunk42](https://avatars.githubusercontent.com/u/649031?v=4)](https://github.com/schmunk42 "schmunk42 (104 commits)")[![handcode](https://avatars.githubusercontent.com/u/825574?v=4)](https://github.com/handcode "handcode (7 commits)")[![marc7000](https://avatars.githubusercontent.com/u/1118837?v=4)](https://github.com/marc7000 "marc7000 (3 commits)")[![xepozz](https://avatars.githubusercontent.com/u/6815714?v=4)](https://github.com/xepozz "xepozz (2 commits)")[![eluhr](https://avatars.githubusercontent.com/u/13000805?v=4)](https://github.com/eluhr "eluhr (2 commits)")[![Konrad90](https://avatars.githubusercontent.com/u/328977?v=4)](https://github.com/Konrad90 "Konrad90 (2 commits)")[![tibee](https://avatars.githubusercontent.com/u/3636947?v=4)](https://github.com/tibee "tibee (2 commits)")[![andrew-ko](https://avatars.githubusercontent.com/u/10698171?v=4)](https://github.com/andrew-ko "andrew-ko (1 commits)")[![Quexer69](https://avatars.githubusercontent.com/u/3859353?v=4)](https://github.com/Quexer69 "Quexer69 (1 commits)")

---

Tags

access-controlbehaviordata-dumpdmstrmysqltraityii2databasedbyii2extension

### Embed Badge

![Health badge](/badges/dmstr-yii2-db/health.svg)

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

###  Alternatives

[johnitvn/yii2-ajaxcrud

Gii CRUD template for Single Page Ajax Administration for yii2

97209.6k16](/packages/johnitvn-yii2-ajaxcrud)[mg-code/yii2-helpers

A collection of useful helper classes for Yii framework 2.0

2022.5k5](/packages/mg-code-yii2-helpers)

PHPackages © 2026

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