abelv22/project-foundation81 installs
supabase-backend
Expert in Supabase architecture, SQL optimization (PostgreSQL), and backend security (RLS) for real-time tracking systems.
How do I install this agent skill?
npx skills add https://github.com/abelv22/project-foundation --skill supabase-backendIs this agent skill safe to install?
- Gen Agent Trust Hubpass
The skill is purely informational, providing architectural guidelines for Supabase and PostgreSQL. It contains no executable code, network requests, or sensitive data access.
- Socketpass
No alerts
- Snykpass
Risk: LOW · No issues
- Runlayerwarn
1/1 file flagged
What does this agent skill do?
Supabase & Backend Architecture Skill
This skill enables the assistant to provide high-level architectural advice and implementation details for the iTaxiBcn backend.
Knowledge Areas
1. Database Schema Optimization
- Time-Series Data: Guidelines for handling high-frequency location updates in
registros_retenandgeofence_logs. - Indexing: Strategies for spatial indices (PostGIS) and temporal queries to speed up wait-time calculations.
- Materialized Views: Recommendation for replacing heavy queries on
registros_retenwith materialized views for zone aggregations.
2. Row Level Security (RLS)
- Device-Based Access: Ensuring
device_idbased security since the app currently uses device identifiers instead of full user auth (until Phase 2). - Audit Logs: Best practices for
geofence_logsandlocation_debug_logssecurity.
3. Edge Functions (Deno/TypeScript)
- Geofencing Logic: Optimization of the Ray-casting algorithm in
check-geofence. - Performance: Minimizing startup time and memory footprint of edge functions.
- Error Handling: Robust try-catch patterns and standard JSON responses.
4. SQL Scripting
- Migrations: Following the
supabase/migrations/structure. - Stored Procedures: Writing efficient PL/pgSQL for complex logic like
useWhereNextscore calculation on the server side.
Guidelines for Responses
- Always suggest Materialized Views for dashboard metrics that don't need second-by-second accuracy.
- When writing SQL, ensure idempotency (use
CREATE OR REPLACEorIF NOT EXISTS). - Prioritize PostGIS functions for distance and polygon math.
How can the creator link this skill?
Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.
<a href="https://skillzs.dev/skills/abelv22/project-foundation/supabase-backend">View supabase-backend on skillZs</a>