MCP.so
ログイン

Self-Hosted Supabase MCP Server

@HenkDz

基本情報

カテゴリ

クラウドとインフラ

トランスポート

stdio

作者

HenkDz

Self-Hosted Supabase MCP Server について

An MCP Server for your Self Hosted Supabase

Self-Hosted Supabase MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "selfhosted-supabase-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@HenkDz/selfhosted-supabase-mcp",
        "--client",
        "claude"
      ]
    }
  }
}

Self-Hosted Supabase MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is Self-Hosted Supabase MCP Server?

A Model Context Protocol (MCP) server for interacting with self-hosted Supabase instances. It enables MCP clients (like IDE extensions) to introspect, manage, and interact with local or privately hosted Supabase projects through database schema queries, migrations, statistics, authentication, storage, and edge functions.

How to use Self-Hosted Supabase MCP Server?

Install via Smithery (npx -y @smithery/cli install @HenkDz/selfhosted-supabase-mcp --client claude) or clone the repository, install dependencies with bun install, build with bun run build, then configure with required arguments --url and --anon-key (or environment variables). Optionally provide --service-key, --db-url, --jwt-secret for privileged tools and HTTP transport.

Key features of Self-Hosted Supabase MCP Server

  • 40+ tools covering schema, migrations, database stats, RLS, auth, storage, functions, and edge functions.
  • Tool privilege levels: regular (any authenticated JWT) and privileged (requires service_role JWT or direct DB access).
  • Supports both stdio and HTTP transports (HTTP enforces JWT authentication and RBAC).
  • Relies on supabase_migrations.schema_migrations table (created by Supabase CLI).
  • Optional whitelist of enabled tools via --tools-config JSON file.
  • Automatic execute_sql helper function creation on startup if service key and DB URL are provided.

Use cases of Self-Hosted Supabase MCP Server

  • Querying database schemas and data from an MCP-enabled editor.
  • Managing database migrations without leaving the development environment.
  • Inspecting database statistics, connections, and index usage.
  • Managing authentication users and storage buckets programmatically.
  • Generating TypeScript types from the database schema.

よくある質問

1

What is the difference from the official Supabase cloud MCP server?

This server is built specifically for self-hosted Supabase, avoiding cloud-specific APIs and multi-project complexity. It uses a minimal `schema_migrations` table compatible with the Supabase CLI's local-developement workflow.

2

What are the runtime requirements?

Bun v1.1 or later, access to a self-hosted Supabase instance (URL, keys, optionally direct PostgreSQL connection string). HTTP transport also requires setting a JWT secret for authentication.

3

Does the server require direct database access?

Some tools (`apply_migration`, Auth tools, Storage tools, `pg_catalog` queries) require a `DATABASE_URL`. The server starts successfully without it; only tools needing direct DB access will fail.

4

How are privileged tools protected?

In HTTP mode, the server enforces JWT authentication and role‑based access control (RBAC). Only JWTs with the `service_role` claim can invoke privileged tools. In stdio mode, privileged tools require direct database access or service key.

5

What transports are supported?

Two transports: stdio (default, for local use) and HTTP (for remote access with JWT authentication and CORS configuration). Use `--transport http` to enable the HTTP server.

コメント

「クラウドとインフラ」の他のコンテンツ