jecg2804
Community@jecg2804
jecg2804 provides skills for building and governing HumanOS/ICONSA, an HR request platform on Supabase with strict RLS policies, business rules, and form engines.
Agent Skills by jecg2804
Showing 8 vetted skills indexed across 1 GitHub repositories.
jecg2804iconsa-business-rules
Enforces 27 HumanOS business rules before writing migrations, RLS policies, and approval logic.
jecg2804handoff
Generates a handoff document and kickoff prompt summarizing a conversation for the next agent session.
jecg2804iconsa-rls-validation
Validates PostgreSQL Row Level Security policies across HumanOS Supabase schemas.
jecg2804iconsa-library-docs-check
Verifies external library APIs against current Context7 documentation before writing code.
jecg2804diagnose
Diagnoses bugs and performance regressions through a structured reproduce-hypothesise-fix workflow.
jecg2804iconsa-form-implementation
Implements HumanOS HR request forms end-to-end using JSONB form schemas and approval chain templates.
jecg2804grill-with-docs
Stress-tests design plans against CONTEXT.md glossaries and ADRs through structured questioning.
jecg2804iconsa-supabase-migration
Generates Supabase migrations following ICONSA conventions for RLS, comments, and naming.
Frequently Asked Questions About jecg2804
FAQPage SchemaWhat tasks can I accomplish with jecg2804's skills?▼
You can apply HumanOS business rules R1-R27, create convention-compliant Supabase migrations with mandatory COMMENTs and enabled RLS, validate row level security policies via pg_policies, implement new HR form/request types end-to-end, verify external library APIs through Context7, and run disciplined bug diagnosis loops.
Who are these skills designed for?▼
Developers and database engineers working on the HumanOS/ICONSA HR platform built on Supabase, Next.js, React, and Tailwind. They suit engineers handling ticket approvals, auth.users operations, DDL migrations, and HR request types like VACACIONES, PRESTAMO, and ACCION_PERSONAL under Ley 81 constraints.
How do the HumanOS database skills work in practice?▼
The business-rules skill triggers before any migration, RLS policy, or approval logic change. The migration skill enforces naming conventions, obligatory COMMENTs, enabled RLS, reused helper functions, and CHANGELOG entries. The RLS validation skill then queries pg_policies and pg_class to verify coverage and suggests fixes.
What prerequisites and dependencies do these skills require?▼
A Supabase/PostgreSQL project with the HumanOS schema, including requests.types, requests.tickets, FormEngine, ApprovalEngine, and ChainResolver. The library-docs-check skill requires Context7 access to verify Next.js, React, Tailwind, Supabase SDK, Resend, Twilio, Documenso, and Zod APIs before implementation.
Do these skills support debugging and planning beyond database work?▼
Yes. The diagnose skill runs a reproduce-minimise-hypothesise-instrument-fix-regression-test loop for hard bugs and performance regressions. The grill-with-docs skill stress-tests plans against the domain model and updates CONTEXT.md and ADRs, while handoff compacts sessions into transfer documents.