skills.rest
twhitehead-blackdog
twhitehead-blackdogCOMMUNITY
Explore all skills by this author →
GitHub

supabase-api

Perform CRUD operations, RPC calls, and file uploads on Supabase with company_id filtering.

Updated Nov 18, 2025
Search Tags:#database#api#rest#supabase#crud#rpc
One-click install
npx skills add https://github.com/twhitehead-blackdog/People --skill supabase-api
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-api
Source: https://github.com/twhitehead-blackdog/People/tree/main/.agent/skills/supabase-api
Command: npx skills add https://github.com/twhitehead-blackdog/People --skill supabase-api

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies and standardizes how you interact with the Supabase database within the People project, ensuring secure and efficient data operations.

Core Features & Use Cases

  • CRUD Operations: Perform SELECT, INSERT, UPDATE, and DELETE operations on Supabase tables.
  • URL Building: Ensures all API requests use the correct ApiUrlService.build() pattern.
  • Data Filtering: Enforces mandatory company_id filtering for all queries.
  • RPC Calls: Allows execution of Supabase Remote Procedure Calls.
  • File Uploads: Facilitates uploading files to Supabase Storage.
  • Use Case: When you need to retrieve a list of active employees for a specific company, you can use this skill to perform a SELECT query on the employees table, filtering by company_id and status.

Quick Start

Use the supabase-api skill to fetch all active employees for the current company.

Frequently Asked Questions about supabase-api

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

FAQPage Schema
How do I perform CRUD operations on a Supabase database?▼

You can perform CRUD operations on a Supabase database by executing SELECT, INSERT, UPDATE, and DELETE statements on tables. This skill ensures all operations adhere to established project patterns and mandatory security rules.

How do I filter Supabase queries by company_id?▼

To filter Supabase queries by company_id, you apply the mandatory company_id filter to all data requests. This enforces standardized data filtering and ensures secure access to project-specific records.

Can I execute Remote Procedure Calls with the Supabase API?▼

Yes, you can execute Remote Procedure Calls (RPC) with the Supabase API. This allows you to run stored procedures directly on the database while maintaining the project's established interaction patterns.

What is the correct way to build URLs for Supabase API requests?▼

The correct way to build URLs for Supabase API requests is using the specific ApiUrlService.build() pattern. This ensures all database interactions route securely through the established project architecture.

How do I upload files to Supabase Storage?▼

To upload files to Supabase Storage, you use the standardized interaction patterns provided by the database API skill. This facilitates secure file uploads alongside standard CRUD operations and RPC calls.

Related Skills

Explore More Software Engineering Skills→
GDSDNGDSDN
3

db-env-check

Validate database environment variables, SSL mode, pooler config, and PostgreSQL connectivity.

Community
Intermediate
awardsappawardsapp

building-compound-components

Design unstyled compound React component APIs with context and render props.

Official
Intermediate
hopeoverturehopeoverture
6

supabase-auth-ssr-setup

Configure Supabase authentication for Next.js App Router with SSR middleware and route guards.

Community
Advanced
yuhle-qugyuhle-qug

database-expert

Analyze and optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced