Supabase

Supabase RPC API

Invoke PostgreSQL functions via remote procedure calls.

Documentation GitHub OpenAPI

Operations 1

POST /rpc/{function_name} Invoke a PostgreSQL function #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/supabase-rpc-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: Supabase Database REST RPC API
  description: The Supabase Database REST API provides auto-generated RESTful endpoints for every table, view, and function in your PostgreSQL database. Powered by PostgREST, it supports full CRUD operations, complex filtering with horizontal and vertical filtering operators, pagination, sorting, and embedding of related resources via foreign key relationships. Row Level Security policies are enforced on all API requests. The schema is auto-generated from your database, so paths and schemas vary per project. This specification documents the common patterns and conventions.
  version: 1.0.0
  contact:
    name: Supabase Support
    url: https://supabase.com/support
  termsOfService: https://supabase.com/terms
servers:
- url: https://{project_ref}.supabase.co/rest/v1
  description: Supabase Project PostgREST Server
  variables:
    project_ref:
      description: Your Supabase project reference ID
      default: your-project-ref
security:
- apiKeyAuth: []
  bearerAuth: []
tags:
- name: RPC
  description: Invoke PostgreSQL functions via remote procedure calls.
paths:
  /rpc/{function_name}:
    post:
      operationId: invokeFunction
      summary: Invoke a PostgreSQL function
      description: Calls a PostgreSQL function (stored procedure) via a remote procedure call. Function arguments are passed in the request body. Functions must be created in the public schema or an exposed schema.
      tags:
      - RPC
      parameters:
      - name: function_name
        in: path
        required: true
        description: Name of the PostgreSQL function to invoke
        schema:
          type: string
      requestBody:
        content:
          application/json:
            schema:
              type: object
              description: Function arguments as key-value pairs
      responses:
        '200':
          description: Function executed successfully
          content:
            application/json:
              schema:
                description: Function return value
        '400':
          description: Bad request - invalid arguments
        '401':
          description: Unauthorized
        '404':
          description: Function not found
components:
  securitySchemes:
    apiKeyAuth:
      type: apiKey
      in: header
      name: apikey
      description: Supabase project API key. Use the anon key for client-side access (subject to RLS) or service_role key for server-side access (bypasses RLS).
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: JWT access token from Supabase Auth for user-context requests.
externalDocs:
  description: Supabase Data REST API Documentation
  url: https://supabase.com/docs/guides/api