SQL Fiddle

( From the Labs)

by ChangezKhan

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.

Introduction

SQLFiddle

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.

Install SQL Fiddle

Usage

After installation, you'll get to see the link on admin section under Developer Tools.

Link to SQL Fiddle

After selecting SQL Fiddle, you'll get to see the following window

SQL Fiddle

And, that's it.

  1. meirlicht member avatar

    meirlicht

    3 years ago

    Hi, thanks for the module. It would be helpful to be able to export the data. I'm also getting the following error after install on the admin page. LBL_USERS_TITLELBL_ADMINISTRATION_HOME_TITLELBL_EMAIL_TITLELBL_STUDIO_TITLELBL_JJWG_MAPS_ADMIN_HEADERLBL_SALESAGILITY_ADMINLBL_BUG_TITLE

    Thank you

Saving Comment Saving Comment...