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.
Beta Version 0.1
SQL Fiddle is a plugin for SugarCRM
This module provides SQL Editor functionality in SugarCRM.
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) Compatibility with databases other than MySQL has not been tested.
2) Not tested with complex queries.
1) Remove Delete access.
2) Add icon.
3) Needs to handle scenarios, where results from query not returned.
4) Needs to Clean-up junk HTML, CSS, JS and PHP code.
Sohan U. S. Tirpude
Other add-ons of interest
Process Manager 4.5
Your Sugar Workflow Solution! Powerful Process Automation software for all editions of SugarCRM and SuiteCRM (Visit https://store.suitecrm.com/) that will allow you and your employees to spend more time doing what they do best: 'Selling To and Servicing Your Customers' and less time trying to manag...
Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and e...