Smart Pivot Table is an open-source, PHP tool for building MySQL Pivot Tables visually — with no coding required, distributed under the MIT license.
It allows you to:
- Create pivot tables visually, without writing any complex SQL statements.
- Define rows, columns, values, and relationships using dropdowns.
- View instant summaries of your data in a clean UI.
- Customize the code freely if you know PHP.
Whether you’re a developer, data analyst, or business user, this tool makes it easy to explore your MySQL data — with zero code.
Built entirely using native PHP, it’s lightweight, easy to set up, and released under the MIT License — giving you full freedom to use, modify, and distribute it even in commercial projects.
👉 However, if you’re looking for a more advanced and modern experience — including a drag-and-drop pivot table builder, dynamic filters, and enhanced features — check out the latest module in Smart Report Maker:
https://mysqlreports.com/php-mysql-pivot-tables/
To install Smart Pivot Table:
-
Place the
MPTdirectory inside a folder located within your web server's root directory (e.g.,htdocsorwww). -
Open your browser and navigate to it:
localhost/path-to-MPT/MPT -
This should take you to the login setup page:
localhost/path-to-MPT/MPT/wizard/login.php?from=setconfig
You’ll see a signup page where you can create your Admin profile.
After signing up:
- The system will instruct you to delete the signup file for security reasons.
- Once done, log in using the Admin account you created.
After logging in, you’ll be greeted with a simple, intuitive interface to visually build your MySQL Pivot Tables.
If you need advanced filtering options, custom parameters, or a more powerful pivot table builder, check out the upgraded module in Smart Report Maker:
Explore our drag-and-drop editor for building MySQL Pivot Tables effortlessly.