supabase-usage

Query Supabase databases to list tables, inspect schemas, and explore relationships.

1.0k|91|Updated Jul 9, 2025

Search Tags:#rls #supabase #patterns #sql #relationships #pagination #auth

Ready to run

npx skills add https://github.com/fcakyon/claude-codex-settings --skill supabase-usage

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: supabase-usage
Source: https://github.com/fcakyon/claude-codex-settings/tree/main/plugins/supabase-tools/skills/supabase-usage
Command: npx skills add https://github.com/fcakyon/claude-codex-settings --skill supabase-usage

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill guides you through Supabase database patterns, authentication and Row Level Security (RLS), table relationships, and practical query patterns to build scalable, secure apps.

Core Features & Use Cases

MCP Tools: list tables, get table schema, execute read-only SQL.
Authentication: user management, sessions, OAuth sign-in.
Row Level Security: policy patterns for data access.
Table Relationships: nested queries and relationships across tables.
Query Patterns: filtering, pagination, and performance tips.

Quick Start

Start with mcp__supabase__list_tables to see the database structure.
Use mcp__supabase__get_table_schema for a table to inspect columns and types.
Run a read-only query using mcp__supabase__execute_sql to verify results.

Frequently Asked Questions about supabase-usage

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

FAQPage Schema

How do I set up row-level security policies in Supabase?▼

Row-level security in Supabase uses SQL policies to restrict data access at the database level. Define RLS policies on tables to control which rows users can query, insert, update, or delete based on authentication context and custom conditions. Policies enforce access control automatically on every query.

What's the best way to structure table relationships in Supabase?▼

Structure relationships using foreign keys to link tables, then query nested data with Supabase's PostgREST API or raw SQL. Define foreign key constraints to enforce referential integrity and enable efficient joins across related tables for consistent, scalable data retrieval.

How do I implement pagination in Supabase queries?▼

Implement pagination by using LIMIT and OFFSET in SQL queries or range parameters in PostgREST calls. Set a fixed page size, calculate offset based on the current page, and fetch results in chunks to improve performance and reduce payload size.

Can I use Supabase with OAuth authentication?▼

Supabase supports OAuth sign-in through built-in providers like Google, GitHub, and others. OAuth handles user authentication and session management, allowing you to integrate third-party sign-in while Supabase manages user records and authentication state.

How do I explore my database schema and verify table structure?▼

Query your Supabase database schema using tools to list tables and inspect column definitions, types, and constraints. Schema exploration confirms table names, relationships, and column properties before constructing queries or applying RLS policies.

What are common performance optimization patterns for Supabase queries?▼

Optimize Supabase queries by using indexes on frequently filtered columns, pagination for large result sets, and efficient joins with foreign keys. Execute read-only queries to verify performance and identify bottlenecks before applying changes in production.