edquint / sql-logger
Library for generating SQL logs from ORMs and raw queries
Requires
- jdorn/sql-formatter: ^1.2
Suggests
- doctrine/doctrine1: Required to enable SQL logging with Doctrine 1.
- doctrine/orm: Required to enable SQL logging with Doctrine 2.
- illuminate/database: Required to enable SQL logging with Eloquent ORM.
README
📄 Leia esta documentação em Português 🇧🇷
PHP SQL Logger
A simple library to generate SQL query logs and write them to log files.
Useful for inspecting how queries are being built, whether using ORMs like Doctrine 1, Doctrine 2, and Eloquent, or raw SQL queries.
📦 Installation
Add the library to your project via Composer:
composer require edquint/sql-logger
🚀 Features
- Automatically captures queries generated by popular ORMs.
- Supports raw queries.
- Saves logs to files in a configurable way.
- Easy integration into PHP projects.
Supported ORMs
- Doctrine 1
- Doctrine 2
- Eloquent
⚙️ Configuration
Configuration is done through the LoggerConfig
class, where you define:
- Directory for the log files.
- Name of the log file.
- Additional options.
Example:
use SqlLogger\Settings\LoggerConfig; LoggerConfig::setLogPath(__DIR__ . '/logs'); // Path where logs will be saved LoggerConfig::setFileName('queries.log'); // Log file name
✅ How to Use
The main class for generating logs is LogSql
.
1. Logging ORM queries
If you're using a supported ORM, simply pass the query instance to the orm
method:
use SqlLogger\LogSql; // Example with an ORM query (Doctrine, Eloquent, etc.) LogSql::orm($query);
This will convert the query to a formatted string and save it to the configured file.
2. Logging RAW (manual) queries
For manual SQL queries, just pass the query and parameters to the raw
method:
use SqlLogger\LogSql; $params = ['id' => 10]; $sql = "SELECT * FROM users WHERE id = :id"; LogSql::raw($sql, $params);
🔍 Log Output
The log will be saved in the configured directory in the following format:
[2025-08-02 19:00:00] Sql Query:
SELECT
*
FROM
users
WHERE
id = 10
📄 License
This project is licensed under the MIT license.
You can view the full license text in the LICENSE
file.