A very handy tool, especially when providing support to clients - you only have to ask for access to Joomla administrator, without needing separate database access. Nowhere near as powerful or complex as phpMyAdmin, but the essential features are there and it is dead easy to use.

This has been the single most useful extension I've installed on my site.

Whenever I'm developing, it's painful for me to maintain a phpMyAdmin page open alongside an admin page...it just IS...especially when you're running 2 different admin panels for 2 sites on the same database.

With this extension, I can query all the tables in the database across both sites - I can manually execute queries as well - to insert items, alter tables, etc.

On top of that, I'm sometimes behind a firewall that blocks port 8585 (which is what my phpMyAdmin runs out of on my web server) - so I don't get access to phpMyAdmin (painful, yes)...

With this extension, I don't need to. I can run everything simply and efficiently, all from the comfort of my Joomla! Admin console.

This component works fine but i need to change a line to make CSV export compatible with queries using quotes.

In administrator\components\com_easysql\admin.easysql.php
I change
$sql = mosGetParam( $_POST, 'easysql_query', null );

to

$sql = stripslashes(mosGetParam( $_POST, 'easysql_query', null ));

I this tool is really easy to install and use. I had trouble with data fields that content lists with returns in them like:

path=1
user=3
cont=4

and so on. The "to CSV" button did not use a text delimiter to contain field data like this. So I modified line 125 in admin.easysql.php to read:

$csv_values .= '"'.$val.'"'.$comma;

it was:

$csv_values .= $val.$comma;

Great Component.

I needed some way besides phpMyAdmin to load records into jos_content.

I was hoping this would be it, but it inserts every record twice.

Its OK for SELECT queries though

Why i cann't install it on J1.5 stable?
It says to me that i must enable the System - Legacy Plugin in the Plugin Manager but you said that you didn't have any problem?

Installed on J1.5 stable without a hitch. Works as advertised so far. Would love to see CREATE TABLE supported.

[I found that I could create tables by entering the full command in the free text area. It gives an error message but the tables were created exactly as specified. I don't recommend it but it worked for me.]

this component is so great as it's simple :)
Whenever you have some problem with other components/modules or whatever it is great help for debuging

I'm serious, this component is a lifesaver!! I've been needing to delete the tables from fireboard to do a clean install. Without phpmyadmin or any clue how to query a sql database, this program did it.

There is a dropdown list which doesn't list the command "drop", but it works fine if you throw the command into the blank window and hit execute.

Thanks for putting this together :)

This component is very simple, and surely could be expanded with other features, for example view / edit / create table structure, but it's a valid and useful alternative for sysadmin if phpMyAdmin is not available, to have a basic control of records. In fact, with this extension you can easily list, edit, delete and create records; in addiction there are also some useful queries like "SHOW STATUS" and "SHOW CREATE TABLE".

To use at best this extension, you should have a minimum SQL knowledge.

When I first checked this out and went to the home page and discovered it was Russian I thought bugger. Downloaded the component and unzipped and there was no help documentation either, again thought bugger. However, ever adventurous I uploaded it to my test site and it could not be easier. 95% of all the mysql functions have been predefined and you can very simply right your own query and see the results and then click a button and they are exported to a csv. Magic component.It is not quite as powerful as phpmyadmin but comes close.

Just 10 minutes after this tool comes up in the New Extensions category and here I go! Just what I was looking for! A _simple_ way to query SQL tables and get results displayed. I'll rate it after some serious testing. KRUTO!!!