chriso789
Community@chriso789
Governance skills for a multi-tenant roofing CRM on Supabase: tenant isolation, edge function consolidation, and AI roof-measurement QA.
Agent Skills by chriso789
Showing 18 vetted skills indexed across 1 GitHub repositories.
chriso789measurement-overlay-visual-qa
Validates aerial-backed measurement overlay rendering and manual perimeter verification UI.
chriso789pitch-crm-architecture-guard
Enforces grouped Supabase edge function architecture and tenant security rules for Pitch CRM backend work.
chriso789ai-measurement-regression-harness
Enforces regression tests for AI roof measurement pipeline fixes against canonical baselines.
chriso789edge-function-consolidator
Audits Supabase edge functions and produces a consolidation plan with bucket classifications.
chriso789pitch-crm-tenant-security-enforcer
Enforces multi-tenant isolation, RLS, and auth rules on Supabase edge functions and CRM code changes.
chriso789supabase-schema-db-drift-guard
Prevents Supabase schema drift and PostgREST cache errors in measurement pipeline migrations and edge function writes.
chriso789migration-readiness-scanner
Classifies Lovable project components as portable, partial, or locked for migration planning.
chriso789supabase-health-doctor
Expands the supabase-health edge function into a 13-check backend inspection system with a master-only admin dashboard.
chriso789rooftrace-ai
Implements perimeter-first AI roof tracing with calibration, topology, and immutable measurement revisions.
chriso789pitch-crm-route-migration-enforcer
Migrates legacy Supabase Edge Function calls into grouped API routes with shims and audit reporting.
chriso789webhook-queue-repair
Diagnose stuck jobs, failed webhooks, and poison queue rows across backend worker surfaces.
chriso789database-index-optimizer
Audits Postgres databases for missing, duplicate, and unused indexes and generates reviewable migration files.
chriso789roof-measurement-vision-qa
Validates roof measurement geometry, perimeter refinement, and topology outputs against QA gates.
chriso789tenant-isolation-auditor
Audits multi-tenant SaaS for cross-tenant data leaks across schema, RLS, storage, and integrations.
chriso789storage-orphan-cleaner
Detects and quarantines orphaned Supabase Storage files without hard-deleting roofing CRM evidence.
chriso789security-rls-linter
Audits Supabase RLS policies, edge function auth, CORS, and secret hygiene for security gaps.
chriso789canonical-route-provenance-auditor
Audits AI measurement runs for canonical runtime paths and complete route provenance fields.
chriso789backend-auto-cleanup-worker
Builds a nightly Supabase edge function that purges expired cache, stale jobs, and orphaned storage.
Frequently Asked Questions About chriso789
FAQPage SchemaWhat tasks can I accomplish with chriso789's skills?▼
You can enforce multi-tenant RLS isolation, audit and consolidate Supabase edge functions, repair stuck webhook queues, optimize Postgres indexes, quarantine orphaned storage files, and run regression and visual QA gates on the AI roof-measurement pipeline before customer reports ship.
Who are these skills designed for?▼
Backend and full-stack engineers maintaining the Pitch CRM roofing SaaS on Supabase — especially developers touching edge functions, RLS policies, webhook integrations (Telnyx, QBO, Stripe, DocuSign), or the AI Measurement pipeline and its RoofTrace tracing workbench.
How do the AI measurement QA skills work in practice?▼
They gate every measurement run through the canonical route (start-ai-measurement → autonomous-graph-solver → MeasurementReportDialog), require aerial-backed overlay verification of perimeter and topology, and block customer_report_ready unless regression tests pass against canonical baselines like Fonsica.
What are the prerequisites for using these skills?▼
A Supabase-backed project — specifically the Pitch CRM codebase with its edge functions, migrations, roof_measurements and ai_measurement_jobs tables, storage buckets, and Lovable-hosted frontend. Skills auto-load when requests touch those surfaces; no separate installation is described.
Do these skills handle security and tenant isolation?▼
Yes. Dedicated skills lint RLS policies, storage buckets, CORS, and secret hygiene; audit cross-company data leak paths; enforce webhook signature verification and auth mode declaration; and require tenant scoping on every query, queue row, and integration credential.