supabase-mcp

read_records

Read records from a Supabase table

Input Schema

NameRequiredDescriptionDefault
filterNoFilter conditions (optional)
joinsNoTable joins (optional)
limitNoMaximum number of records to return (optional)
selectNoFields to select (optional)
tableYesTable 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" }