Supabase MCP Server

Enables LLMs to query Supabase databases and understand their structure through a Model Context Protocol.

Remote serverstreamable-httpTypeScript 14

What is the Supabase MCP server?

Connect Supabase to Claude, Cursor or any other MCP client and it stops being a tab you switch to. Enables LLMs to query Supabase databases and understand their structure through a Model Context Protocol. The supabase mcp server is what makes that connection.

What the server does

A Model Context Protocol (MCP) server for interacting with Supabase databases. This server provides tools for querying tables and generating TypeScript types through the MCP interface.

  • Query Tables — Execute queries on any table with support for:
  • Schema selection
  • Column filtering
  • Where clauses with multiple operators
  • Error handling
  • Type Generation — Generate TypeScript types for your database:

Available tools

The toolset is worth reading before you wire it up, because it tells you what the integration is really for:

  • query_table — Query a specific table with schema selection and where clause support
  • generate_types — Generate TypeScript types for your Supabase database schema

Credentials and setup notes

Configuration is passed through the environment: SUPABASE_URL, SUPABASE_KEY. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.

  1. Node.js (v16 or higher) 2. A Supabase project (either local or hosted) 3. Supabase CLI (for type generation)

Installation

Because this one is hosted, setup is mostly authentication — you point your client at the endpoint and approve access. Nothing runs on your machine, so there is no runtime to keep patched.

Where it fits

This sits in the database access group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. Supabase's toolset — query_table, generate_types — is a fair guide to whether it matches your workflow. It is maintained by NightTrek; worth a glance at recent repository activity before you build anything load-bearing on it.

This entry was verified against Supabase's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.

Worth knowing first

  • Your data travels to the provider's service, so the usual questions apply about what you send and what they retain.
  • Missing credentials fail quietly in some clients — if no tools show up, check the environment block first.
  • Keep per-call confirmation enabled while you learn its behaviour; it is the cheapest safeguard you have.

Available tools

ToolWhat it does
query_tableQuery a specific table with schema selection and where clause support.
generate_typesGenerate TypeScript types for your Supabase database schema.

How to install the Supabase MCP server

{
  "mcpServers": {
    "supabase": {
      "command": "node",
      "args": ["/absolute/path/to/supabase-mcp-server/build/index.js"],
      "env": {
        "SUPABASE_URL": "your_project_url",
        "SUPABASE_KEY": "your_service_role_key"
      }
    }
  }
}

Configuration as documented by the project. Restart the client after saving.

Configuration

  1. Node.js (v16 or higher) 2. A Supabase project (either local or hosted) 3. Supabase CLI (for type generation)
VariableDescriptionRequired
SUPABASE_URLEndpoint or connection string the server talks to.Yes
SUPABASE_KEYCredential the server authenticates with.Yes

Example prompts to try

  • Use Supabase to query table.
  • Use Supabase to generate types.

Frequently asked questions

Key features include querying tables with schema selection, column filtering, and where clauses; generating TypeScript types for your database schemas; support for local and remote Supabase projects; and automatic project reference detection.