From 7b5f63285a7952a57fcfc6bc349869752f689b82 Mon Sep 17 00:00:00 2001
From: Mohamed Bassem <me@mbassem.com>
Date: Sat, 17 Jan 2026 23:33:52 +0000
Subject: feat: track api key usage dates

---
 packages/trpc/routers/apiKeys.ts | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'packages/trpc/routers/apiKeys.ts')

diff --git a/packages/trpc/routers/apiKeys.ts b/packages/trpc/routers/apiKeys.ts
index 763bc23a..90de824a 100644
--- a/packages/trpc/routers/apiKeys.ts
+++ b/packages/trpc/routers/apiKeys.ts
@@ -1,5 +1,5 @@
 import { TRPCError } from "@trpc/server";
-import { and, eq } from "drizzle-orm";
+import { and, desc, eq } from "drizzle-orm";
 import { z } from "zod";
 
 import { apiKeys } from "@karakeep/db/schema";
@@ -83,6 +83,7 @@ export const apiKeysAppRouter = router({
             name: z.string(),
             createdAt: z.date(),
             keyId: z.string(),
+            lastUsedAt: z.date().nullish(),
           }),
         ),
       }),
@@ -94,8 +95,10 @@ export const apiKeysAppRouter = router({
           id: true,
           name: true,
           createdAt: true,
+          lastUsedAt: true,
           keyId: true,
         },
+        orderBy: desc(apiKeys.createdAt),
       });
       return { keys: resp };
     }),
-- 
cgit v1.2.3-70-g09d2