SSyncDev

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?

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

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:

Credentials and setup notes

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

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
query_table
generate_types

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_SUPABASE_KEY"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

  1. Node.js (v16 or higher) 2. A Supabase project (either local or hosted) 3. Supabase CLI (for type generation)
VariableDescriptionRequired
SUPABASE_URLDeclared in the maintainer’s client configuration.Check documentation
SUPABASE_KEYDeclared in the maintainer’s client configuration.Check documentation

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.

Alternatives to the Supabase MCP Server

PostgreSQL

Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.

DatabasesTypeScript★ 63.0k

Notion

Official

Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.

Productivity & Project ManagementRemoteTypeScript★ 3.3k

MCP

EBI BioStudies MCP.

Databases

OwnPG

PostgreSQL DBA tools over MCP, scoped to one database and one schema.

Developer Tools

Chron

Timestamped audit log for every AI conversation — stored locally in SQLite, owned by you.

Databases

Activecampaign By Cdata

:heavy_exclamation_mark: This project builds a local, read-only MCP server. For fully remote MCP access, check out the first managed MCP platform

Developer ToolsRemote