Can I call custom database functions?

Yes, the skill includes support for calling PostgreSQL functions via the /rpc endpoint using POST requests.

Can I use this for production data?

Yes, as long as you use the appropriate API keys and have Row Level Security (RLS) configured correctly to protect your data.

Does this skill require the Supabase CLI?

No, it uses standard curl commands to interact with the Supabase REST API directly, meaning no additional CLI installation is required.

How does it handle complex database queries?

It utilizes standard PostgREST syntax for advanced filtering, ordering, pagination, and joining related tables directly through URL parameters.

Which API keys should I use?

Use the Publishable key for client-side operations that respect RLS, and the Secret key for administrative or server-side tasks that bypass security policies.

Supabase Data Manager

Name: Supabase Data Manager
Author: vm0-ai

byvm0-ai

•

데이터베이스 관리

Manages Supabase databases through direct REST API calls for CRUD operations and advanced data filtering.

소개

This skill empowers Claude to interact directly with Supabase projects using curl commands against the auto-generated PostgREST API. It provides a comprehensive set of patterns for reading, inserting, updating, and deleting data, along with advanced filtering, pagination, and relationship querying. By leveraging both publishable and secret keys, it allows for secure data management that respects Row Level Security (RLS) while providing administrative capabilities when necessary, making it an essential tool for backend development and rapid prototyping within the Supabase ecosystem.

주요 기능

Advanced PostgREST filtering and pagination
Upsert functionality for syncing data
Full CRUD operations (Create, Read, Update, Delete)
Remote Procedure Call (RPC) execution for custom Postgres functions
Relational data querying and foreign key embedding
18 GitHub stars

사용 사례

Rapidly prototyping backend functionality without writing boilerplate code.
Managing database records and performing bulk data migrations via the CLI.
Debugging and testing Row Level Security (RLS) policies by switching between API keys.

소개

주요 기능

Advanced PostgREST filtering and pagination
Upsert functionality for syncing data
Full CRUD operations (Create, Read, Update, Delete)
Remote Procedure Call (RPC) execution for custom Postgres functions
Relational data querying and foreign key embedding
18 GitHub stars

사용 사례

Rapidly prototyping backend functionality without writing boilerplate code.
Managing database records and performing bulk data migrations via the CLI.
Debugging and testing Row Level Security (RLS) policies by switching between API keys.