supabase-rest

Inspect Supabase tables, columns, and sample rows via read-only REST calls.

1|Updated Dec 5, 2025
One-click install
npx skills add https://github.com/lollipopkit/cc-skills --skill supabase-rest
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: supabase-rest
Source: https://github.com/lollipopkit/cc-skills/tree/main/supabase-rest
Command: npx skills add https://github.com/lollipopkit/cc-skills --skill supabase-rest

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides read-only access to Supabase via REST endpoints to inspect tables, columns, and sample data without performing writes.

Core Features & Use Cases

  • Tables & Schemas: List tables by schema, inspect columns with types and constraints.
  • Data Sampling: Pull sample rows with sane limits and ordering.
  • REST-Only: All requests are GET/HEAD to avoid mutations, with proper headers for authentication.
  • CORS Considerations: Respect SUPA_HOST, SUPA_ORIGIN, SUPA_REFERER when set.

Quick Start

Load environment variables and fetch the first 50 rows from a table, or list columns for a table.

Frequently Asked Questions about supabase-rest

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

FAQPage Schema
How do I inspect a Supabase database schema and list tables?

Read-only REST calls to Supabase endpoints let you list tables by schema and inspect columns with their types and constraints. The Skill uses GET requests with proper authentication headers and environment variables (SUPA_URL, SUPA_SERVICE_ROLE_KEY, SUPA_SCHEMA) to safely discover schema structure without write access.

Can I query sample data from Supabase tables without making writes?

Yes. The Skill fetches sample rows via read-only GET requests with sane limits and ordering, respecting REST best practices. All requests are GET or HEAD only, ensuring your data remains unmodified while you inspect table contents.

What environment setup do I need to access Supabase via REST?

Set SUPA_URL, SUPA_SERVICE_ROLE_KEY, and SUPA_SCHEMA as environment variables. Optionally configure SUPA_HOST, SUPA_ORIGIN, and SUPA_REFERER for CORS handling. These enable authenticated read-only REST calls to your Supabase instance for schema and data inspection.

How do I check column details and data types in a Supabase table?

Use read-only REST requests to inspect table columns, viewing their names, data types, and constraints. The Skill structures GET calls to return column metadata through Supabase REST endpoints, giving you complete visibility into table structure before querying data.

What are the limitations of using REST-only access to Supabase?

REST-only access restricts you to read operations (GET/HEAD), preventing any data mutations or schema modifications. This design prioritizes safety for discovery and inspection tasks but requires alternative tools if you need to write, update, or delete data.