ai-tools

Extracts and secures database schemas autonomously before dangerous refactorings, ensuring reliable restore points. Uses hm mysqldump to create timestamped backups with compression and verification.

Manages MySQL database operations in Dockergento using hm mysql commands. Use when importing SQL dumps, executing queries, managing databases, or troubleshooting database issues.

Executes shell commands inside Dockergento containers using hm bash and hm exec. Use when running PHP scripts, CLI commands, composer operations, or debugging container environments.

Manages Varnish cache activation in Dockergento using hm varnish-on and hm varnish-off commands. Use when testing full-page cache behavior, optimizing performance, or simulating production caching.

Enables or disables Xdebug in Dockergento environment using hm debug-on and hm debug-off commands. Use when debugging PHP code, profiling performance, or optimizing development workflow.

Transitions traditional SQL table management to declarative db_schema.xml standard, enabling validation and declarative data migration. Use when creating database tables, upgrading schemas, or modernizing legacy install/upgrade scripts. Requires Magento 2.3+ knowledge.

Generates schema.graphqls files and implements PHP resolvers to enable GraphQL data fetching for PWA architectures. Use when building headless storefronts, mobile apps, or custom admin interfaces. Requires Adobe Commerce/Magento 2 GraphQL knowledge.

Evaluates functional requirements and implements Magento 2 plugins (before, after, around interceptors) in di.xml without overloading execution flow. Use when extending core functionality, customizing business logic, or implementing integrations. Requires Adobe Commerce/Magento 2 knowledge.

Designs rigorous PHP interfaces and exposes them as REST API endpoints through webapi.xml for secure ERP/CRM integrations. Use when building API integrations, exposing custom functionality, or creating machine-to-machine communication. Requires Magento 2 API knowledge.

Audits codebase for obsolete hash functions (MD5, SHA1) and replaces with password_hash() using BCRYPT or ARGON2ID. Use when improving security, preparing for compliance audits, or modernizing authentication systems.

Identifies N+1 query problems in loops and refactors to use eager loading or batch collection. Use when facing performance issues, slow API responses, or excessive database queries.

Analyzes PHP call graph to identify and eliminate unreachable variables, properties, methods, and parameters. Use when refactoring legacy code, reducing technical debt, or optimizing codebase maintenance surface.

Converts scattered class constants used for state representation into native PHP 8.1 Enums. Use when modernizing PHP codebases, improving type safety, or refactoring state machines.

Detects loops loading massive datasets into memory and refactors them using yield keyword for efficient iterative processing. Use when facing memory issues, processing large datasets, or optimizing resource-intensive operations.

Replaces unpredictable magic methods (__get, __set, __isset, __unset) with explicit getters and setters for type inference and IDE support. Use when improving code maintainability, enabling static analysis, or refactoring legacy OOP structures.

Converts complex switch statements and chained if-else blocks into concise match expressions with strict return types. Use when modernizing PHP 8+ code or improving code clarity.