humxmad / laramyadmin
A modern, beautiful, multi-database management package for Laravel (phpMyAdmin / TablePlus alternative).
Requires
- php: ^8.2
- illuminate/database: ^10.0|^11.0|^12.0|^13.0
- illuminate/http: ^10.0|^11.0|^12.0|^13.0
- illuminate/routing: ^10.0|^11.0|^12.0|^13.0
- illuminate/session: ^10.0|^11.0|^12.0|^13.0
- illuminate/support: ^10.0|^11.0|^12.0|^13.0
- illuminate/view: ^10.0|^11.0|^12.0|^13.0
Requires (Dev)
- orchestra/testbench: ^8.0|^9.0|^10.0
- orchestra/workbench: ^8.0|^9.0|^10.0
- phpunit/phpunit: ^10.0|^11.0|^12.0
README
LaraMyAdmin β‘ (Laravel Multi-Database Studio Pro)
A modern, powerful, and developer-friendly database management package for Laravel (a state-of-the-art alternative to phpMyAdmin, TablePlus, and Adminer).
Manage all your connected databases (MySQL, PostgreSQL, SQLite, SQL Server), dynamically connect to external databases, browse & edit data, design schemas, execute raw SQL queries, export code to Laravel migrations/models, generate mock data, search globally, and compare schemas right from a sleek, dark-mode web studio.
β¨ Features
-
π Multi-Database Connections:
- Auto-discovers all connections configured in Laravel (
config/database.php). - Dynamic on-the-fly connections (MySQL, PostgreSQL, SQLite, SQL Server) with connection testing & ping.
- One-click connection switcher in the header.
- Auto-discovers all connections configured in Laravel (
-
π Laravel-Specific Superpowers:
- Export to Migration: 1-click generation of Laravel migration files (
create_xyz_table.php). - Export to Eloquent Model: Generates PHP Eloquent Models with
$fillable,$casts, and foreign key relationship methods (hasMany,belongsTo). - Export to Model Factory: Generates Laravel Model Factory definitions with Faker.
- Export to Migration: 1-click generation of Laravel migration files (
-
β‘ Spreadsheet-Style Inline Cell Editing:
- Double-click any cell in the data grid to edit the value directly in-place and press
Enterto commit.
- Double-click any cell in the data grid to edit the value directly in-place and press
-
π Global Database Search:
- Search any keyword across all tables in the database at once.
-
π€ Mock Data Generator:
- 1-click seeding of 10, 25, 50, or 100 realistic dummy records matching table columns and types.
-
πΊοΈ Visual Schema & ER Diagram:
- Interactive diagram displaying tables, columns, row metrics, and relationship links.
-
βοΈ Schema Diff & Database Comparison:
- Compare two connected databases (e.g.
localvsstaging) to detect missing tables and mismatched column types.
- Compare two connected databases (e.g.
-
π» SQL Query Console & Bookmarks:
- Syntax-highlighted CodeMirror SQL editor with
Ctrl + Enterexecution. - Execution timer (ms) and affected rows counter.
EXPLAINquery performance analyzer.- Save favorite queries as Bookmarks with custom labels.
- Syntax-highlighted CodeMirror SQL editor with
-
π¦ Export & Import:
- Export tables to SQL Dump, CSV, or JSON.
- Import SQL dump files or raw SQL statements.
-
π Security & Permissions:
- Read-only mode protection.
- Custom authorization callback (
LaraMyAdmin::auth(...)).
π Installation
Install LaraMyAdmin via Composer:
composer require humxmad/laramyadmin
Publish configuration (optional):
php artisan vendor:publish --tag=laramyadmin-config
Access LaraMyAdmin in your browser:
http://your-app.test/laramyadmin
π Authorization Gate (Production Protection)
use LaraMyAdmin\LaraMyAdmin; public function boot(): void { LaraMyAdmin::auth(function ($request) { return $request->user() && $request->user()->is_admin; }); }
π§ͺ Testing
composer test
π License
The MIT License (MIT). Please see License File for more information.
