skills.rest
rustykuntz
rustykuntzCOMMUNITY
Explore all skills by this author →
GitHub

supabase

Execute SQL queries, CRUD operations, and pgvector similarity searches on Supabase databases.

1|Updated Feb 15, 2026
Search Tags:#database#supabase#data management#sql#vector search#crud
One-click install
npx skills add https://github.com/rustykuntz/rocie-tools --skill supabase-rustykuntz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase
Source: https://github.com/rustykuntz/rocie-tools/tree/main/skills/supabase
Command: npx skills add https://github.com/rustykuntz/rocie-tools --skill supabase-rustykuntz

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill simplifies interacting with Supabase databases, allowing users to run SQL queries, perform CRUD operations, and execute vector searches without needing to write complex API calls or manage database clients directly.

Core Features & Use Cases

  • SQL Query Execution: Run arbitrary SQL queries against your Supabase database.
  • Data Manipulation: Insert, select, update, upsert, and delete data with easy-to-use commands.
  • Vector Search: Perform similarity searches on vector embeddings stored in your database.
  • Schema Inspection: List tables and describe their schemas.
  • Use Case: Save user preferences to a 'user_settings' table, search for similar products based on descriptions, or retrieve all active orders from the 'orders' table.

Quick Start

Use the supabase skill to select all columns from the 'users' table where the status is 'active'.

Frequently Asked Questions about supabase

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

FAQPage Schema
How do I run SQL queries on a Supabase database without managing API clients?▼

You can execute SQL queries on a Supabase database via a shell script interface, bypassing complex API clients. It supports arbitrary SQL execution, dynamic filtering, and schema inspection directly through command line inputs.

How do I perform CRUD operations on Supabase data using shell commands?▼

Perform CRUD operations on Supabase data by executing shell script commands for inserting, selecting, updating, upserting, and deleting records. This simplifies data manipulation without needing direct database client management.

Can I do vector similarity searches on pgvector embeddings stored in Supabase?▼

Yes, you can conduct vector similarity searches on pgvector embeddings stored in your Supabase database. The tool leverages pgvector to perform semantic search capabilities based on your stored vector data.

What environment variables do I need to execute Supabase SQL scripts?▼

Executing Supabase SQL scripts requires the Supabase URL and Service Key environment variables for authentication and access. These credentials must be configured in your environment before running database commands.

Does this approach support inspecting table schemas in a Supabase database?▼

Yes, this approach supports schema inspection for a Supabase database. You can list existing tables and describe their schemas to understand your data structure before running queries or vector searches.

Related Skills

Explore More Software Engineering Skills→
rdimasciordimascio

implement-crud

Implement CRUD operations for Supabase tables with RLS and validation.

Community
Advanced
just-cameronjust-cameron
23

using-xrpc-indexer

Queries cognition records via comind's network.search API with vector similarity across concepts, thoughts, memories, hypotheses.

Community
Intermediate
DingTalk-Real-AIDingTalk-Real-AI
2.1k

dws-cli

Script DingTalk operations and batch-manage organizational data via CLI commands.

Official
Intermediate
fgarofalo56fgarofalo56
6

mssql-mcp

Execute SQL Server queries and manage schemas via natural language.

Community
Advanced