PyDal is a pure Python database abstraction layer. It provides a DBAPI 2.0 wrapper for DBAPI 2.0 drivers. Sounds strange, but even drivers that fully conform to the API can differ enough to make building database independent applications difficult.
jydbconsole is a database console inspired by psql - terminal-based front-end to PostgreSQL. Is written in jython and uses JDBC drivers to talk to databases, uses terminal console (unix only) or java swing as an user interface.