apply_migration
Execute and track SQL migration scripts within a self-hosted Supabase instance. Ensures database schema updates are applied and recorded in the schema_migrations table. Requires version and SQL inputs for reliable migration management.
Instructions
Applies a SQL migration script and records it in the supabase_migrations.schema_migrations table within a transaction.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
name | No | An optional descriptive name for the migration. | |
sql | Yes | The SQL DDL content of the migration. | |
version | Yes | The migration version string (e.g., '20240101120000'). |