supabase

Execute SQL queries, migrations, and type generation on Supabase databases.

1|Updated Feb 25, 2026

Search Tags:#performance #security #database #migration #supabase #sql #postgres

Ready to run

npx skills add https://github.com/mshaheerz/hive-mind --skill supabase-mshaheerz

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: supabase
Source: https://github.com/mshaheerz/hive-mind/tree/main/agent-skills/supabase
Command: npx skills add https://github.com/mshaheerz/hive-mind --skill supabase-mshaheerz

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a robust and secure way to interact with Supabase databases, enabling complex data operations, schema management, and performance optimization.

Core Features & Use Cases

Database Operations: Execute SQL queries, apply migrations, generate types, and manage database logs.
Security & Best Practices: Enforces security rules, optimizes queries, and leverages best practices for performance and reliability.
Use Case: A developer needs to add a new table to their Supabase project, define foreign key constraints, and ensure the new schema adheres to performance best practices. This Skill can generate the necessary SQL, apply it via migration, and provide guidance on indexing and data types.

Quick Start

Use the supabase skill to list all tables in the public schema.

Frequently Asked Questions about supabase

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

FAQPage Schema

How do I apply database migrations to a Supabase Postgres project?▼

To apply database migrations to a Supabase Postgres project, you can execute schema changes via CLI, Console, or MCP. This generates the necessary SQL, applies it securely, and provides guidance on indexing and data types.

How do I generate types from a Supabase database schema?▼

Generating types from a Supabase database schema is supported as a core database operation. The process executes type generation commands to produce strict, strongly-typed definitions for your Postgres tables and data structures.

Can I execute SQL queries on Supabase while enforcing strict security rules?▼

Yes, executing SQL queries on Supabase enforces strict security rules for all data operations. It allows you to run read and write operations while automatically applying Postgres best practices for security and reliability.

What is the best way to optimize Postgres query performance in Supabase?▼

The best way to optimize Postgres query performance in Supabase is to leverage built-in best practices. The system provides guidance on indexing, data types, and schema design to ensure reliable and performant database operations.

Does the Supabase MCP support automatic execution of database operations?▼

Yes, the Supabase MCP supports automatic execution of database operations. You can automatically run queries, apply migrations, generate types, and manage logs without manual CLI or Console intervention.

How do I manage database logs for a Supabase Postgres instance?▼

Managing database logs for a Supabase Postgres instance is a supported database operation. You can retrieve and analyze logs via automatic MCP execution or manual CLI and Console commands to monitor activity.