Agency Management & Command Core

Techmero Dashboard (DevVault) Specification

The central operational command cockpit for Techmero. Unifies project delivery, task boards, encrypted credentials, infrastructure monitoring, domain health, and integrates directly with Ember Chat, SuperBot, Meetnotes AI, and HScreens.

● NEXT.JS 16 APP ROUTER ● DRIZZLE ORM + POSTGRESQL ● CENTRAL COMMAND HUB

MODULE 01

The Centralization Cockpit: How the Dashboard Unifies All Tools

ECOSYSTEM HUB

The Dashboard is not an isolated CRUD app—it is the master source of truth and administrative cockpit for the entire agency. Every other tool (Ember, SuperBot, Meetnotes, HScreens, and Store Poller) either reads project metadata from or writes updates into the Dashboard's PostgreSQL database.

DASHBOARD CENTRALIZATION: CONNECTIVITY TO ALL INTERNAL TOOLS

%%{init: {'theme': 'base', 'themeVariables': { 'darkMode': false, 'background': '#f8f9fa', 'primaryColor': '#ffffff', 'primaryTextColor': '#09090b', 'primaryBorderColor': '#18181b', 'lineColor': '#52525b', 'clusterBkg': '#ffffff', 'clusterBorder': '#d4d4d8' }}}%% flowchart LR subgraph CHAT["COMMUNICATION LAYER"] EMBER["💬 Ember Chat Engine
(:8080 workerd)
• Embedded Project Tabs
• Auto-created #project rooms"] end subgraph CORE["CENTRAL COMMAND COCKPIT (HETZNER VPS)"] direction TB DASH["🖥️ TECHMERO DASHBOARD
(DevVault Next.js 16)
• Projects & Kanban Board
• Credentials Vault (AES-256)
• Server & Domain Health
• Activity & Security Logs"] DB[("🐘 PostgreSQL 16
(Central Relational Store)")] DASH <-->|Drizzle ORM Queries| DB end subgraph AUTOMATION["AI & SPECIALIZED ENGINES"] direction TB SUPERBOT["🤖 SuperBot Daemon
(Inserts Tasks into Kanban)"] MEETNOTES["🎙️ Meetnotes AI
(Pushes Transcripts to Notes)"] HSCREENS["🎨 HScreens Studio
(Exports Store Assets)"] POLLER["🚨 Store Poller
(Flags Rejection Bugs)"] end DASH -->|1-Click Provision Room| EMBER EMBER -->|Deep-Link SSO Chat Tab| DASH SUPERBOT -->|Writes Extracted Tasks| DB MEETNOTES -->|Saves Meeting Action Items| DASH HSCREENS -->|Attaches Mockup URLs| DASH POLLER -->|Inserts Critical Bug Tickets| DB

MODULE 02

The 8 Feature Pillars of the Dashboard

NATIVE MODULES

The dashboard organizes agency operations into 8 comprehensive functional pillars, fully implemented across Next.js 16 server actions, Drizzle schemas, and UI components:

📁 Projects Hub LIFECYCLE

Multi-client project directory tracking status (development, production, archived), assigned team members, git repository links, and production URLs.

📋 Kanban Tasks SPRINT BOARD

Drag-and-drop sprint board for agency deliverables. Automatically updated in real-time by SuperBot when tasks are mentioned in Ember chat or flagged by store poller.

🔐 Credentials Vault AES-256-GCM

Zero-knowledge encrypted storage for client API keys, database credentials, SSH private keys, and Apple/Google store developer tokens.

🖥️ Server Watcher INFRASTRUCTURE

Live uptime, CPU, memory, and disk health monitoring for the Hetzner Linux VPS host and the office Mac Mini GPU node over Tailscale.

🌐 Domain Registry SSL & DNS

Central repository of all agency and client domain names. Tracks Let's Encrypt certificate expiry dates, DNS nameserver records, and active HTTP status.

🔌 Integrations Hub CONNECTORS

Direct connection status for Stripe, Resend, Sentry, AWS S3, GitHub, and OpenAI. Verifies credential health and displays provider dashboards.

🎙️ Meeting Intelligence MEETNOTES SYNC

Archived transcripts, executive summaries, and action item logs automatically imported from Meetnotes AI calls for each project.

📜 Audit & Security Log COMPLIANCE

Immutable log of all administrative actions: vault decryptions, project creation, role changes, and bot status syncs with IP and actor tracking.

MODULE 03

1-Click Project Space Provisioning Pipeline

AUTOMATION FLOW

When an agency manager provisions a new project in the Dashboard (/projects/new), a single Server Action orchestrates the entire operational setup across all internal tools.

1-CLICK PROVISIONING ORCHESTRATION

%%{init: {'theme': 'base', 'themeVariables': { 'darkMode': false, 'background': '#f8f9fa', 'primaryColor': '#ffffff', 'primaryTextColor': '#09090b', 'primaryBorderColor': '#18181b', 'lineColor': '#52525b', 'clusterBkg': '#ffffff', 'clusterBorder': '#d4d4d8' }}}%% flowchart LR PM["👔 PM Submits Project Form
(Name: QuickFood App)"] ACTION["⚡ createProjectAction()
(app/(app)/projects/actions.ts)"] DB_PROJ["🐘 PostgreSQL INSERT
(projects, environments)"] EMBER_ROOM["💬 Ember POST /api/rooms
(Creates #project-quickfood)"] VAULT_SLOT["🔐 Vault Slot Provisioned
(API Keys & App Store Secrets)"] CONFIRM["✅ Ready Dashboard Overview
(Deep-links to Chat & Kanban)"] PM -->|Submit Form| ACTION ACTION -->|1. Save Record| DB_PROJ ACTION -->|2. Webhook Call| EMBER_ROOM ACTION -->|3. Init Encryption| VAULT_SLOT ACTION -->|4. Redirect| CONFIRM

MODULE 04

Kanban Task Board & SuperBot Bidirectional Sync

REAL-TIME SYNC

The Dashboard Kanban board eliminates manual task status maintenance. SuperBot autonomously updates ticket stages based on developer chat, PR merges, and store review changes.

1. BACKLOG / TODO

Auto-created by Meetnotes AI action items and client requirements.

2. IN PROGRESS

Moved automatically when a developer says "I'm working on #42" in Ember.

3. CODE REVIEW / QA

Moved when a PR is opened on GitHub; Code Gatekeeper scans the diff.

4. DONE / PROD

Moved when App Store Sentinel detects approval on Apple or Google store.

MODULE 05

Credentials Vault & Infrastructure Node Monitoring

SECURITY & OPS

1. SECURE SECRETS VAULT (AES-256-GCM)

Eliminates shared passwords in Slack or text files. The vault securely stores:

• Apple App Store Connect API Keys (Issuer ID, Key ID, AuthKey.p8)
• Google Play Service Account JSON keys
• Production PostgreSQL & Redis connection strings
• Stripe Secret & Webhook Signing Keys

2. HOST INFRASTRUCTURE STATUS

Real-time ping and status health for the two physical hosts:

Hetzner Linux VPS (Host 1): Dashboard, Ember, SuperBot, Postgres

ACTIVE // 100%

Mac Mini M2 Pro (Host 2): Meetnotes AI, HScreens, WhisperKit GPU

TAILSCALE // UP

MODULE 06

Embedded Ember Chat Inside Project Overview

UNIFIED UX

To prevent developers and project managers from constantly switching browser tabs, the Dashboard renders a dedicated "Project Chat" tab directly inside /projects/[id].

EMBEDDED PROJECT CHAT WIREFRAME

QuickFood Mobile App PROJECT OVERVIEW

Overview Kanban Board 💬 Project Chat (#project-quickfood) Vault Secrets

Powered by Better Auth Single Sign-On. Ember runs in an isolated, high-performance secure frame, connecting directly to /api/rooms/project-quickfood over WebSocket.

MODULE 07

PostgreSQL Relational Schema & Technology Stack

DATA MODEL

The Dashboard is built on top of standard production technologies with zero proprietary vendor runtime requirements:

FRONTEND & API: Next.js 16 (React 19, Server Actions, App Router)

DATABASE & ORM: PostgreSQL 16 with Drizzle ORM (Type-safe SQL)

AUTHENTICATION: Better Auth (Session cookies + RBAC roles)

STYLING & ICONS: Tailwind CSS + shadcn/ui + Tabler Icons

Schema Table	File Location in `TOOLS/Project Manager`	Key Attributes	Role in Ecosystem
`projects`	`lib/db/schema/projects.ts`	id, workspaceId, name, slug, status, productionUrl, logoUrl	Central project identity referenced by all tools
`vault_items`	`lib/db/schema/vault.ts`	id, projectId, key, encryptedValue, iv, authTag	Encrypted API credentials for App Store, Stripe, Sentry
`infrastructure`	`lib/db/schema/infrastructure.ts`	id, hostname, ipAddress, provider, status, cpuCores	Server nodes (Hetzner VPS + Mac Mini GPU node)
`domains`	`lib/db/schema/domains.ts`	id, projectId, domainName, sslStatus, sslExpiresAt	Client domain registry and Let's Encrypt certificate health
`activity_logs`	`lib/db/schema/audit.ts`	id, actorId, action, targetType, targetId, ipAddress	Immutable audit log for security compliance