egp-database

star 0

Database and Supabase conventions for EGP. Use when writing migrations, queries, or schema.

Ivan-Hristoslavov By Ivan-Hristoslavov schedule Updated 3/1/2026
play_arrow Run Skill in Manus View GitHub

name: egp-database description: Database and Supabase conventions for EGP. Use when writing migrations, queries, or schema.

EGP Database

Client Usage

  • Use supabaseAdmin for API routes (bypasses RLS)
  • Hooks fetch from /api/* only — no direct Supabase from client

Tables

  • bookings, customers, payments, services, pricing_cards, gallery, admin_profile, admin_settings, reviews, blog_posts, team, working_hours, discount_codes, faq, conditions
  • Bookings: total_amount, amount_paid, remaining_amount, payment_type, payment_method

Don'ts

  • Do NOT query admin_areas_cover — table does not exist. API returns [] or 503.

Migrations

  • Path: supabase/migrations/
  • Format: YYYYMMDD_description.sql
Install via CLI
npx skills add https://github.com/Ivan-Hristoslavov/EGP --skill egp-database
Repository Details
star Stars 0
call_split Forks 0
navigation Branch main
article Path SKILL.md
More from Creator
Ivan-Hristoslavov
Ivan-Hristoslavov Explore all skills →