test.py

isql for acess,sqlite , mysql etc

import sqlite
c=sqlite.connect(r"trac.db",autocommit=1)
cur=c.cursor()
cur.execute("select tbl_name from sqlite_master where type='table' order by tbl_name")
tables = []
for row in cur.fetchall():
        tables.append(row.tbl_name)
print tables
r=cur.execute("drop table ma")
r=cur.execute("create table ma(id integer primary key,s char[20])")
r=cur.execute("insert into ma(id,s) values(1,'ma')")
r=cur.execute("select * from ma")
print cur.fetchall()