supabase-test

What problem does it solve?

This Skill streamlines the testing of Supabase applications by providing a robust framework for creating isolated, ephemeral databases and simulating various user roles for comprehensive testing of Row Level Security (RLS) policies.

Core Features & Use Cases

• Ephemeral Databases: Each test runs with a fresh, isolated database instance, ensuring test independence.
• RLS Testing: Simulate anon and authenticated users to verify access controls.
• Multi-User Simulation: Test scenarios involving multiple concurrent users with different permissions.
• Direct Postgres Access: Interact directly with the database using both superuser and user clients.
• Use Case: Verify that an authenticated user can only modify their own records in a posts table while being unable to access or modify records belonging to other users.

Quick Start

Use the supabase-test skill to write tests for your Supabase application.