dataroom/pages/api/health.ts

import type { NextApiRequest, NextApiResponse } from "next";

import prisma from "@/lib/prisma";

export default async function handler(
  _req: NextApiRequest,
  res: NextApiResponse,
) {
  try {
    await prisma.$queryRaw`SELECT 1`;

    return res.json({
      status: "ok",
      message: "All systems operational",
    });
  } catch (err) {
    console.error(err);

    return res.status(500).json({
      status: "error",
      message: (err as Error).message,
    });
  }
}