PHPackages                             aseancode/dbcommands - 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. aseancode/dbcommands

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

aseancode/dbcommands
====================

laravel command to create/drop database(MySQL)

0225PHP

Since Oct 20Pushed 4y ago1 watchersCompare

[ Source](https://github.com/LytayTOUCH/laravel-dbcommands)[ Packagist](https://packagist.org/packages/aseancode/dbcommands)[ RSS](/packages/aseancode-dbcommands/feed)WikiDiscussions master Synced 2w ago

READMEChangelogDependenciesVersions (1)Used By (0)

Laravel DbCommands Package
==========================

[](#laravel-dbcommands-package)

This package provides you with a simple tool to make laravel command to create/drop database without touching directly on database engine.

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

[](#installation)

Via Composer

```
$ composer require aseancode/dbcommands
```

If you do not run Laravel 5.5 (or higher), then add the service provider in `config/app.php`:

```
// config/app.php
'providers' => [
    ...
    /*
    * Package Service Providers...
    */
    AseanCode\DbCommands\DbCommandsServiceProvider::class,
    ...
];
```

Publish env files into laravel root project and override existing env file for MySQL:

```
$ php artisan vendor:publish --tag=envmysql --force
```

Publish env files into laravel root project and override existing env file for SQLite:

```
$ php artisan vendor:publish --tag=envsqlite --force
```

Publish env files into laravel root project and override existing env file for Postgresql:

```
$ php artisan vendor:publish --tag=envpgsql --force
```

Generate key within the project:

```
$ php artisan key:generate
```

Usage command to create database for all environments:

```
$ php artisan db:create --all
```

Usage command to drop database for all environments:

```
$ php artisan db:drop --all
```

Configuration as needed
-----------------------

[](#configuration-as-needed)

In order to make some change base on your preference of database connnection, let's check on all envfiles after publishing to root project.

Be Aware
--------

[](#be-aware)

Every env files has these configuration code.

```
CHARSET="utf8mb4"
COLLATION="utf8mb4_unicode_ci"
DB_ENGINE="InnoDB ROW_FORMAT=DYNAMIC"

```

In config/database.php, change this line:

```
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'engine' => null,
```

To

```
'charset' => env('CHARSET', 'utf8mb4'),
'collation' => env('COLLATION', 'utf8mb4_unicode_ci'),
'engine' => env('DB_ENGINE', 'InnoDB ROW_FORMAT=DYNAMIC'),
```

###  Health Score

18

—

LowBetter than 8% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity11

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity28

Early-stage or recently created project

 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.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/769127?v=4)[lytay](/maintainers/LytayTouch)[@LytayTOUCH](https://github.com/LytayTOUCH)

---

Top Contributors

[![LytayTOUCH](https://avatars.githubusercontent.com/u/769127?v=4)](https://github.com/LytayTOUCH "LytayTOUCH (12 commits)")

### Embed Badge

![Health badge](/badges/aseancode-dbcommands/health.svg)

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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