PHPackages nfaiz/ci4-debug-toolbar - 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. [Database & ORM](/categories/database) 4. / 5. nfaiz/ci4-debug-toolbar Abandoned → [nfaiz/dbtoolbar](/?search=nfaiz%2Fdbtoolbar)Library[Database & ORM](/categories/database) nfaiz/ci4-debug-toolbar ======================= SQL Syntax Highlighter for CodeIgniter 4 Database Debug Toolbar. v1.3.0(4y ago)41.2kMITPHP Since Jul 4Pushed 4y ago1 watchersCompare [ Source](https://github.com/nfaiz/ci4-debug-toolbar)[ Packagist](https://packagist.org/packages/nfaiz/ci4-debug-toolbar)[ Docs](https://github.com/nfaiz/ci4-debug-toolbar)[ RSS](/packages/nfaiz-ci4-debug-toolbar/feed)WikiDiscussions main Synced today READMEChangelog (10)Dependencies (2)Versions (19)Used By (0) [![GitHub](https://camo.githubusercontent.com/64cd0cd171df699dfb30496f11e84b3c17264985d81df0a6085dbed23b275425/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f6e6661697a2f6369342d64656275672d746f6f6c626172)](https://camo.githubusercontent.com/64cd0cd171df699dfb30496f11e84b3c17264985d81df0a6085dbed23b275425/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f6e6661697a2f6369342d64656275672d746f6f6c626172)[![GitHub repo size](https://camo.githubusercontent.com/8827e10f7e16d00eb5cfa79e3674b3bdfe251c32085964839f3348cbe0631c18/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f7265706f2d73697a652f6e6661697a2f6369342d64656275672d746f6f6c6261723f6c6162656c3d73697a65)](https://camo.githubusercontent.com/8827e10f7e16d00eb5cfa79e3674b3bdfe251c32085964839f3348cbe0631c18/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f7265706f2d73697a652f6e6661697a2f6369342d64656275672d746f6f6c6261723f6c6162656c3d73697a65)[![Hits](https://camo.githubusercontent.com/cb45379163280ab42ae4f8c2f4339fcccc3083d49e031239a21b2fb98026a791/68747470733a2f2f686974732e736565796f756661726d2e636f6d2f6170692f636f756e742f696e63722f62616467652e7376673f75726c3d6e6661697a2f6369342d64656275672d746f6f6c626172)](https://camo.githubusercontent.com/cb45379163280ab42ae4f8c2f4339fcccc3083d49e031239a21b2fb98026a791/68747470733a2f2f686974732e736565796f756661726d2e636f6d2f6170692f636f756e742f696e63722f62616467652e7376673f75726c3d6e6661697a2f6369342d64656275672d746f6f6c626172) Moved to [here](https://github.com/nfaiz/dbtoolbar) =================================================== [](#moved-to-here) \# ci4-debug-toolbar SQL Syntax Highlighter for CodeIgniter 4 Database Debug Toolbar. Description ----------- [](#description) Make CodeIgniter 4 Database Debug Toolbar SQL Syntax to be **more readable and themeable**. Table of contents ----------------- [](#table-of-contents) - [Requirement](Requirement) - [Installation](#installation) - [Setup](#setup) - [Usage](#usage) - [Change stylesheet](#change-stylesheet) - [Utilities](#utilities) - [Screenshot](#screenshots) - [Default database toolbar](#default-database-toolbar) - [After Using Highlighter](#after-using-highlighter) - [Another Example](#another-example) - [Credit](#credit) Requirement ----------- [](#requirement) - [Codeigniter 4](https://github.com/codeigniter4/CodeIgniter4) - [Highlight.php](https://github.com/scrivo/highlight.php) Installation ------------ [](#installation) Install library via composer: ``` composer require nfaiz/ci4-debug-toolbar ``` Or refer [here](docs/MANUAL.md#installation) for manual installation. Setup ----- [](#setup) Library setup can be done via spark: ``` php spark debugtoolbar:database ``` This command will try to overwrite some content in **app/Config/Events.php** and **app/Config/Toolbar.php**. Choose overwrite \[`y`\] when prompted. Or refer [here](docs/MANUAL.md#setup) for manual setup. After library installation and setup are completed, refresh page to see result. See [usage](#usage) to configure with other pre-installed stylesheet themes. Usage ----- [](#usage) ### Change StyleSheet [](#change-stylesheet) Open **app/Config/Toolbar.php**. Find `$sqlCssTheme` property. ``` public $sqlCssTheme = [ 'light' => 'github', 'dark' => 'dracula' ]; ``` - `light` and `dark` are mode options for CodeIghniter 4 debug toolbar. - Assign stylesheet name without `.css` extension. E.g `'github'` - Available stylesheets can be found using [utilities](#utilities) ### Utilities [](#utilities) Use HighlightUtilities function from Highlight.php. Please see [highlighter-utilities](https://github.com/scrivo/highlight.php#highlighter-utilities) for more information. E.g In **Controller** ``` // Get available stylesheets. $list = \HighlightUtilities\getAvailableStyleSheets(); d($list); // Set true to get available stylesheets with absolute path. $listPath = \HighlightUtilities\getAvailableStyleSheets(true); d($listPath); // Get specific stylesheet path. $path = \HighlightUtilities\getStyleSheetPath('github'); d($path); ``` Screenshot ---------- [](#screenshot) ### Default Database Toolbar [](#default-database-toolbar) - Light [![Light mode](https://user-images.githubusercontent.com/1330109/125154813-894c0b80-e18e-11eb-8bf3-4e6834437ad9.png)](https://user-images.githubusercontent.com/1330109/125154813-894c0b80-e18e-11eb-8bf3-4e6834437ad9.png)- Dark [![Dark mode](https://user-images.githubusercontent.com/1330109/125154888-ef389300-e18e-11eb-88f6-7f066ec09775.png)](https://user-images.githubusercontent.com/1330109/125154888-ef389300-e18e-11eb-88f6-7f066ec09775.png)### After using highlighter [](#after-using-highlighter) - Light (using default.css) [![Light mode](https://user-images.githubusercontent.com/1330109/125154946-450d3b00-e18f-11eb-982f-93fcc3d09e06.png)](https://user-images.githubusercontent.com/1330109/125154946-450d3b00-e18f-11eb-982f-93fcc3d09e06.png)- Dark (using dark.css) [![Dark mode](https://user-images.githubusercontent.com/1330109/125155349-bf3ebf00-e191-11eb-922f-8b9bd9f12df8.png)](https://user-images.githubusercontent.com/1330109/125155349-bf3ebf00-e191-11eb-922f-8b9bd9f12df8.png)### Another example [](#another-example) - Light (using atom-one-light.css) [![Light mode](https://user-images.githubusercontent.com/1330109/125155187-bb5e6d00-e190-11eb-91a5-b4c2f7da46e4.png)](https://user-images.githubusercontent.com/1330109/125155187-bb5e6d00-e190-11eb-91a5-b4c2f7da46e4.png)- Dark (using atom-one-dark.css) [![Dark mode](https://user-images.githubusercontent.com/1330109/125155379-fca34c80-e191-11eb-981f-8fb6e8df9794.png)](https://user-images.githubusercontent.com/1330109/125155379-fca34c80-e191-11eb-981f-8fb6e8df9794.png)Credit ------ [](#credit) - [Highlight.php](https://github.com/scrivo/highlight.php) - Inspired by this [pull request](https://github.com/codeigniter4/CodeIgniter4/pull/3515) ### Health Score 30 — LowBetter than 64% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity19 Limited adoption so far Community7 Small or concentrated contributor base Maturity60 Established project with proven stability 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 ~1 days Total 17 Last Release 1753d ago PHP version history (2 changes)v1.0.0PHP >=7.2 v1.1.0-betaPHP ^7.3 || ^8.0 ### Community Maintainers ![](https://www.gravatar.com/avatar/8e60dcc2e275d40f209a301e76730c4ade96dead7878dd4d6483ac1d01a67d84?d=identicon)[nfaiz](/maintainers/nfaiz) --- Top Contributors [![nfaiz](https://avatars.githubusercontent.com/u/1330109?v=4)](https://github.com/nfaiz "nfaiz (101 commits)") --- Tags codeigniterdebuggingphpsqltoolbardebugtoolbardatabasesqlcodeignitersyntaxhighlight.phpcodeigniter4 ### Embed Badge ![Health badge](/badges/nfaiz-ci4-debug-toolbar/health.svg) ``` [![Health](https://phpackages.com/badges/nfaiz-ci4-debug-toolbar/health.svg)](https://phpackages.com/packages/nfaiz-ci4-debug-toolbar) ``` ### Alternatives [doctrine/dbal Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. 9.7k578.4M5.6k](/packages/doctrine-dbal)[illuminate/database The Illuminate Database package. 2.8k52.4M9.3k](/packages/illuminate-database)[ifsnop/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k5.5M69](/packages/ifsnop-mysqldump-php)[aura/sqlquery Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library. 4572.9M34](/packages/aura-sqlquery)[tatter/relations Entity relationships for CodeIgniter 4 9022.3k1](/packages/tatter-relations)[tatter/schemas Database schema management, for CodeIgniter 4 2328.5k1](/packages/tatter-schemas) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)