Add database admin UI for viewing/managing data

[nicholaspsmith]

Context

Drizzle Studio (npm run db:studio) has been removed due to persistent bugs - the hosted frontend at local.drizzle.studio fails to connect to the local backend with /init 404 errors. This is a known upstream issue.

Requirement

Provide a way to view and manage database contents during development and potentially in production (admin-only).

Alternative Options

For Development (External Tools)

Tool	Pros	Cons
TablePlus	Beautiful UI, free tier	Proprietary, paid for full features
DBeaver	Free, open source, feature-rich	Java-based, heavier
pgAdmin 4	Official PostgreSQL tool, web-based	Complex UI

Built-in Options

Approach	Pros	Cons
Custom Admin UI	Full control, integrated auth, works in production	Development effort
Prisma Studio	Similar to Drizzle Studio	Adds Prisma dependency
Drizzle Gateway	Official hosted solution	Paid ($20/year)

Recommendation

1. Short-term: Use TablePlus or DBeaver for local development
2. Long-term: Build a custom admin UI page at /admin/database with:
   • Table browser
   • Query executor
   • Protected by admin auth
   • Useful for production debugging

Acceptance Criteria

• Developers can view database tables and contents
• Works reliably (unlike Drizzle Studio)
• Optionally accessible in production for admins