Scan app/api/ and delete unused route handlers. Update references in app/ and src/, ensuring no broken functionality. Use Prisma for type-safe queries instead of raw SQL. Implement error handling in routes with try-catch and return 404 for invalid endpoints. Trigger npm run build to verify.