read_records

Retrieve data from a Supabase table with optional filters, joins, and field selections to extract specific records effectively.

Instructions

Read records from a Supabase table

Input Schema

Name	Required	Description
`filter`	No	Filter conditions (optional)
`joins`	No	Table joins (optional)
`limit`	No	Maximum number of records to return (optional)
`select`	No	Fields to select (optional)
`table`	Yes	Table name

Input Schema (JSON Schema)

{
  "properties": {
    "filter": {
      "description": "Filter conditions (optional)",
      "type": "object"
    },
    "joins": {
      "description": "Table joins (optional)",
      "items": {
        "properties": {
          "on": {
            "description": "Join condition (e.g., \"posts.user_id=users.id\")",
            "type": "string"
          },
          "table": {
            "description": "Table to join with",
            "type": "string"
          },
          "type": {
            "description": "Join type",
            "enum": [
              "inner",
              "left",
              "right",
              "full"
            ],
            "type": "string"
          }
        },
        "required": [
          "table",
          "on"
        ],
        "type": "object"
      },
      "type": "array"
    },
    "limit": {
      "description": "Maximum number of records to return (optional)",
      "type": "number"
    },
    "select": {
      "description": "Fields to select (optional)",
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "table": {
      "description": "Table name",
      "type": "string"
    }
  },
  "required": [
    "table"
  ],
  "type": "object"
}

supabase-mcp

read_records

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from supabase-mcp

Related Tools