3D MCP Cursor Visualization
Supabase MCP Logo - AI-Powered Development Tool for Cursor IDE

Supabase MCP

Model Context Protocol Integration

Overview

This is an MCP server for PostgREST. It allows LLMs perform database queries and operations on Postgres databases via PostgREST.

Supabase Features

  • HTTP requests to PostgREST server
  • SQL to REST query conversion
  • Support for GET, POST, PATCH, DELETE methods
  • JSON response handling
  • Schema-aware operations
  • Authentication support

Supabase Setup & Configuration

Requirements

  • Supabase project or standalone PostgREST server
  • API URL endpoint
  • API key (optional)
  • Schema name (e.g., public)

Installation Instructions

# NPM Installation
npm i @supabase/mcp-server-postgrest

# Yarn Installation
yarn add @supabase/mcp-server-postgrest

# PNPM Installation
pnpm add @supabase/mcp-server-postgrest

Configuration

# Claude Desktop Configuration
{
  "mcpServers": {
    "supabase": {
      "command": "npx",
      "args": [
        "-y",
        "@supabase/mcp-server-postgrest",
        "--apiUrl",
        "https://your-project-ref.supabase.co/rest/v1",
        "--apiKey",
        "your-anon-key",
        "--schema",
        "public"
      ]
    }
  }
}

Supabase Available Tools

  • postgrestRequest
  • sqlToRest

Supabase Required Inputs

apiUrl

Type
string
Description
Base URL of PostgREST endpoint
Required
Yes

apiKey

Type
string
Description
API key for authentication
Required
No

schema

Type
string
Description
Postgres schema to serve the API from
Required
Yes

Supabase Use Cases

  • Database operations through REST API
  • SQL to REST query conversion
  • Natural language database interactions
  • Data manipulation via HTTP methods
  • Schema-aware database operations
  • Automated API interactions

Frequently Asked Questions

This is an MCP server for PostgREST. It allows LLMs perform database queries and operations on Postgres databases via PostgREST.
Supabase project or standalone PostgREST server, API URL endpoint, API key (optional), Schema name (e.g., public)View detailed requirements
Follow the installation instructions in the setup section above.View installation guide

Supabase MCP provides the following tools:

  • postgrestRequest
  • sqlToRest