PHPackages                             niaz/dbpanel - 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. niaz/dbpanel

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

niaz/dbpanel
============

developer panel for laravel application

v1.1.5(5y ago)83.0k[1 issues](https://github.com/md-amirozzaman-niaz/dbpanel/issues)[18 PRs](https://github.com/md-amirozzaman-niaz/dbpanel/pulls)MITJavaScript

Since May 9Pushed 3y ago1 watchersCompare

[ Source](https://github.com/md-amirozzaman-niaz/dbpanel)[ Packagist](https://packagist.org/packages/niaz/dbpanel)[ RSS](/packages/niaz-dbpanel/feed)WikiDiscussions master Synced 6d ago

READMEChangelog (2)Dependencies (2)Versions (53)Used By (0)

dbpanel
=======

[](#dbpanel)

Introduction
------------

[](#introduction)

dbpanel is a developer tool for laravel application. You can test your `controller`'s action methods by calling its `namepspace@method` and save them for your future need. You can also run artisan command, namespace lookup for available methods and all their associated doc and parameters type.

📢 You can also access your laravel application's `database` easily and fastest way in a same panel. There are some cool filter available with this package. You might look around your table's column type and index also. You can also update and delete your filtered data.

📢 You can also open vue component in code editor (phpstorm,vscode) by clicking `open file` from vue chrome extention tool.

### Installation 📡

[](#installation-satellite)

```
composer require niaz/dbpanel --dev

```

### Publish assets 🔌

[](#publish-assets-electric_plug)

```
php artisan vendor:publish --tag=dbpanel --force

```

### SetUp Configuration 🚀

[](#setup-configuration-rocket)

You need to edit `config/dbpanel.php` as your configuration

If your default code editor is `phpstorm`,then need to set as

```
 'editor'=>'phpstorm'  // default 'editor'=>'vscode'

```

If your application not used controller namespace property, then you need to set this value as

```
  'controller' => '',  // deafult 'controller' => 'App\\Http\\Controllers\\',

```

### Usage 📦

[](#usage-package)

Visit Route:

```
/dbpanel

```

### To Check Controller or Model or Other Method

[](#to-check-controller-or-model-or-other-method)

Just type your Controller or Model or any other class name and method as

```
ClassName@method

```

If you had a more namespace from Controller or Model default namespace prefix, then

```
ExtraNameSpace\ClassName@method

```

To pass parameter

```
App\User 5|string|58,hello,78|12:58:59

```

> Note: parameters are separated by `|`. Array parameter value are `,` seprated. Numeric string value will auto converted as `int` type value. This was also applicable for array.

To pass `request` instance

```
prop.width.px@45
prop.height.px@45
filter.date.start@2020-11-12
filter.date.end@2020-15-12
filter.search@lorem ipsum
filter.range.min@15
filter.range.max@68
filter.time@12:58:56

```

> every formData are in a new line

or Raw json

```
{
    "husky": {
        "hooks": {
        "pre-commit": "npm test",
        "pre-push": "npm test",
        "...": "..."
        }
    }
}

```

### Return

[](#return)

It will return a json with `log` and `data` . In `log` all database query,bindings and time are listed.If this method return any data,it will return with `data`.

> Tip: you can test your request data from other tab by passing `request@dd`, `parameters` and `request`

### To pass auth for login with `ID`

[](#to-pass-auth-for-login-with-id)

```
5@id,name,email

```

> id\_number@id,column\_name,email

### Run Artisan Command

[](#run-artisan-command)

### Database

[](#database)

Select a `table` name from table option and enter some query string with some `key` name are filter name as follows:

#### id *(key)*

[](#id-key)

Example: `&id=5` `&id=5-100`

#### sort *(key)*

[](#sort-key)

Example: `&sort=email:asc` `&sort=name:desc` `&sort=desc`

#### is *(key)*

[](#is-key)

Example: `&is=active:0` `&is=active:1` `&is=date:2020-04-29`

#### date *(key)*

[](#date-key)

single date

Example: `&date=updated_at:2020-04-29`

range of date

Example: `&date=created_at:2020-04-19:2020-04-21`

#### lookup *(key)*

[](#lookup-key)

for *variant*,

- use `!` for not match
- use `$` to specify string postion
- use `,` for *and* condition
- use `|` for *or* condition

Example:

`&lookup=email:start$` `&lookup=email:$end` `&lookup=email:$anywhere$` `&lookup=email:!$.com`

#### where *(key)*

[](#where-key)

for *variant*,

- use `!` for not equal
- use `` for greater than
- use `,` for *and* condition
- use `|` for *or* condition

Example:

- `&where=product_price:500` `&where=discount: **Note**: when use **join** Not to use any similar `column` name related filter it will thrown error.

#### return\_only *(key)*

[](#return_only-key)

for *alias* use `@`

Example:

- `&return_only=id,name,email` `&return_only=name,email,phone`
- `&return_only=id,name@user_name,email@user_email`
- `&return_only=name@employee_name,phone@employee_phone`
- `&return_only=users.name@employee_name,address,website`

#### return\_except *(key)*

[](#return_except-key)

Example:

- `&return_except=id,name,email` `&return_except=name,email,phone`

#### Delete

[](#delete)

To delete your filtered data just pass `&delete`

#### Update

[](#update)

Example : `&update=column_name:value,column_name:value`

Lisence
-------

[](#lisence)

[MIT Lisence](https://github.com/md-amirozzaman-niaz/dbpanel/blob/License.md)

###  Health Score

34

—

LowBetter than 77% of packages

Maintenance18

Infrequent updates — may be unmaintained

Popularity23

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity69

Established project with proven stability

 Bus Factor1

Top contributor holds 78.1% 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 ~6 days

Recently: every ~26 days

Total

33

Last Release

1981d ago

Major Versions

v0.1.11 → v1.0.12020-06-27

### Community

Maintainers

![](https://www.gravatar.com/avatar/0219777d649772b945f14343e46b73cacea960298e1e09106025d4475ef06f1e?d=identicon)[md-amirozzaman-niaz](/maintainers/md-amirozzaman-niaz)

---

Top Contributors

[![md-amirozzaman-niaz](https://avatars.githubusercontent.com/u/40523520?v=4)](https://github.com/md-amirozzaman-niaz "md-amirozzaman-niaz (75 commits)")[![amirozzaman](https://avatars.githubusercontent.com/u/66353269?v=4)](https://github.com/amirozzaman "amirozzaman (13 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (8 commits)")

---

Tags

databasedbpanellaravellaravel-package

### Embed Badge

![Health badge](/badges/niaz-dbpanel/health.svg)

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

###  Alternatives

[scienta/doctrine-json-functions

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

58523.9M36](/packages/scienta-doctrine-json-functions)[martin-georgiev/postgresql-for-doctrine

Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostGIS geometries, text search, ltree, uuid, and 100+ PostgreSQL-specific functions.

4485.3M4](/packages/martin-georgiev-postgresql-for-doctrine)[damienharper/auditor-bundle

Integrate auditor library in your Symfony projects.

4542.8M](/packages/damienharper-auditor-bundle)[sonata-project/entity-audit-bundle

Audit for Doctrine Entities

644989.8k1](/packages/sonata-project-entity-audit-bundle)[overtrue/laravel-versionable

Make Laravel model versionable.

585308.0k5](/packages/overtrue-laravel-versionable)[worksome/foggy

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

26571.7k1](/packages/worksome-foggy)

PHPackages © 2026

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