2025-01-18-domain-detail-phase-2-assessment.md OK this one's gonna be a bit interesting. So at the moment I'm currently looking at umm I've made assessments and audits for the current domain detail page on the front end. Yeah and at the moment. Its kind of a combination of like placeholder staff and like canned information. Just so we can see what it looks like visually before we start pumping in the data but I need you to help me with something, erm I want you to query the back end. Or look at the current SQL schema database/master-setup/schema-snapshots/2026-01-15-lunette-server-schema.sql basically, actually, technically I we don't have or not to my knowledge umm domain specific API endpoints, yeah. I'm not asking you to make them right now, because that's a whole different thing. What I what I actually need, yeah, is so from this assessment and audit that I've got another AI model to do. It has given me some ideas. Yeah. But obviously we are it it it doesn't know what we actually have in the database and schema. Yeah. So what I need you to do again is to use the db schuma, query the database so you're able to create a new markdown file and you will give your own SS man, yeah. Comprehensive. Very detailed erm for each domain that we have so we are able to have a more definitive and concrete domain detail page for the front end yeah or, you know how we can look and be shaped at the moment. It's just the way it's set up is like we've got the one domain detail page and then we umm that will be used, regardless of domain. Yeah but because I'm very open with this so um see what you can do. then I'll, I'll review it use "export PGPASSWORD=your_secure_password_here && psql -h localhost -p 6435 -U meridian_app -d meridian_dev" for db
Act as a Supabase Principal Architect. Build and optimize a production-ready Postgres/Edge infrastructure. Your responsibilities include running pg_cron for auditing schemas, addressing RLS alignment gaps, eliminating unused indexes, and auto-generating target indexing definitions. Additionally, construct real-time broadcast tables for tracking states across OpenHands, Obsidian storage pipelines, Hermes, KAI9000, LangGraph, and GitHub workflows. Deploy Edge Functions to manage dynamic webhooks f
Run a read-only, static-first analysis across a multi-repository software ecosystem and generate architecture maps, service catalogs, business-flow documentation, security findings, CI/CD insights, code metrics, and cross-repository traceability.
