crumbls/filament-database

A database management panel for Laravel Filament — like phpMyAdmin, built into your admin.

3.0.1 2026-09-01 17:10 UTC

Requires

• php: ^8.3
• filament/filament: ^5.0
• laravel/framework: ^12.0 || ^13.0

Requires (Dev)

• orchestra/testbench: ^10.0 || ^11.0
• pestphp/pest: ^4.3
• pestphp/pest-plugin-livewire: ^4.1
• pestphp/pest-plugin-type-coverage: ^4.0

MIT

• Chase Miller

• database
• admin
• mysql
• sqlite
• postgres
• laravel
• phpmyadmin
• filament

Published on Packagist.org on 2026-09-01 18:19 UTC

README

A phpMyAdmin-style database manager for Laravel Filament. Browse tables, edit rows, manage schema, run SQL — all from your Filament admin panel.

Requirement	Minimum Version
PHP	8.3
Laravel	12.0 – 13.x
Filament	5.0

Screenshots

Database Overview

Table Browser

Installation

composer require crumbls/filament-database

Setup

Register the plugin in your Filament panel provider:

use Crumbls\FilamentDatabase\FilamentDatabasePlugin;

public function panel(Panel $panel): Panel
{
    return $panel
        // ...
        ->plugins([
            FilamentDatabasePlugin::make()
                ->connections(['mysql'])
                ->authorize(function (): bool {
                    // You need to customize this. It controls who can view it.
                    return false;
                }),
        ]);
}

Features

• Database overview — stats dashboard with table counts, row counts, and largest tables at a glance
• Connection switcher — hot-swap between database connections with health checking
• Table browser — searchable table list with row counts, one-click selection
• Row CRUD — paginated rows with sort, search, inline edit, insert, delete
• Bulk operations — select multiple rows for bulk delete or export
• Copy row as — copy any row as PHP array, JSON, SQL INSERT, or Laravel factory format
• Structure viewer — columns with types, nullable, defaults, and inline editing
• Column management — add, rename, modify, and drop columns
• Index viewer — all indexes with columns and uniqueness
• Foreign key viewer — constraints with ON UPDATE/DELETE actions
• Relationships tab — visual map of incoming and outgoing foreign key relationships
• SQL runner — execute raw queries with tabular results, query history, and Cmd/Ctrl+Enter shortcut
• Query EXPLAIN — EXPLAIN/ANALYZE support for MySQL, PostgreSQL, and SQLite
• Schema snapshots — capture your entire database schema as JSON, compare against previous snapshots with color-coded diffs
• Migration generator — generate Laravel migration code from schema diffs for review and download
• Export — download table data as CSV, JSON, or SQL INSERT statements
• Import — upload CSV files with automatic column mapping
• Table operations — create, truncate, drop tables with confirmation dialogs
• Dark mode — full support via Filament CSS variables
• Audit logging — optional query and change logging

Configuration

Publish the config:

php artisan vendor:publish --tag=filament-database-config

The published configuration fails closed: no connections are allowed, database writes are read-only, and the SQL runner is disabled until explicitly enabled. Fluent plugin configuration overrides the corresponding published values for a specific Filament panel.

Plugin API

FilamentDatabasePlugin::make()
    // Access control
    ->authorize(fn () => auth()->user()->is_admin)
    ->onlyForEmails(['[e-mail]'])

    // Connections
    ->connections(['mysql', 'sqlite'])
    ->excludeConnections(['pgsql'])
    ->defaultConnection('mysql')

    // Safety
    ->readOnly()
    ->preventDestructive()
    ->requireConfirmation()

    // Table visibility
    ->hideTables(['password_resets', 'failed_jobs'])
    ->showOnlyTables(['users', 'posts'])

    // SQL runner
    ->disableQueryRunner()
    ->queryRunnerReadOnly()

    // UI
    ->navigationGroup('System')
    ->navigationIcon('heroicon-o-circle-stack')
    ->navigationSort(100)
    ->navigationLabel('Database')
    ->rowsPerPage(25)
    ->maxRowsPerPage(500)

    // Audit
    ->logQueries()
    ->logChanges()

Security

This package gives direct database access. Access is denied to all users by default — you must explicitly grant access via one of the authorization methods below.

Authorization (required)

// Closure — full control
FilamentDatabasePlugin::make()
    ->authorize(fn () => auth()->user()->is_admin)

// Laravel Gate
FilamentDatabasePlugin::make()
    ->authorizeUsing('manage-database')

// Email allowlist
FilamentDatabasePlugin::make()
    ->onlyForEmails(['[e-mail]'])

Recommended production settings

FilamentDatabasePlugin::make()
    ->authorize(fn () => auth()->user()->is_admin)
    ->readOnly()                          // block all writes
    ->preventDestructive()                // block DROP / TRUNCATE
    ->connections(['mysql'])              // limit to specific connections
    ->logQueries()                        // audit all SQL
    ->logChanges()                        // audit all data changes

Read-only SQL classification is defense in depth. Production read-only panels should use database credentials without DML, DDL, file, function-execution, or administrative privileges and should configure a server-side statement timeout. SQL result sets returned to Livewire are capped at 500 rows.

Row-level record and selection actions require a genuine single-column primary key. Keyless and composite-key tables remain browse-only for existing records.

Testing

composer test

177 tests, 390 assertions.

License

MIT