Picalo can connect to most relational databases. It can also load data from text files (CSV, EBCDIC, fixed width, etc.) and from email applications.  It provides a visual query editor (although we’d like to make it better) and can send any type of SQL to the engine of your choice.

As of 2010, Picalo ships with the following drivers:

• ODBC (pyodbc) – Connects to the operating system’s ODBC subsystem, which means it can talk with any database that has an ODBC driver (which means nearly all relational datbases in existence).
• SQLite (sqlite3) – An embedded database in Picalo that you are free to use.  SQLite is one of the most popular “light” databases available today.  It provides all the power of SQL without the need for a separate engine.  Just point it at a directory and start querying!
• MySQL (mysqldb) – A direct driver to connect to MySQL databases without the need for ODBC.
• PostgreSQL (pygresql & psycopg2) – Two drivers are available to connect to PostgreSQL databases without the need for ODBC.
• Oracle (cx_Oracle) – A direct driver to connect to Oracle without the need for ODBC.  This only works on the Windows version right now.