skillZs
★ LIVE SKILL TAGS ★
>>> LIVE SKILLS INDEX <<<
* OPEN SOURCE *
NO LOGIN, NO TRACKING
※ REAL INSTALL DATA ※
← back to all skills
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-backend
view source ↗

Is 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_reten and geofence_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_reten with materialized views for zone aggregations.

2. Row Level Security (RLS)

  • Device-Based Access: Ensuring device_id based security since the app currently uses device identifiers instead of full user auth (until Phase 2).
  • Audit Logs: Best practices for geofence_logs and location_debug_logs security.

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 useWhereNext score 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 REPLACE or IF NOT EXISTS).
  • Prioritize PostGIS functions for distance and polygon math.

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>