const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();

async function main() {
  const tables = await prisma.$queryRawUnsafe(`
    SELECT table_name FROM information_schema.tables 
    WHERE table_schema = 'capability_schema' ORDER BY table_name
  `);
  console.log('=== capability_schema Tables ===');
  tables.forEach(t => console.log('-', t.table_name));
  
  const cols = await prisma.$queryRawUnsafe(`
    SELECT column_name FROM information_schema.columns 
    WHERE table_schema = 'capability_schema' AND table_name = 'prompt_templates'
    ORDER BY ordinal_position
  `);
  console.log('\n=== prompt_templates Columns ===');
  cols.forEach(c => console.log('-', c.column_name));
  
  await prisma.$disconnect();
}
main();