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