List of tables, db schema, dump etc using the Python sqlite3 API

In Python:

con = sqlite3.connect('database.db')
cursor = con.cursor()
cursor.execute("SELECT name FROM sqlite_master WHERE type="table";")
print(cursor.fetchall())

Watch out for my other answer. There is a much faster way using pandas.