Index: server/authjs-handler.ts
===================================================================
--- server/authjs-handler.ts	(revision 8ee45534cd667e6cced2ed96968c95d8de3b1029)
+++ server/authjs-handler.ts	(revision 66bf4fdd2573ef9770d4f2d8dc1e5a8f3f842a7c)
@@ -3,29 +3,59 @@
 import type { Session } from "@auth/core/types";
 import { enhance, type UniversalHandler, type UniversalMiddleware } from "@universal-middleware/core";
+import {eq} from "drizzle-orm";
+import { db } from "../database/drizzle/db";
+import { usersTable } from "../database/drizzle/schema";
+import bcrypt from "bcrypt";
+// import { users, accounts, sessions, verificationTokens } from "../database/drizzle/schema/auth";
 
 const authjsConfig = {
   basePath: "/api/auth",
   trustHost: true,
-  // TODO: Replace secret {@see https://authjs.dev/reference/core#secret}
-  secret: "MY_SECRET",
+  secret: process.env.AUTH_SECRET,
+  session: {
+    strategy: "jwt",
+  },
   providers: [
-    // TODO: Choose and implement providers
     CredentialsProvider({
       name: "Credentials",
       credentials: {
-        username: { label: "Username", type: "text", placeholder: "jsmith" },
+        username: { label: "Username", type: "text" },
         password: { label: "Password", type: "password" },
       },
-      async authorize() {
-        // Add logic here to look up the user from the credentials supplied
-        const user = { id: "1", name: "J Smith", email: "jsmith@example.com" };
+      async authorize(credentials) {
+        const username = typeof credentials?.username === "string" ? credentials.username : null;
+        const password = typeof credentials?.password === "string" ? credentials.password : null;
 
-        // Any object returned will be saved in `user` property of the JWT
-        // If you return null then an error will be displayed advising the user to check their details.
-        // You can also Reject this callback with an Error thus the user will be sent to the error page with the error message as a query parameter
-        return user ?? null;
+        if(!username || !password) { return null; }
+
+        const user = await db.query.usersTable.findFirst({
+            where: eq(usersTable.username, username),
+        });
+
+        if(!user) { return null; }
+
+        const isPasswordValid = await bcrypt.compare(password, user.passwordHash);
+
+        if(!isPasswordValid) { return null; }
+
+        return {
+            id: String(user.id),
+            name: user.username,
+            email: user.email,
+        }
       },
     }),
   ],
+
+  callbacks: {
+      async jwt({ token, user }) {
+          if (user) token.sub = user.id;
+          return token;
+      },
+      async session({ session, token }) {
+          if (session.user && token.sub) session.user.id = token.sub;
+          return session;
+      },
+  },
 } satisfies Omit<AuthConfig, "raw">;
 
@@ -69,5 +99,5 @@
   },
   {
-    name: "my-app:authjs-middleware",
+    name: "pc-forge:authjs-middleware",
     immutable: false,
   },
@@ -83,5 +113,5 @@
   },
   {
-    name: "my-app:authjs-handler",
+    name: "pc-forge:authjs-handler",
     path: "/api/auth/**",
     method: ["GET", "POST"],
Index: server/db-middleware.ts
===================================================================
--- server/db-middleware.ts	(revision 8ee45534cd667e6cced2ed96968c95d8de3b1029)
+++ server/db-middleware.ts	(revision 66bf4fdd2573ef9770d4f2d8dc1e5a8f3f842a7c)
@@ -1,3 +1,4 @@
-import { dbSqlite } from "../database/drizzle/db";
+import { db } from "../database/drizzle/db";
+import type { Database } from "../database/drizzle/db";
 import { enhance, type UniversalMiddleware } from "@universal-middleware/core";
 
@@ -5,5 +6,5 @@
   namespace Universal {
     interface Context {
-      db: ReturnType<typeof dbSqlite>;
+      db: Database;
     }
   }
@@ -12,14 +13,10 @@
 // Add `db` to the Context
 export const dbMiddleware: UniversalMiddleware = enhance(
-  async (_request, context, _runtime) => {
-    const db = dbSqlite();
-
-    return {
-      ...context,
-      db: db,
-    };
-  },
+  async (_request, context) => ({
+    ...context,
+          db,
+  }),
   {
-    name: "my-app:db-middleware",
+    name: "pc-forge:db-middleware",
     immutable: false,
   },
Index: server/telefunc-handler.ts
===================================================================
--- server/telefunc-handler.ts	(revision 8ee45534cd667e6cced2ed96968c95d8de3b1029)
+++ server/telefunc-handler.ts	(revision 66bf4fdd2573ef9770d4f2d8dc1e5a8f3f842a7c)
@@ -1,3 +1,3 @@
-import type { dbSqlite } from "../database/drizzle/db";
+import type { Database } from "../database/drizzle/db";
 import { enhance, type UniversalHandler } from "@universal-middleware/core";
 import { telefunc } from "telefunc";
@@ -10,5 +10,5 @@
       body: await request.text(),
       context: {
-        ...(context as { db: ReturnType<typeof dbSqlite> }),
+        ...(context as { db: Database }),
         ...runtime,
       },
@@ -23,5 +23,5 @@
   },
   {
-    name: "my-app:telefunc-handler",
+    name: "pc-forge:telefunc-handler",
     path: `/_telefunc`,
     method: ["GET", "POST"],