utils/sql_utils.py

import sqlite3


def list_tables(db_path):

    connection = sqlite3.connect(db_path)

    cursor = connection.cursor()

    cursor.execute("""



        SELECT name



        FROM sqlite_master



        WHERE type='table' AND name NOT LIKE 'sqlite_%'



    """)

    tables = cursor.fetchall()

    connection.close()

    return [x[0] for x in tables]