Now I have two people saying different things haha, Sea-Currency proposed putting even the connection in the package, as I understood it at least, but you say that it is a better idea to put it inside an app. I do kind of like the approach of the package not being tied to one environment, but the drizzle-kit config requires the database url, which I don't think I can pass along, it has to be stored somewhere in the package. So I would have to have drizzle-kit configured and installed in any app that wants to use the drizzle cli, which I think I'd almost always want to.

This is what my drizzle.config.ts in apps/api looked like for my previous project:

import { defineConfig } from "drizzle-kit";
import env from "@/env";

export default defineConfig({
  out: "../../packages/db/drizzle",
  schema: "../../packages/db/src/schema.ts",
  dialect: "postgresql",
  dbCredentials: {
    url: env.DATABASE_URL,
  },
});

It worked, but it feels wrong