Skip to content

ahliweb/sikesra

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

SIKESRA Monorepo

Welcome to the SIKESRA monorepo. SIKESRA uses AWCMS as its main system-development foundation, with product-specific workflows built on the core admin, public, mobile, IoT, Supabase, and Cloudflare architecture.

Status Snapshot (2026-03-25)

  • Active Node runtime validated: v22.22.0 (minimum remains >=22.12.0).
  • The active documentation and repository-conflict audit cycle is tracked in docs/dev/documentation-audit-plan.md and docs/dev/documentation-audit-tracker.md.
  • SIKESRA product docs treat AWCMS as the upstream system-development baseline and layer SIKESRA workflows on top of it.
  • Public portal and edge-runtime docs are aligned to Astro static output plus Cloudflare Workers as the primary edge HTTP layer.
  • MCP topology from mcp.json currently includes cloudflare, context7, github, and supabase.
  • Migration parity should be verified with scripts/verify_supabase_migration_consistency.sh before relying on mirrored migration counts in docs or CI flows.
  • Repair and verification workflows are scripted via scripts/repair_supabase_migration_history.sh and scripts/verify_supabase_migration_consistency.sh.

Documentation Authority

This repository follows a strict documentation hierarchy aligned with the Context7 MCP (Model Context Protocol):

  1. SYSTEM_MODEL.md - Single Source of Truth: stack versions, architecture constraints, security mandates
  2. AGENTS.md - agent execution rules, Context7 references, implementation patterns
  3. README.md - canonical monorepo entrypoint, AWCMS-baseline framing, and operational overview
  4. DOCS_INDEX.md - canonical documentation map and topic routing
  5. Implementation Guides - specific how-to documentation in docs/

For AI Agents: Always follow AGENTS.md and SYSTEM_MODEL.md as primary authorities.

Product Context

  • SIKESRA targets the pre-DTSEN phase of regional social welfare data governance.
  • The current MVP emphasizes structured entity registration, evidence-backed verification, secure document storage, and role-scoped operational dashboards.
  • AWCMS is the main system-development baseline for shared runtime, tenancy, permission, and edge patterns; SIKESRA docs add product-specific constraints on top of that baseline.

Project Structure

Directory Description Tech Stack
awcms/ SIKESRA Admin Panel foundation React 19.2.4, Vite 7.2.7, Supabase
awcms-public/primary/ SIKESRA Public Portal foundation Astro 5.17.1 (static), React 19.2.4
awcms-mobile/primary/ Mobile App Flutter 3.38.5
awcms-esp32/primary/ IoT Firmware ESP32, PlatformIO
awcms-ext/ External Extensions JavaScript modules
awcms-edge/ Worker API & Edge Logic Cloudflare Workers, Hono
packages/awcms-shared/ Shared public-portal utilities TypeScript helpers
supabase/ Migrations and local Supabase project config Supabase CLI
awcms-mcp/ MCP Integration Model Context Protocol tools
openclaw/ AI Gateway OpenClaw multi-tenant AI routing

Current Stack Versions (Core)

  • React: 19.2.4 (Admin + Public)
  • Vite: 7.2.7 (Admin)
  • Astro: 5.17.1 (Public) - Requires Node.js >=22.12.0
  • TailwindCSS: 4.1.18
  • Supabase JS: 2.93.3 (Admin + Public)
  • React Router DOM: 7.10.1
  • TipTap: 3.13.0
  • Puck: 0.21.0
  • OpenClaw: 2026.2.21-2 (AI Gateway)
  • Node.js: >= 22.12.0 (managed via nvm)

Notes:

  • Admin and public workspaces currently use @supabase/supabase-js 2.93.3.
  • awcms-edge/ currently pins @supabase/supabase-js ^2.45.0; use awcms-edge/package.json as the source of truth for Worker-only dependency alignment until that workspace is upgraded deliberately.

Runtime Architecture

  • awcms-edge/ is the server-side HTTP gateway for client applications when requests need privileged orchestration, external API calls, storage signing, webhook handling, or edge-managed request shaping.
  • Supabase remains the system of record for authentication, PostgreSQL data, tenant context, RLS, and ABAC permission enforcement.
  • Cloudflare Workers add an edge gateway layer; they do not replace Supabase Auth or move authorization truth out of PostgreSQL policies and permission functions.
  • Cloudflare R2 handles object storage flows, while metadata, ownership, tenant isolation, and policy enforcement remain in Supabase.
  • Client apps should continue to use Supabase Auth sessions, and Worker routes should validate those sessions before performing protected server-side work.
  • SIKESRA-specific workflows should model village, sub-district, institutional, and regency verification inside this architecture rather than outside it.

Quick Start

For Developers

  1. Read SYSTEM_MODEL.md - Understand the architecture (5 min)
  2. Follow Developer Setup Guide - Get running (10 min)
  3. Reference AGENTS.md - Coding standards and patterns
  4. Review docs/product/PRD.md - SIKESRA MVP goals, workflow, and constraints

Per-Component Guides

Documentation

Database & Migrations

  • Canonical timestamped migrations live in supabase/migrations/ and are mirrored in awcms/supabase/migrations/ for CI/Admin tooling compatibility.
  • Non-migration SQL files must be kept outside migration folders (for example supabase/manual/).
  • Local workflow:
    • npx supabase migration list --local
    • npx supabase db push --local
  • Linked/remote workflow:
    • npx supabase migration list --linked
    • npx supabase db push --linked
  • If migration history is out of sync, use scripts/repair_supabase_migration_history.sh (dry-run by default, --apply to execute).
  • Validate migration health after apply/repair with scripts/verify_supabase_migration_consistency.sh (--linked for remote checks).

Context7 MCP Integration

This repository uses Context7 for AI-assisted development. Key library IDs:

  • supabase/supabase-js - Database operations
  • supabase/cli - Migration and deployment workflows
  • vitejs/vite - Build tooling
  • withastro/docs - Public portal framework
  • cloudflare/cloudflare-docs - Worker and binding guidance
  • See AGENTS.md for complete list

MCP Topology (OpenCode)

  • Repo config: mcp.json
  • Runtime client config: ~/.config/opencode/opencode.json
  • Active servers:
    • Context7: https://mcp.context7.com/mcp
    • Supabase (local): node awcms-mcp/dist/index.js
    • Cloudflare (remote): api/docs/bindings/observability/builds/radar/browser endpoints
    • GitHub (local): scripts/start_github_mcp.sh (Docker-based github/github-mcp-server)

Contributing

See CONTRIBUTING.md.

License

See LICENSE.

About

sikesra

Resources

License

Code of conduct

Contributing

Security policy

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors