Download the PHP package clcbws/laravel-database-lifecycle-suite without Composer
On this page you can find all versions of the php package clcbws/laravel-database-lifecycle-suite. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download clcbws/laravel-database-lifecycle-suite
More information about clcbws/laravel-database-lifecycle-suite
Files in clcbws/laravel-database-lifecycle-suite
Package laravel-database-lifecycle-suite
Short Description A complete database lifecycle suite for Laravel including index standardization, data drift detection, and reverse-engineering.
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package laravel-database-lifecycle-suite
Laravel Database Lifecycle Suite
Laravel Database Lifecycle Suite is a premium toolkit designed for database reverse-engineering, optimization, and visualization. It provides a comprehensive 360-degree view of your database health, from structural integrity to performance bottlenecks. Fully optimized for Laravel 13.x, with legacy support for 12.x and 11.x.
📸 Showcase
Database Lifecycle Scorecard
Get a comprehensive health check of your database in one command.
Connection Latency Monitoring
Verify reachability and measure performance across all your database nodes.
Index Standardizer
Keep your index naming consistent across your entire application.
✨ Key Features
- 🌉 Legacy Bridge: Reverse-engineer an entire database into a clean Laravel project (Migrations, Models, Factories, Seeders).
- 📊 Lifecycle Scorecard: A quantifiable database health check covering performance, integrity, and connectivity.
- 📐 Index Standardizer: Automatically rename indexes to follow Laravel conventions.
- 🛡️ Index Health Audit: Detects unindexed Foreign Keys and Potential Foreign Keys (missing indexes on
_idcolumns). - 🔍 Redundant Index Detector: Identifies overlapping indexes that slow down write operations.
- 🔄 Data Drift Deep Dive: Compare data row-by-row across connections with interactive sync.
- 📸 Schema Snapshotting: Save schema states to JSON for offline comparison or time-travel restoration.
- 🎨 ERD Visualizer: Generate Mermaid.js Entity Relationship Diagrams directly from your schema.
- 🔒 PII Scanner: Identify potential security risks by scanning for sensitive data patterns.
- 📈 Size & Growth Report: Monitor disk usage and row counts across all tables.
- 🔬 Query Explainer: Get human-readable performance insights for any SQL query.
- 🧪 Cast & Type Audit: Detect discrepancies between Eloquent Model
$castsand physical DB types.
📦 Installation
You can install the package via composer:
[!TIP] To enable Structural Drift Detection in the
db:lifecycle-statusreport, we highly recommend also installing:composer require clcbws/laravel-schema-sentinel
Publish the configuration file:
🚀 Usage
1. Database Health & Auditing
Lifecycle Scorecard
To get a full overview of your database health:
Missing Index Audit
To identify unindexed Foreign Keys and potential performance bottlenecks:
PII Scanning
To identify sensitive data columns (Email, Phone, etc.):
2. Optimization & Standardization
Standardize Index Names
To fix non-standard index names (includes --dry-run support):
Find Redundant Indexes
To find overlapping indexes that should be removed:
3. Reverse Engineering & Visualization
Legacy Bridge
To reverse-engineer your database into a new Laravel project:
Generate ERD
To generate a Mermaid.js diagram of your database:
4. Snapshots & Data Integrity
Schema Snapshot
To save the current schema state:
Data Drift Check
To compare data records against a source connection:
🏗️ Architecture
The suite is built with a modular "Auditor-Engine" architecture:
- Auditors: Dedicated classes that analyze specific database traits (PII, Indexes, Casts).
- Engines: Reusable core components for Snapshotting, Drift Detection, and Code Generation.
- Traits: Standardized shared logic like
FiltersTablesfor multi-database isolation.
⚙️ Versioning System
We follow Semantic Versioning (SemVer):
- MAJOR (
1.x.x): Breaking changes or significant architectural shifts. - MINOR (
x.1.x): New features added in a backwards-compatible manner. - PATCH (
x.x.1): Backwards-compatible bug fixes and small improvements.
📄 License
The MIT License (MIT). Please see License File for more information.
🤝 Credits
- Author: Ahtesham
- Company: Broadway Web Service
All versions of laravel-database-lifecycle-suite with dependencies
illuminate/support Version ^11.0|^12.0|^13.0
illuminate/database Version ^11.0|^12.0|^13.0
illuminate/console Version ^11.0|^12.0|^13.0