scripts/test-db-connection.ts

import { PrismaClient } from '@prisma/client';

async function testConnection() {
    console.log('🔄 Testing database connection...');

    try {
        const prisma = new PrismaClient();
        await prisma.$connect();

        // Test query
        const userCount = await prisma.user.count();
        console.log(`✅ Database connection successful! Found ${userCount} users.`);

        await prisma.$disconnect();
    } catch (error) {
        console.error('❌ Database connection failed:', error);
        process.exit(1);
    }
}

testConnection();