PHPackages                             mage-os/module-eav-debug-views - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Debugging & Profiling](/categories/debugging)
4. /
5. mage-os/module-eav-debug-views

ActiveMagento2-module[Debugging & Profiling](/categories/debugging)

mage-os/module-eav-debug-views
==============================

Database views to aggregate EAV entity data for easier data analysis.

1.0.2(5mo ago)7172[1 PRs](https://github.com/mage-os-lab/module-eav-debug-views/pulls)AFL-3.0PHP

Since Dec 2Pushed 5mo ago1 watchersCompare

[ Source](https://github.com/mage-os-lab/module-eav-debug-views)[ Packagist](https://packagist.org/packages/mage-os/module-eav-debug-views)[ RSS](/packages/mage-os-module-eav-debug-views/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (3)Dependencies (4)Versions (4)Used By (0)

Mage-OS EAV Debug Views
=======================

[](#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
------------

[](#requirements)

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

Installation
------------

[](#installation)

```
composer require --dev mage-os/module-eav-debug-views
bin/magento setup:upgrade
```

Created Views
-------------

[](#created-views)

### 1. dev\_product

[](#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

[![2025-12-02_134111](https://private-user-images.githubusercontent.com/13335952/521504442-722bdd36-0d0c-4ee8-b586-baaec3927c70.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDQ0NDItNzIyYmRkMzYtMGQwYy00ZWU4LWI1ODYtYmFhZWMzOTI3YzcwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTc1NDMzOWFhYWM3ZDExNWM0NTRkY2IzNTE5MTNmZGRkYWM1ZjI5Nzc3MjQyZWU1OGFiNDMyMjI2MDBmYzJmZTYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.RZkU2agFXi08Lry14bYRRhB0Z875jl4fnyT1OEfrgTA)](https://private-user-images.githubusercontent.com/13335952/521504442-722bdd36-0d0c-4ee8-b586-baaec3927c70.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDQ0NDItNzIyYmRkMzYtMGQwYy00ZWU4LWI1ODYtYmFhZWMzOTI3YzcwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTc1NDMzOWFhYWM3ZDExNWM0NTRkY2IzNTE5MTNmZGRkYWM1ZjI5Nzc3MjQyZWU1OGFiNDMyMjI2MDBmYzJmZTYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.RZkU2agFXi08Lry14bYRRhB0Z875jl4fnyT1OEfrgTA)**Example Query:**

```
SELECT
    entity_id,
    sku,
    type_id,
    JSON_PRETTY(eav_attributes) as attributes
FROM dev_product
WHERE sku = 'my-product-sku';
```

**Extract Specific Attributes:**

```
SELECT
    entity_id,
    sku,
    JSON_EXTRACT(eav_attributes, '$.name') as name,
    JSON_EXTRACT(eav_attributes, '$.price') as price,
    JSON_EXTRACT(eav_attributes, '$.status') as status
FROM dev_product
WHERE entity_id = 1;
```

### 2. dev\_category

[](#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

[![2025-12-02_133915](https://private-user-images.githubusercontent.com/13335952/521503383-4b18f9bc-5785-416d-8f87-cbba207a6f60.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDMzODMtNGIxOGY5YmMtNTc4NS00MTZkLThmODctY2JiYTIwN2E2ZjYwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWFiMjEzZTdmODdhZTlkZmI1ZmJmOGY3ZmRkNDhhMTZjOGZiZTQ3OTU3NTFlNDQ5ZGYxM2MwYTVjYTcyZmE5ZjgmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.O2Zan3v07lgaqhRZAefEhL-M4gnDNldNjHi9_r41XqI)](https://private-user-images.githubusercontent.com/13335952/521503383-4b18f9bc-5785-416d-8f87-cbba207a6f60.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDMzODMtNGIxOGY5YmMtNTc4NS00MTZkLThmODctY2JiYTIwN2E2ZjYwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWFiMjEzZTdmODdhZTlkZmI1ZmJmOGY3ZmRkNDhhMTZjOGZiZTQ3OTU3NTFlNDQ5ZGYxM2MwYTVjYTcyZmE5ZjgmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.O2Zan3v07lgaqhRZAefEhL-M4gnDNldNjHi9_r41XqI)**Example Query:**

```
SELECT
    entity_id,
    parent_id,
    path,
    level,
    JSON_EXTRACT(eav_attributes, '$.name') as name,
    JSON_EXTRACT(eav_attributes, '$.is_active') as is_active
FROM dev_category
WHERE level = 2;
```

### 3. dev\_customer

[](#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

[![2025-12-02_133737](https://private-user-images.githubusercontent.com/13335952/521502856-6edaa2ab-71fa-4abf-b85b-aec1cbd27c7e.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDI4NTYtNmVkYWEyYWItNzFmYS00YWJmLWI4NWItYWVjMWNiZDI3YzdlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTFkMjk0MjJmYTZiNTE5ODA1MDQ4NDkyOTRmNWRkNWUzYzFhM2EzNGY1ZTVjMWUwNWVlOTRmOTU0MzZmNzRmMGUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.ebg4GTs9Jth01J_-YDQxfJv4ACKje5GEo5Kz0xeiet0)](https://private-user-images.githubusercontent.com/13335952/521502856-6edaa2ab-71fa-4abf-b85b-aec1cbd27c7e.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDI4NTYtNmVkYWEyYWItNzFmYS00YWJmLWI4NWItYWVjMWNiZDI3YzdlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTFkMjk0MjJmYTZiNTE5ODA1MDQ4NDkyOTRmNWRkNWUzYzFhM2EzNGY1ZTVjMWUwNWVlOTRmOTU0MzZmNzRmMGUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.ebg4GTs9Jth01J_-YDQxfJv4ACKje5GEo5Kz0xeiet0)**Example Query:**

```
SELECT
    entity_id,
    email,
    firstname,
    lastname,
    JSON_PRETTY(eav_attributes) as custom_attributes
FROM dev_customer
WHERE email LIKE '%@example.com';
```

### 4. dev\_address

[](#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

[![2025-12-02_134001](https://private-user-images.githubusercontent.com/13335952/521503789-8e06aa3b-0705-4d44-b251-99faa8157b47.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDM3ODktOGUwNmFhM2ItMDcwNS00ZDQ0LWIyNTEtOTlmYWE4MTU3YjQ3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTc3YTgxYjI4ZmY5YWVkNzYwNDljMWQ0ZDRlNzg0YWQ3MTVhMTMwMmExNDVmMzk2MDIxZmFhMTM4ZDhiZGE3OWUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.13MJTbVFFwcxZe0kpNoxMbUkYssq-mDNkT9n2nPjbNI)](https://private-user-images.githubusercontent.com/13335952/521503789-8e06aa3b-0705-4d44-b251-99faa8157b47.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDM3ODktOGUwNmFhM2ItMDcwNS00ZDQ0LWIyNTEtOTlmYWE4MTU3YjQ3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTc3YTgxYjI4ZmY5YWVkNzYwNDljMWQ0ZDRlNzg0YWQ3MTVhMTMwMmExNDVmMzk2MDIxZmFhMTM4ZDhiZGE3OWUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.13MJTbVFFwcxZe0kpNoxMbUkYssq-mDNkT9n2nPjbNI)**Example Query:**

```
SELECT
    entity_id,
    parent_id,
    city,
    country_id,
    JSON_PRETTY(eav_attributes) as custom_attributes
FROM dev_address
WHERE parent_id = 1;
```

### 5. dev\_product\_attribute

[](#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.*

[![2025-12-02_134337](https://private-user-images.githubusercontent.com/13335952/521505566-aaa3c3bc-917a-4fbf-8e7a-f6eefb9bc4e1.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDU1NjYtYWFhM2MzYmMtOTE3YS00ZmJmLThlN2EtZjZlZWZiOWJjNGUxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTViM2E5MjUwNWI1N2ZhNGY4MjRhOTk0YjM0NDhkMjA4ODU3MDQ2Y2RhMGRmYWJlNjQ3NzNiZmIwZmU4NmY2ZjEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.fsNkFafi9S9Tge4ZM6CJkTdi4BE92ECMv5ebW4aRnW0)](https://private-user-images.githubusercontent.com/13335952/521505566-aaa3c3bc-917a-4fbf-8e7a-f6eefb9bc4e1.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzQxNzk2MTksIm5iZiI6MTc3NDE3OTMxOSwicGF0aCI6Ii8xMzMzNTk1Mi81MjE1MDU1NjYtYWFhM2MzYmMtOTE3YS00ZmJmLThlN2EtZjZlZWZiOWJjNGUxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNjAzMjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjYwMzIyVDExMzUxOVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTViM2E5MjUwNWI1N2ZhNGY4MjRhOTk0YjM0NDhkMjA4ODU3MDQ2Y2RhMGRmYWJlNjQ3NzNiZmIwZmU4NmY2ZjEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.fsNkFafi9S9Tge4ZM6CJkTdi4BE92ECMv5ebW4aRnW0)**Example Query:**

```
SELECT
    attribute_id,
    attribute_code,
    backend_type,
    frontend_input,
    is_filterable,
    is_searchable,
    position,
    attribute_sets
FROM dev_product_attribute
WHERE is_filterable=1
ORDER BY attribute_code;
```

Store Scope
-----------

[](#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:**

```
-- Get product with global and store-specific names
SELECT
    entity_id,
    sku,
    JSON_EXTRACT(eav_attributes, '$.name') as global_name,
    JSON_EXTRACT(eav_attributes, '$.\"name:1\"') as store_1_name,
    JSON_EXTRACT(eav_attributes, '$.\"name:2\"') as store_2_name
FROM dev_product
WHERE sku = 'my-product';

-- See all attribute values including store-specific
SELECT
    entity_id,
    sku,
    JSON_PRETTY(eav_attributes) as all_attributes
FROM dev_product
WHERE entity_id = 1;
```

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
--------------------------

[](#performance-considerations)

### Query Optimization

[](#query-optimization)

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

**Fast:**

```
-- Uses entity table index
SELECT * FROM dev_product WHERE entity_id = 123;
SELECT * FROM dev_product WHERE sku = 'ABC123';
```

**Not fast:**

```
-- Full table scan with JSON parsing
SELECT * FROM dev_product
WHERE JSON_EXTRACT(eav_attributes, '$.status') = 1;
```

### View Characteristics

[](#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
--------------

[](#uninstallation)

```
bin/magento module:uninstall MageOS_EavDebugViews --remove-data
```

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
---------

[](#use-cases)

### Quick Product Debugging

[](#quick-product-debugging)

```
-- See all attributes for a specific product
SELECT entity_id, sku, JSON_PRETTY(eav_attributes)
FROM dev_product
WHERE sku = 'problematic-sku';
```

### Find Products with Specific Attribute Values

[](#find-products-with-specific-attribute-values)

```
-- Find disabled products
SELECT entity_id, sku,
       JSON_EXTRACT(eav_attributes, '$.status') as status
FROM dev_product
HAVING status = 2;
```

### Attribute Discovery

[](#attribute-discovery)

```
-- What custom attributes exist for products?
SELECT attribute_code, frontend_input, is_required
FROM dev_product_attribute
WHERE is_user_defined = 1;
```

### Category Hierarchy Analysis

[](#category-hierarchy-analysis)

```
-- View category tree with names
SELECT
    entity_id,
    level,
    path,
    JSON_EXTRACT(eav_attributes, '$.name') as name,
    JSON_EXTRACT(eav_attributes, '$.is_active') as active
FROM dev_category
WHERE level BETWEEN 1 AND 3
ORDER BY path;
```

License
-------

[](#license)

Open Software License (OSL-3.0)

Contributing
------------

[](#contributing)

Issues and pull requests welcome on GitHub.

Support
-------

[](#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.

###  Health Score

35

—

LowBetter than 80% of packages

Maintenance72

Regular maintenance activity

Popularity14

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity37

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~0 days

Total

3

Last Release

158d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/100189073?v=4)[Mage-OS](/maintainers/mage-os-ci)[@mage-os-ci](https://github.com/mage-os-ci)

---

Top Contributors

[![rhoerr](https://avatars.githubusercontent.com/u/13335952?v=4)](https://github.com/rhoerr "rhoerr (10 commits)")

---

Tags

devdebugmagento2magento 2eavmage-osdatabase-views

### Embed Badge

![Health badge](/badges/mage-os-module-eav-debug-views/health.svg)

```
[![Health](https://phpackages.com/badges/mage-os-module-eav-debug-views/health.svg)](https://phpackages.com/packages/mage-os-module-eav-debug-views)
```

###  Alternatives

[barryvdh/laravel-debugbar

PHP Debugbar integration for Laravel

19.1k124.3M621](/packages/barryvdh-laravel-debugbar)[mollie/magento2

Mollie Payment Module for Magento 2

1121.6M10](/packages/mollie-magento2)[php-debugbar/php-debugbar

Debug bar in the browser for php application

4.4k21.3M39](/packages/php-debugbar-php-debugbar)[fruitcake/laravel-debugbar

PHP Debugbar integration for Laravel

19.1k662.9k28](/packages/fruitcake-laravel-debugbar)[smile/module-debug-toolbar

Smile Debug Toolbar

146247.6k2](/packages/smile-module-debug-toolbar)[dotdigital/dotdigital-magento2-extension

Dotdigital for Magento 2

50374.2k18](/packages/dotdigital-dotdigital-magento2-extension)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)