skills.rest
amo-tech-ai
amo-tech-aiCOMMUNITY
Explore all skills by this author →
GitHub

Supabase Database

Manage Supabase migrations, RLS policies, and PostgreSQL functions.

Updated Jan 15, 2026
Search Tags:#typescript#database#postgresql#migrations#rls#supabase#sql
One-click install
npx skills add https://github.com/amo-tech-ai/rocket-path-ai --skill supabase-database-amo-tech-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Supabase Database
Source: https://github.com/amo-tech-ai/rocket-path-ai/tree/main/.cursor/skills/supabase
Command: npx skills add https://github.com/amo-tech-ai/rocket-path-ai --skill supabase-database-amo-tech-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers you to manage your Supabase database effectively, ensuring schema integrity, robust security, and efficient data operations.

Core Features & Use Cases

  • Schema Management: Create and apply database migrations following best practices.
  • Security: Implement granular Row Level Security (RLS) policies to protect your data.
  • Functionality: Develop and deploy PostgreSQL functions and triggers.
  • Type Safety: Automatically generate TypeScript types for seamless integration.
  • Use Case: You need to add a new products table to your Supabase project, including setting up RLS policies to ensure only authenticated users can view their own organization's products, and then generate the corresponding TypeScript types for your frontend application.

Quick Start

Use the Supabase Database skill to create a new migration for adding a 'users' table with 'id', 'email', and 'created_at' columns, and enable RLS on it.

Frequently Asked Questions about Supabase Database

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

FAQPage Schema
How do I create and apply PostgreSQL migrations in Supabase?▼

To manage PostgreSQL migrations in Supabase, you create version-controlled migration files that apply schema changes sequentially. This ensures schema integrity by tracking database updates incrementally rather than running manual SQL scripts.

How do I set up Row Level Security policies to restrict data access in Supabase?▼

Setting up Row Level Security (RLS) policies in Supabase involves enabling RLS on a table and defining granular PostgreSQL rules to restrict data access. This enforces data security by ensuring authenticated users only view authorized records.

Can I generate TypeScript types automatically from a Supabase database schema?▼

Yes, you can generate TypeScript types directly from your Supabase database schema. This facilitates type-safe integration by automatically mapping PostgreSQL columns and tables to TypeScript interfaces for your frontend application.

What's the best way to deploy PostgreSQL functions and triggers in Supabase?▼

The best way to deploy PostgreSQL functions and triggers in Supabase is through version-controlled migrations. This approach ensures database functionality changes are tracked consistently and deployed safely alongside schema updates.

How do I add a new table with RLS to my Supabase project?▼

To add a new table with RLS to your Supabase project, you create a database migration defining the table columns, then enable Row Level Security and append policies restricting access to authenticated users based on your organization logic.

Related Skills

Explore More Software Engineering Skills→
marvinbissmarvinbiss

supabase-extract-db-string

Detect exposed PostgreSQL connection strings in JavaScript bundles.

Community
Advanced
abdullah1854abdullah1854
1

sql-analyzer

Analyze SQL queries for anti-patterns and performance issues.

Community
Intermediate
AdigunQAdigunQ

supabase

Manage Supabase projects, migrations, RLS policies, and Edge Functions.

Community
Intermediate
lobehublobehub
81.4k

drizzle

Define TypeScript database schemas and generate migrations with Drizzle ORM.

Official
Intermediate