DB Optimizer

DB Optimizer scans every table in your OpenCart database and recommends targeted indexes, InnoDB conversions, and table optimizations. Every change is named, tracked, and reversible with a single click.

DB Optimizer - Faster OpenCart Databases, Zero Guesswork

DB Optimizer is an admin-only OpenCart module that reads your database structure and surfaces concrete, conservative recommendations: missing indexes, MyISAM tables that should be InnoDB, and fragmented tables that waste space. Nothing is changed automatically - you review every suggestion and apply only what you want. Every index the module creates is named with your DB prefix and idx_, so it is instantly recognizable and fully reversible from the Applied tab.

Key Features

Scans all tables via INFORMATION_SCHEMA - core OpenCart tables and any third-party ones
Identifies missing indexes on foreign-key-like columns (*_id) and a curated OpenCart optimization baseline
Reports tables without a PRIMARY KEY, MyISAM tables, and fragmented tables
Heavy operations (InnoDB conversion, OPTIMIZE TABLE) are always manual and require confirmation
Module indexes are prefixed with idx_ and listed in the Applied tab - drop individually or roll back all
Configurable minimum row threshold, maximum new indexes per table, and table scope filter

Screenshots

DB Optimizer - Analysis tab showing index recommendations

Analysis tab - review recommendations before applying anything

DB Optimizer - Applied tab showing created indexes with drop and rollback options

Applied tab - every module index listed with Drop and Rollback all

Part of the AlexWaha OpenCart Module Bundle

DB Optimizer is included in the AlexWaha demo bundle - a collection of practical OpenCart modules built for real stores. Browse the full bundle to see every module running live on this demo store.

Free and open-source

DB Optimizer is part of the AlexWaha OpenCart bundle. Get the full source code, documentation and the ready-to-install ocmod package on GitHub.

View DB Optimizer on GitHub