MCP Data Layer

Your tasks.
Your agent. Your rules.

A typed MCP server and a clean dashboard over a single self-hosted Postgres. Your OpenClaw agent writes. Your browser reads. No SaaS. No AI in the dashboard — that's the point.

The shape

Two front doors.
One database.

The MCP server at /api/mcp is the agent's interface — 34 typed tools, 13 prompt templates, bearer-token auth.

The dashboard is a plain Next.js UI for the same Postgres. No AI, no chatbot, no generate buttons. If you want generated content, you talk to OpenClaw.

Tailscale is the perimeter. If you can reach the URL, you're in.

OpenClaw agent MCP client Browser dashboard Next.js UI /api/mcp Bearer auth /api routes CRUD Drizzle ORM Postgres 17 tables Bearer fetch SQL
What's in it

A durable store for the life stuff you already track

Tasks, habits, journal, workouts, focus sessions, goals. All in Postgres, all behind one typed API.

Tasks

Franklin Covey A1C9 priority, rollover, recurrence, space + goal linking.

Habits

Daily or weekly, ISO-weekday target days, streak tracking via a dead-simple log table.

📓

Journal

One entry per day, mood 1–5, full-text search across everything you've ever written.

Workouts

Templates and logged sessions. Strength, timed, or cardio. Per-exercise sets, reps, weight.

Focus sessions

Pomodoro timer data, optionally linked to a task. 1–480 min duration, 0–120 min break.

Goals

Categories, progress %, target dates, a progress log table for trend lines.

Spaces

Projects / areas of life that group tasks, habits, and goals under a single umbrella.

Daily briefings

Written by OpenClaw via save_daily_briefing. Displayed read-only on the dashboard.

§

Weekly reviews

Written by OpenClaw via save_weekly_review. Displayed read-only on the dashboard.

Under the hood

Built with boring, battle-tested pieces

No framework-of-the-week. Nothing you haven't seen before.

Next.js 16 React 19 TypeScript 5 Tailwind CSS 4 Drizzle ORM Postgres 16 @modelcontextprotocol/sdk Docker Compose Tailscale Vitest

Deploy it yourself.
Own the data.

Docker + Compose + Tailscale on any VPS. Five-minute happy path, fully documented.