Supabase Integration

Field	Description	Required	Format
Project Subdomain	Your Supabase project subdomain (the part before .supabase.co in your project URL)	Yes	`abcdefghijklmnopqrst`
Service Role Key	Your Supabase service_role key from Project Settings > API	Yes	`eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...`

select_row — Select row(s) from a Supabase database table with optional filtering and ordering

Parameters

string

required

Name of the table to query

string

Column name to filter by (required if filter and value are provided)

string

Filter operator: eq, neq, gt, gte, lt, lte, like, ilike

string

Value to filter the column by

string

required

Column name to order results by

string

Sort direction: ascending or descending (Default: ascending)

integer

Maximum number of rows to return (Default: 20)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    },
    "count": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Count"
    },
    "status": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "status_text": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Text"
    }
  },
  "required": [
    "success"
  ],
  "title": "SelectRowOutput",
  "type": "object"
}

insert_row — Insert a new row into a Supabase database table

Parameters

string

required

Name of the table to insert into

object

required

Column names and values as key/value pairs for the new row

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    },
    "status": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "status_text": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Text"
    }
  },
  "required": [
    "success"
  ],
  "title": "InsertRowOutput",
  "type": "object"
}

update_row — Update row(s) in a Supabase database table matching a column value

Parameters

string

required

Name of the table to update

string

required

Column name to match rows for update

string

required

Value to match in the specified column

object

required

Column names and new values as key/value pairs

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    },
    "status": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "status_text": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Text"
    }
  },
  "required": [
    "success"
  ],
  "title": "UpdateRowOutput",
  "type": "object"
}

upsert_row — Insert a row or update it if it already exists in a Supabase database table

Parameters

string

required

Name of the table to upsert into

object

required

Column names and values as key/value pairs

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    },
    "status": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "status_text": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Text"
    }
  },
  "required": [
    "success"
  ],
  "title": "UpsertRowOutput",
  "type": "object"
}

delete_row — Delete row(s) from a Supabase database table matching a column value

Parameters

string

required

Name of the table to delete from

string

required

Column name to match rows for deletion

string

required

Value to match in the specified column

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    },
    "status": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "status_text": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Text"
    }
  },
  "required": [
    "success"
  ],
  "title": "DeleteRowOutput",
  "type": "object"
}

batch_insert_rows — Insert multiple rows into a Supabase database table at once

Parameters

string

required

Name of the table to insert rows into

array

required

Array of objects, each representing a row with column names and values as key/value pairs

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "data": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Data",
      "type": "array"
    },
    "status": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "status_text": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Text"
    }
  },
  "required": [
    "success"
  ],
  "title": "BatchInsertRowsOutput",
  "type": "object"
}

remote_procedure_call — Call a Postgres function (RPC) in a Supabase database

Parameters

string

required

Name of the Postgres function to call

object

Arguments to pass to the function as key/value pairs

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "data": {
      "default": null,
      "title": "Data"
    },
    "status": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "status_text": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Text"
    }
  },
  "required": [
    "success"
  ],
  "title": "RemoteProcedureCallOutput",
  "type": "object"
}

count_rows — Count rows in a Supabase database table with optional filtering

Parameters

string

required

Name of the table to count rows from

string

Column name to filter by (optional)

string

Filter operator: eq, neq, gt, gte, lt, lte, like, ilike

string

Value to filter the column by

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "count": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Count"
    }
  },
  "required": [
    "success"
  ],
  "title": "CountRowsOutput",
  "type": "object"
}

Using

Providers

Building

Tools

Supabase Integration for AI Agents & Workflows

Overview

Authentication

Supabase Service Key

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Limits & Quotas

MySQL

PostgreSQL

Snowflake

Links

​Overview

​Authentication

​Supabase Service Key

​Required Credentials

​Available Actions

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Limits & Quotas

​Related integrations

MySQL

PostgreSQL

Snowflake

​Links

Overview

Authentication

Supabase Service Key

Required Credentials

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Limits & Quotas

Related integrations

Links