apply_migration

Applies SQL migration scripts to self-hosted Supabase databases, recording versions in the schema_migrations table to manage and track database changes efficiently.

Instructions

Applies a SQL migration script and records it in the supabase_migrations.schema_migrations table within a transaction.

Input Schema

Name	Required	Description
`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').

Input Schema (JSON Schema)

{
  "properties": {
    "name": {
      "description": "An optional descriptive name for the migration.",
      "type": "string"
    },
    "sql": {
      "description": "The SQL DDL content of the migration.",
      "type": "string"
    },
    "version": {
      "description": "The migration version string (e.g., '20240101120000').",
      "type": "string"
    }
  },
  "required": [
    "version",
    "sql"
  ],
  "type": "object"
}

Self-Hosted Supabase MCP Server

apply_migration

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Self-Hosted Supabase MCP Server

Related Tools

MCP directory API