Tulip Database through a GUI based Client

Tulip database at pinger.slac.stanford.edu can be accessed through any mySQL client from Building 050 3rd floor at SLAC. The recommended client is mySQL Workbench, which can be downloaded from http://dev.mysql.com/downloads/workbench/5.2.html.
The read only version is avaialble via user scs_tulip_uro, host mysql-node01, port 3307. The password is available via cat /afs/slac/package/pinger/tulip/dbPwd/pws-tulipro. I am not sure about the read/write the notes which do not work, say:

you need to be on the slac internal network to be able to access this. User that has access to it is Tulip through port 1000 (it does not work with the VPN I believe the port is blocked).

Apart from exporting reports in diverse formats you can also do a quick row select, the output of which will show up in the Results tab. You can also manipulate the table as well by using the Alter, Create, and Drop commands. Table data can be directly manipulated using the Edit Table Data command; this lets you edit the contents of columns and rows in the table, just as if you were editing a spreadsheet.

Sql query box could be used to get custom results

Example insert query 

insert into `tulip`.`landmarks` values ('0', 'pinger.narss.sci.eg', 'pinger.narss.sci.eg', '195.43.3.135', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 'Cairo', NULL, 'Egypt', 'Aftrica', '30.1191', '31.3103',  'Pinger', NULL, 'http://pinger.narss.sci.eg/cgi-bin/traceroute.pl?function=ping',  'http://pinger.narss.sci.eg/cgi-bin/traceroute.pl?', NULL, NULL, '1', '0000-00-00 00:00:00', '');

* Make sure safe mode is off