Does it support TypeScript type generation?

Yes, it provides specific commands to generate TypeScript definitions from your Supabase schema to ensure frontend type safety.

Can I use this for database migrations?

Yes, the skill includes standardized commands for pushing migrations to linked projects and dumping schemas using the Supabase CLI.

How does this skill improve Supabase security?

It implements best practices such as enforcing an empty search_path for SECURITY DEFINER functions to prevent injection attacks and revoking public execute permissions on internal trigger functions.

Does it handle Supabase Advisor alerts?

The skill provides expert guidance on identifying and resolving security and performance issues flagged by the Supabase Advisor, such as missing function search paths.

Supabase Database & Security Manager

Name: Supabase Database & Security Manager
Author: HemSoft

byHemSoft

0•

数据库管理

Manages Supabase database instances, enforces PostgreSQL security best practices, and streamlines migration workflows for the Dashboard project.

This skill provides Claude with the specialized knowledge required to manage Supabase environments effectively. It focuses on critical database operations such as migration deployment, schema dumping, and TypeScript type generation. Beyond standard maintenance, the skill prioritizes security by enforcing 'search_path' hardening for SECURITY DEFINER functions, revoking public access to sensitive trigger functions, and providing a framework to resolve Supabase Advisor security alerts. It is particularly useful for developers who need to maintain a secure and well-documented backend within the Supabase ecosystem.

主要功能

01Security hardening for SECURITY DEFINER functions and triggers

02Supabase Advisor issue monitoring and resolution guidance

03Real-time schema introspection and TypeScript type generation

04Project-specific API key and environment configuration

05Automated migration naming and deployment management

060 GitHub stars

使用场景

01Auditing PostgreSQL functions for search path injection vulnerabilities

02Deploying and managing version-controlled database migrations

03Resolving Supabase Advisor security and performance alerts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hemsoft/dashboard supabase

For use in Claude.ai and ChatGPT

Download Skill