shadow_brain_core/scratch/check_schema.py

import psycopg2
from sovereign_memory import DB_URL

def check_schema():
    conn = psycopg2.connect(DB_URL)
    cur = conn.cursor()
    cur.execute("SELECT column_name, data_type FROM information_schema.columns WHERE table_schema = 'taemingames' AND table_name = 'guardian_personas'")
    for row in cur.fetchall():
        print(f"{row[0]}: {row[1]}")
    cur.close()
    conn.close()

if __name__ == "__main__":
    check_schema()