db_scripts/check_db.py

# read db content
import os
import duckdb
from dotenv import load_dotenv
load_dotenv()

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


user_query = """
SELECT * FROM USERS
"""

result = conn.execute(user_query).fetchdf()

print(result)


session_query = """
SELECT * FROM SESSIONS
"""

result = conn.execute(session_query).fetchdf()

print(result)

conn.close()