#!/bin/bash # Quick database check script echo "===================================" echo "Database Quick Check" echo "===================================" echo -e "\nšŸ“Š Table Counts:" docker exec rag_ai_postgres psql -U postgres -d rag_ai_assistant -c " SELECT (SELECT COUNT(*) FROM users) as total_users, (SELECT COUNT(*) FROM users WHERE status='success') as authenticated, (SELECT COUNT(*) FROM users WHERE status='pending') as pending, (SELECT COUNT(*) FROM profiles) as total_profiles;" echo -e "\nšŸ‘„ Recent Users (last 5):" docker exec rag_ai_postgres psql -U postgres -d rag_ai_assistant -c " SELECT id, telegram_id, LEFT(token, 20) || '...' as token_preview, username, status, created_at FROM users ORDER BY created_at DESC LIMIT 5;" echo -e "\nšŸ“ Recent Profiles (last 5):" docker exec rag_ai_postgres psql -U postgres -d rag_ai_assistant -c " SELECT id, email, name, position, created_at FROM profiles ORDER BY created_at DESC LIMIT 5;" echo -e "\n===================================" echo "To run custom queries:" echo "docker exec -it rag_ai_postgres psql -U postgres -d rag_ai_assistant" echo "==================================="