Download the PHP package mahmoudabdelhalim/db-manager without Composer

DB Manager is a beautiful, full-featured Laravel package that brings a phpMyAdmin-style database management UI directly into your Laravel application — no separate installation, no separate authentication. Browse tables, run SQL queries, manage structure, insert and edit rows, import/export databases — all from a clean, modern interface protected by your own middleware stack.

✨ Features

• 🗄️ Browse & manage databases, tables, columns, indexes, and foreign keys
• ✏️ Insert, edit, and delete rows with smart type-aware inputs
• ⚡ SQL editor with syntax highlighting (CodeMirror) and auto-pagination
• 📤 Export databases as SQL dumps
• 📥 Import SQL files directly from the browser
• 🔌 Three connection modes — use Laravel's own DB, show all databases, or present a custom login form
• 🛡️ Fully protected by your existing Laravel middleware (auth, gates, custom middleware)
• 🎨 Self-contained UI — no CSS framework conflicts, no dependency on your app's layout
• ⚙️ Publishable config and service provider stub for deep customization
• 🔧 Zero config out of the box — works immediately after install

📋 Requirements

🚀 Installation

Install the package via Composer:

The package is auto-discovered by Laravel — no manual provider registration needed.

That's it. Visit /db-manager in your browser (you must be logged in via Laravel's default auth middleware).

⚙️ Configuration

Publish the config file:

This creates config/db-manager.php:

You can also set these values in your .env file:

🔌 Connection Modes

laravel (default)

Automatically connects using your app's existing database credentials from config/database.php. Only your application's own database is shown. No login form — access is controlled entirely by your middleware.

all

Same as laravel but shows all databases on the MySQL server that the configured user has access to. Useful for developers managing multiple databases on the same server.

custom

Presents a MySQL login form on first visit. Credentials (host, port, username, password) are stored in the session. The user can disconnect at any time. Ideal for shared developer tools or staging environments.

🛡️ Middleware & Authorization

By default, DB Manager is protected by ['web', 'auth'] — meaning the user must be authenticated in your Laravel app. You can change this to any middleware, gate, or role in the config:

Or use a role-based package like Spatie:

Custom Service Provider (Advanced)

For full control, publish the service provider stub:

This creates app/Providers/DbManagerServiceProvider.php. Register it in bootstrap/providers.php (Laravel 11+):

Or in config/app.php (Laravel 10):

Note: Once you register your custom provider, remove the package's auto-discovery entry from config/app.php's dont-discover array or the package's own provider will also register — causing duplicates.

📁 Published Files Reference

🔒 Security

If you discover any security vulnerabilities, please send an email to [email protected] instead of opening a public issue.

📄 License

This package is open-source software licensed under the MIT License. See the LICENSE file for details.

Made with ❤️ by Mahmoud Abd Elhalim