retrieve_migrations

Fetch and manage Supabase migrations with version, name, and SQL details. Supports pagination, name pattern filtering, and optional full query inclusion for efficient database tracking.

Instructions

Retrieve a list of all migrations a user has from Supabase.

Returns a list of migrations with the following information:

Version (timestamp)
Name
SQL statements (if requested)
Statement count
Version type (named or numbered)

Parameters:

limit: Maximum number of migrations to return (default: 50, max: 100)
offset: Number of migrations to skip for pagination (default: 0)
name_pattern: Optional pattern to filter migrations by name. Uses SQL ILIKE pattern matching (case-insensitive). The pattern is automatically wrapped with '%' wildcards, so "users" will match "create_users_table", "add_email_to_users", etc. To search for an exact match, use the complete name.
include_full_queries: Whether to include the full SQL statements in the result (default: false)

SAFETY: This is a low-risk read operation that can be executed in SAFE mode.

Input Schema

Name	Required	Description	Default
`include_full_queries`	No
`limit`	No
`name_pattern`	No
`offset`	No

Input Schema (JSON Schema)

{
  "properties": {
    "include_full_queries": {
      "default": false,
      "title": "Include Full Queries",
      "type": "boolean"
    },
    "limit": {
      "default": 50,
      "title": "Limit",
      "type": "integer"
    },
    "name_pattern": {
      "default": "",
      "title": "Name Pattern",
      "type": "string"
    },
    "offset": {
      "default": 0,
      "title": "Offset",
      "type": "integer"
    }
  },
  "title": "retrieve_migrationsArguments",
  "type": "object"
}

Supabase MCP Server

retrieve_migrations

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Supabase MCP Server

Related Tools