Using SQL Fiddle, admin users can query the database directly from their CRM instances, also can see the the details about the database, its tables and their corresponding columns..
SQL Fiddle is a plugin for SuiteCRM
This module provides SQL Editor functionality in SuiteCRM.
After installation you will find an extra item SQL Fiddle in the admin panel where you can query into database.
It connects to CRM database using database credentials mentioned in config file of CRM.
In the left side of window, you can see the details about the database, its tables and their corresponding columns.
Only admin users can query into database.
Installing the Add-on
The ONLY step
Install plug-in using Module Loader, Admin > Module Loader.
After installation, you'll get to see the link on admin section under Developer Tools.
After selecting SQL Fiddle, you'll get to see the following window
And, that's it.
1) Currently compatible with only MySQL database.
2) Not tested with complex queries.
1) Add icon.
2) Needs to Clean-up junk HTML, CSS, JS and PHP code.
3) Add support for other SuiteCRM supported database also.
Other add-ons of interest
Analytic Reporting Tool Basic
Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.