delickate/query-analyzer

There is no license information available for the latest version (dev-main) of this package.

Analyze and optimize Laravel queries

dev-main 2026-03-16 04:46 UTC

Requires

• php: ^7.3|^8.0
• illuminate/contracts: ^8.0|^9.0|^10.0|^11.0

Unknown License

• Sani Hyne

README

A Laravel package to interactively analyze and run SQL queries on your database with ease.

Features

• List all database tables in a convenient sidebar.
• Show table columns dynamically on clicking each table.
• Write and execute raw SQL queries using a simple query editor.
• Display query results in a clean, scrollable tabular format.
• Easy to publish configuration and stub files to your Laravel application.
• Built with a minimal setup to integrate smoothly into existing Laravel projects.

Installation

Install the package via Composer:

> composer require delickate/query-analyzer
> php artisan vendor:publish --tag=query-analyzer --force

Copy following routes to routes/web.php

use App\Http\Controllers\QueryAnalyzerController;


Route::get('/query-analyzer', [QueryAnalyzerController::class,'index']);

Route::get('/query-analyzer/tables', [QueryAnalyzerController::class,'tables']);
Route::get('/query-analyzer/columns/{table}', [QueryAnalyzerController::class,'columns']);
Route::post('/query-analyzer/execute', [QueryAnalyzerController::class,'execute']);

🤝 Contributing

Contributions are welcome.

1. Fork the repository
2. Create your feature branch
3. Commit your changes
4. Open a Pull Request

📄 License

This package is open-sourced software licensed under the MIT license.

🏢 Maintained By

Developed and maintained by Delickate.