check_db_sync.js

const Database = require('better-sqlite3');
const path = require('path');

const db = new Database(path.join(process.cwd(), 'rag-kb.db'));

try {
  const count = db.prepare('SELECT count(*) as count FROM documents').get();
  console.log("Total documents:", count);
  
  const lastSync = db.prepare('SELECT max(synced_at) as last_sync FROM documents').get();
  console.log("Last synced at:", new Date(lastSync.last_sync).toLocaleString());

  const runningSync = db.prepare('SELECT * FROM knowledge_bases ORDER BY synced_at DESC LIMIT 5').all();
  console.log("Knowledge Bases:", runningSync);

} catch (error) {
  console.error("Database error:", error);
}