project-database-context

Document Persta.AI's Supabase schema, RLS policies, RPCs, triggers, and migrations.

Updated Nov 2, 2025
One-click install
npx skills add https://github.com/3balljugglerYu/ai_coordinate --skill project-database-context
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: project-database-context
Source: https://github.com/3balljugglerYu/ai_coordinate/tree/main/.agents/skills/project-database-context
Command: npx skills add https://github.com/3balljugglerYu/ai_coordinate --skill project-database-context

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a centralized guide to understanding and interacting with the Persta.AI project's Supabase data model, ensuring consistency and efficient development.

Core Features & Use Cases

  • Data Model Understanding: Offers clear documentation on Supabase tables, RLS policies, RPCs, and triggers.
  • Developer Onboarding: Streamlines the process for new developers or agents to grasp the data layer.
  • Use Case: When a developer needs to add a new feature that involves modifying the user profile table, they can use this Skill to quickly understand the existing schema, related RLS policies, and any relevant RPCs before making changes.

Quick Start

Use the project database context skill to understand the Supabase data model for Persta.AI.

Frequently Asked Questions about project-database-context

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I understand a Supabase data model before modifying database schemas?

To understand a Supabase data model for schema modifications, use centralized repository-specific guidance that documents tables, RLS policies, RPCs, and triggers. This provides clear documentation on the existing data layer to ensure consistency and efficient development before making changes.

What is the best way to adjust RLS policies and implement triggers in Supabase?

Adjusting RLS policies and implementing triggers in Supabase requires understanding existing schema and related policies first. This Skill provides repository-specific guidance on RLS policy adjustments and trigger implementation to streamline the process and prevent conflicts.

How do I manage Supabase migrations when adding new database features?

Managing Supabase migrations when adding features involves reviewing existing migration files and schema context. This Skill offers centralized guidance on migration management, helping developers grasp the data layer and ensure consistency before applying schema changes.

Can I use this guide for onboarding developers to an existing Supabase data layer?

Yes, you can use this guide for developer onboarding to an existing Supabase data layer. It streamlines the process for new developers or agents to grasp the data model, including schema, RLS policies, and RPCs, ensuring efficient and consistent integration.

How do RPCs and data models work together in Supabase development?

RPCs and data models work together in Supabase development by interacting with underlying table structures and security policies. This Skill documents how RPCs relate to the schema and RLS, providing context needed for safe RPC development and data model modifications.

When do I need to check RLS policies before modifying a Supabase user profile table?

You need to check RLS policies before modifying a Supabase user profile table to ensure existing security rules are not broken. This Skill helps quickly understand related RLS policies and relevant RPCs before making schema changes to maintain data integrity.