Download the PHP package cleaniquecoders/db-schema-auditor without Composer
On this page you can find all versions of the php package cleaniquecoders/db-schema-auditor. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download cleaniquecoders/db-schema-auditor
More information about cleaniquecoders/db-schema-auditor
Files in cleaniquecoders/db-schema-auditor
Package db-schema-auditor
Short Description Audit Database Schema Design
License MIT
Homepage https://github.com/cleaniquecoders/db-schema-auditor
Informations about the package db-schema-auditor
Audit Database Schema Design
Audit Database Schema Design.
Installation
You can install the package via composer:
You can publish and run the migrations with:
You can publish the config file with:
Usage
Supported Database Types
This package supports all major database types:
- MySQL / MariaDB - Full support for indexes, foreign keys, and constraints
- PostgreSQL - Complete support including partial indexes and advanced features
- Microsoft SQL Server - Full support for SQL Server specific features
- Oracle - Support for Oracle-specific indexes and constraints
- SQLite - Basic support for SQLite databases
Output Formats
- console (default) - Colored terminal output with recommendations
- json - Machine-readable JSON format for integration
- markdown - GitHub-flavored markdown for documentation
- csv - Spreadsheet-compatible format for analysis
- html - Styled HTML report for sharing
What Gets Audited
Database Structure:
- Missing indexes on foreign key columns
- Missing indexes on commonly queried columns
- Missing unique constraints
- Missing foreign key constraints
- Orphaned records in relationships
- Suspicious column patterns
Model Relationships (with --models flag):
- Missing inverse relationships
- Relationship naming inconsistencies
- Missing model relationships for database foreign keys
- Relationship method issues
Generated Outputs
Migration Files (with --generate-fixes):
- Index creation migrations
- Unique constraint migrations
- Foreign key suggestion migrations (commented for review)
- Orphaned record cleanup scripts
Database Storage (with --save-database):
- Complete audit history
- Issue tracking and resolution status
- Model analysis results
- Performance trending over time
Testing
Changelog
Please see CHANGELOG for more information on what has changed recently.
Contributing
Please see CONTRIBUTING for details.
Security Vulnerabilities
Please review our security policy on how to report security vulnerabilities.
Credits
- Nasrul Hazim Bin Mohamad
- All Contributors
License
The MIT License (MIT). Please see License File for more information.
All versions of db-schema-auditor with dependencies
cleaniquecoders/traitify Version ^1.1
illuminate/contracts Version ^11.0||^12.0||^13.0
lorisleiva/laravel-actions Version ^2.9
spatie/laravel-package-tools Version ^1.16