values_to_insert = [(1,"foo"), (2, "bar"), (3, "baz")] cursor.executemany(""" INSERT INTO some_table ('item_num', 'item_name') VALUES (?, ?)""", values_to_insert)