From 2f37974a4c84f7ffdd07e2c223eba2d8bd981b61 Mon Sep 17 00:00:00 2001
From: twells46 <173561638+twells46@users.noreply.github.com>
Date: Wed, 1 Apr 2026 15:20:50 -0500
Subject: Initial commit

---
 inspect_db.py | 34 ++++++++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)
 create mode 100644 inspect_db.py

(limited to 'inspect_db.py')

diff --git a/inspect_db.py b/inspect_db.py
new file mode 100644
index 0000000..0419f26
--- /dev/null
+++ b/inspect_db.py
@@ -0,0 +1,34 @@
+#!/usr/bin/env python3
+from __future__ import annotations
+
+import sqlite3
+from pathlib import Path
+
+DB_PATH = Path("storage/cmdhelp.db")
+
+
+def main() -> None:
+    conn = sqlite3.connect(DB_PATH)
+    try:
+        card_count = conn.execute("SELECT COUNT(*) FROM cards").fetchone()[0]
+        emb_count = conn.execute("SELECT COUNT(*) FROM card_embeddings").fetchone()[0]
+
+        print(f"cards: {card_count}")
+        print(f"embeddings: {emb_count}")
+        print()
+
+        rows = conn.execute("""
+        SELECT id, command, safety
+        FROM cards
+        ORDER BY id
+        LIMIT 10
+        """).fetchall()
+
+        for row in rows:
+            print(row)
+    finally:
+        conn.close()
+
+
+if __name__ == "__main__":
+    main()
-- 
cgit v1.2.3