mcp-supabase

To run secure SQL queries on Supabase safely, this Skill enforces built-in security rules for data modifications and DDL operations, ensuring that writes, deletes, and schema changes are gated and protected against accidental execution.

Yes, you can generate TypeScript types directly from your Supabase database schema. This Skill automates type generation by introspecting your schema, providing strongly typed interfaces for seamless integration with TypeScript workflows.

The best way to apply database migrations to Supabase is through a gated process that safely executes migration scripts. This Skill manages schema changes securely, such as adding indexes to improve query performance, while enforcing necessary DDL security rules.

Yes, this Supabase database management approach supports monitoring and diagnostics by providing access to database logs and generating performance recommendations, allowing you to identify slow queries and optimize schema operations effectively.

The primary limitation when executing data operations and DDL changes on Supabase is that all modifications are strictly governed by enforced security rules and gates, which may restrict certain automated workflows if the operations do not meet safety compliance checks.

You need to generate types and apply migrations for your Supabase database when modifying your schema, such as adding new tables or indexes. This Skill securely manages the migration process and updates TypeScript types to reflect the latest structural changes.