db_scripts/delete_db.py

import os
import duckdb
from dotenv import load_dotenv

load_dotenv()

con = duckdb.connect(f"md:?motherduck_token={os.getenv('MOTHERDUCK_TOKEN')}")

# Drop all tables
query = '''
    DROP TABLE IF EXISTS FEEDBACK;
'''

con.execute(query)


query = '''
    DROP TABLE IF EXISTS AGENT_RESPONSES;
'''
con.execute(query)

query = '''
    DROP TABLE IF EXISTS RESPONSES;
'''
con.execute(query)

query = '''
    DROP TABLE IF EXISTS SESSIONS;
'''
con.execute(query)

query = '''
    DROP TABLE IF EXISTS USERS;
'''

con.execute(query)


con.close()

print("Database cleared")