# database-pro-mastery

> Expert-level Supabase and PostgreSQL management, RLS policies, and schema optimization.

- Author: OVT-K
- Repository: OVT-K/antigravity-skill-repo
- Version: 20260127151550
- Stars: 0
- Forks: 0
- Last Updated: 2026-02-06
- Source: https://github.com/OVT-K/antigravity-skill-repo
- Web: https://mule.run/skillshub/@@OVT-K/antigravity-skill-repo~database-pro-mastery:20260127151550

---

---
name: database-pro-mastery
description: Expert-level Supabase and PostgreSQL management, RLS policies, and schema optimization.
---

# Database Pro Mastery Skill

This skill ensures the backend/database is secure, fast, and properly indexed.

## Supabase Mastery

- **RLS (Row Level Security)**: Never leave a table public. Always define explicit policies.
- **Edge Functions**: Use for complex server-side logic (Stripe, Email).
- **Triggers/Webhooks**: Use for automatic data synchronization.

## PostgreSQL Performance

- **Indexing**: Add indexes to frequently filtered columns (e.g., `user_id`).
- **Query Optimization**: Avoid `SELECT *`.
- **Naming Convention**: `snake_case` for all tables and columns.

## Migrations

- Keep a strict folder structure for SQL migrations.
- Always include a "rollback" plan for major changes.