Download the PHP package mage-os/module-eav-debug-views without Composer

Mage-OS EAV Debug Views

Developer utility module for Magento 2.4.x that creates database views aggregating EAV entity data with attribute values in JSON format.

[!IMPORTANT]

This module is designed for development and debugging.

While production-installable, consider these factors:

• Database views may impact performance on large datasets
• JSON aggregation is resource-intensive for complex queries
• Intended for temporary debugging, not permanent production use
• No query optimization beyond entity_id lookups

Suggested Use: Install in development/staging only. Do not write code that would use these views on a live site.

Requirements

• Magento: 2.4.x
• PHP: 8.1+
• Database: MySQL 5.7+ or MariaDB 10.2.3+
  • Requires MySQL JSON function support

Installation

Created Views

1. dev_product

Combines catalog_product_entity with all EAV attributes aggregated as JSON.

Columns:

• All catalog_product_entity columns (entity_id, sku, type_id, etc.)
• eav_attributes (JSON) - All EAV attribute values from decimal, datetime, int, text, varchar tables

Example Query:

Extract Specific Attributes:

2. dev_category

Combines catalog_category_entity with EAV attributes.

Columns:

• All catalog_category_entity columns (entity_id, path, level, etc.)
• eav_attributes (JSON) - All EAV attribute values from decimal, datetime, int, text, varchar tables

Example Query:

3. dev_customer

Combines customer_entity with EAV attributes.

Columns:

• All customer_entity columns (entity_id, firstname, lastname, email, etc.)
• eav_attributes (JSON) - All EAV attribute values from decimal, datetime, int, text, varchar tables

Example Query:

4. dev_address

Combines customer_address_entity with EAV attributes.

Columns:

• All customer_address_entity columns (entity_id, firstname, lastname, street, city, etc.)
• eav_attributes (JSON) - All EAV attribute values from decimal, datetime, int, text, varchar tables

Example Query:

5. dev_product_attribute

Quick reference for product attribute metadata.

Columns:

• All eav_attribute columns (attribute_id, attribute_code, etc.)
• All catalog_eav_attribute columns (is_searchable, is_filterable, used_in_product_listing, etc.)
• attribute_sets (JSON) - All attribute sets and groups the attribute is assigned to, including IDs, names, and sort order.
• _@TODO: Add eav_options with all option IDs and values for DB-stored select and multiselect-type attributes._

Example Query:

Store Scope

All EAV views aggregate all store_id values into a single JSON object per entity.

Store-specific attribute keys use the format attribute_code:store_id (e.g., name:1, name:2). Global attributes (store_id = 0) use just the attribute_code (e.g., name, sku).

Example - Querying store-specific values:

For technical reasons, we can't sort attributes alphabetically. Scoped values for an attribute may appear anywhere within the JSON. (MySQL does not support sorting values within JSON_OBJECTAGG(...) in ONLY_FULL_GROUP_BY mode.)

Performance Considerations

Query Optimization

If filtering by attribute values, be careful about the amount of records processed.

Fast:

Not fast:

View Characteristics

• NOT materialized - Data is queried live from base tables
• NOT indexed - Uses base table indexes via entity_id
• CTE overhead - 5 subqueries per entity type
• JSON aggregation - Processing cost on SELECT

Recommendation: Use for ad-hoc debugging queries, not high-frequency production queries.

Uninstallation

This command:

1. Drops all module views from the database
2. Removes module from setup_module table
3. Removes module code (if installed via composer)

Use Cases

Quick Product Debugging

Find Products with Specific Attribute Values

Attribute Discovery

Category Hierarchy Analysis

License

Open Software License (OSL-3.0)

Contributing

Issues and pull requests welcome on GitHub.

Support

This is a community-maintained developer utility. No support or warranty implied. Use at your own risk.

For bugs or feature requests, please open an issue in the GitHub repository.