PHPackages                             flamento/magicdb - 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. flamento/magicdb

ActiveLibrary

flamento/magicdb
================

A database manager that you can attach to your Laravel application.

v1.0.2(3y ago)116MITBlade

Since Nov 29Pushed 3y agoCompare

[ Source](https://github.com/Flamentist/magicdb)[ Packagist](https://packagist.org/packages/flamento/magicdb)[ RSS](/packages/flamento-magicdb/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (3)DependenciesVersions (4)Used By (0)

Magic DB
========

[](#magic-db)

[![Latest Version](https://camo.githubusercontent.com/2a6f11b650538ebc357e2ad2edd80bf7c25bada5cd0ac520fec3bed53ecde8fb/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f72656c656173652f466c616d656e746973742f6d6167696364622e7376673f7374796c653d666c61742d737175617265)](https://github.com/Flamentist/magicdb/releases)[![Total Downloads](https://camo.githubusercontent.com/3c457d875eaa81f7e14e1a42de19dadb2e01cf9df8ba025cfe6443ef39c8ad37/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f666c616d656e746f2f6d6167696364622e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/flamento/magicdb)

Magic DB is a database manager that you can easily integrate to your Laravel application.

- Easy access to your database via `/magicdb/login` route.
- Perform SQL and CRUD operations on your tables.
- Automatic Daily Backup of your database (.gzip file).
- Download a backup copy of your database.

[![Magic DB Login Page](https://camo.githubusercontent.com/dccb7e988eef35e138d9d7eaa57bda27ba874d2401f06d53703de6a6fb2d101e/68747470733a2f2f692e706f7374696d672e63632f6456786363674d4d2f6c6f67696e2e706e67)](https://camo.githubusercontent.com/dccb7e988eef35e138d9d7eaa57bda27ba874d2401f06d53703de6a6fb2d101e/68747470733a2f2f692e706f7374696d672e63632f6456786363674d4d2f6c6f67696e2e706e67)

[![Magic DB Table View](https://camo.githubusercontent.com/8986259d1ce239cd401ef31a78915cc3a6098f007c964f6c95557a40cf371d76/68747470733a2f2f692e706f7374696d672e63632f7a66485a7a7035792f7461626c652e706e67)](https://camo.githubusercontent.com/8986259d1ce239cd401ef31a78915cc3a6098f007c964f6c95557a40cf371d76/68747470733a2f2f692e706f7374696d672e63632f7a66485a7a7035792f7461626c652e706e67)

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

[](#installation)

The recommended way to install Magic DB is via [Composer](https://getcomposer.org/).

```
composer require flamento/magicdb
```

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

[](#configuration)

### Publish the configuration file

[](#publish-the-configuration-file)

```
php artisan vendor:publish --provider="Flamento\MagicDB\MagicDBServiceProvider"
```

### Content of the configuration file

[](#content-of-the-configuration-file)

```
return [
    'middleware' => ['web'],
    /* 2 request per 5 minutes for backup endpoint*/
    'backup_throtlle' => 'throttle:2,5,magicdb_backup',
    /* 2 request per minute for login/logout endpoint*/
    'auth_throttle' => 'throttle:2,1,magicdb_auth',

    /* If Magic DB should backup every day, > .gzip saved in storage/app/magicdb/backup  */
    'backup_daily' => true,

    /* Credential to access Magic DB via /magicdb/login page*/
    'MAGICDB_USERNAME' => env('MAGICDB_USERNAME', 'admin'),
    'MAGICDB_PASSWORD' => env('MAGICDB_PASSWORD', 'admin'),

    /* Your database settings */
    'DB_USERNAME' => env('DB_USERNAME', 'root'),
    'DB_PASSWORD' => env('DB_PASSWORD', ''),
    'DB_HOST' => env('DB_HOST', 'localhost'),
    'DB_DATABASE' => env('DB_DATABASE', ''),
];
```

Setting up Cron Job
-------------------

[](#setting-up-cron-job)

### For Linux Server

[](#for-linux-server)

If you wish to have a daily backup of your database, you need to setup a cron job.

```
* * * * * php /path-to-your-project/artisan schedule:run 1>> /dev/null 2>&1

OR

* * * * * cd /path-to-your-project && php artisan schedule:run >> /dev/null 2>&1
```

### For Windows Server

[](#for-windows-server)

Please use Task Scheduler available in Windows.

> To find out more about setting up a cron job, please visit [Laravel Task Scheduler](https://laravel.com/docs/5.8/scheduling#introduction) to setup a cron job.

Supported Versions
------------------

[](#supported-versions)

Magic DB is supported on Laravel 7.0 and above as well as PHP 7.2 and above. This is as far as I can test, but it may work on older versions. However, this library is not meant to be used on older versions of Laravel and PHP except on the versions mentioned above.

Security
--------

[](#security)

If you discover a security vulnerability within this package, please send an email to . All security vulnerabilities will be promptly addressed. Please do not disclose security-related issues publicly until a fix has been announced.

License
-------

[](#license)

Magic DB is open-sourced software licensed under the [MIT license](LICENSE.md).

###  Health Score

22

—

LowBetter than 22% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity48

Maturing project, gaining track record

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

Total

3

Last Release

1260d ago

### Community

Maintainers

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

---

Top Contributors

[![akosiyawin](https://avatars.githubusercontent.com/u/58063682?v=4)](https://github.com/akosiyawin "akosiyawin (10 commits)")

### Embed Badge

![Health badge](/badges/flamento-magicdb/health.svg)

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

PHPackages © 2026

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