logger_db

Logger DB is an extended Drupal logging module that stores structured logs in JSON format within the SQL database. It captures raw placeholder values and metadata—including all nested objects—and stores them as separate values. Log timestamps are recorded with microsecond precision.

It provides Views-based UI reporting pages in the Drupal admin panel, with the ability to display custom log entry columns as plain text or number formatters for scalar values, and JSON/YAML formatters for complex values—including tested values using JSONPath, such as $.metadata.ai.token_usage.total.

You can filter and sort logs by custom field values, including nested fields, using JSONPath.

Logger DB has no mandatory dependencies and works seamlessly with the core Drupal Logger. However, to fully customize log fields, it is recommended to use extended logger modules such as Logger or Monolog, which are already integrated and automatically extended by Logger DB.

Features

• Stores structured logs in the local SQL database as a single JSON column.
• Records log entry timestamps and request start times with microsecond precision, allowing measurement of time spent on operations for each request.
• Supports storing nested structures of any size and depth from the context array as nested JSON objects.
• Provides a convenient, customizable Views-based UI to view logs directly in the Drupal admin panel.
• Allows creation of multiple log report pages in the admin panel, displaying only required custom columns with custom context filters.
• Provides exporting logs to a file and importing from a file, with merging and deduplication of entries.
• Supports filtering logs by date and time range, and by any custom field values using JSONPath.
• Offers Drupal Views field and filter plugins to build custom log view pages, displaying only relevant fields.
• Can clean up old log entries by age or by limiting the total number of log entries.

Requirements

Logger DB has no mandatory dependencies and works with the core Drupal Logger.

For advanced log customization, use extended loggers like Logger or Monolog. Logger DB is already integrated with these modules and will automatically extend their functionality when they are installed.

Additional recommended modules

• Request Logger: Logs every request to the logger with performance metrics (duration, memory usage, cache status, etc.), and attaches a unique request ID to each log entry, allowing you to easily filter logs by a specific request.
• Events Log Track: Allows logging specific user actions such as user authentication, node, comment, and other entities operations (create, update, delete), workflow actions, configuration changes, etc.