Supabase MCP Server

Official Supabase MCP server for database and backend integration. Enables AI agents to query PostgreSQL databases, manage tables and schemas, handle authentication users, interact with storage buckets, and invoke edge functions. Provides full access to Supabase project management including migrations and type generation.

{
  "mcpServers": {
    "supabase": {
      "command": "npx",
      "args": [
        "-y",
        "@supabase/mcp-server"
      ],
      "env": {
        "SUPABASE_URL": "<YOUR_SUPABASE_URL>",
        "SUPABASE_SERVICE_ROLE_KEY": "<YOUR_SUPABASE_SERVICE_ROLE_KEY>"
      }
    }
  }
}

{
  "type": "object",
  "required": [
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "SQL query to execute"
    },
    "params": {
      "type": "array",
      "description": "Query parameters for parameterized queries"
    }
  }
}

{
  "type": "object",
  "properties": {
    "schema": {
      "type": "string",
      "description": "Schema name (default public)"
    }
  }
}

{
  "type": "object",
  "required": [
    "table"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "schema": {
      "type": "string",
      "description": "Schema name (default public)"
    }
  }
}

{
  "type": "object",
  "required": [
    "action",
    "bucket"
  ],
  "properties": {
    "path": {
      "type": "string",
      "description": "File path within the bucket"
    },
    "action": {
      "type": "string",
      "description": "Action to perform (list, upload, download, delete)"
    },
    "bucket": {
      "type": "string",
      "description": "Storage bucket name"
    }
  }
}