Supabase MCP Server

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

Integrations

  • Enables read-only SQL queries against a PostgreSQL database, with tools for analyzing table statistics and relationships between tables

  • Connects to a Supabase PostgreSQL database, exposing table schemas as resources and providing tools for data analysis, SQL querying, and relationship exploration

Supabase MCP Server

An MCP server that connects to a Supabase PostgreSQL database, exposing table schemas as resources and providing tools for data analysis.

Features

  • Connection to Supabase PostgreSQL database
  • Table schemas exposed as resources
  • Read-only SQL query tools
  • Prompts for common data analysis tasks

Setup

  1. Clone this repository
  2. Install dependencies:
    npm install
  3. Copy .env.example to .env and update with your Supabase credentials:
    cp .env.example .env
  4. Edit the .env file with your actual Supabase connection details

Running the Server

Using stdio (command line integration)

npm start

Using HTTP with SSE (for web integration)

npm run start:http

Using with MCP Clients

This server can be used with any MCP-compatible client, including Claude.app and the MCP Inspector for testing.

Available Resources

  • schema://tables - Lists all tables in the database
  • schema://table/{tableName} - Shows schema for a specific table

Available Tools

  • query - Runs a read-only SQL query against the database
  • analyze-table - Gets basic statistics about a table
  • find-related-tables - Discovers tables related to a given table

Available Prompts

  • table-exploration - Guides exploration of a specific table
  • data-summary - Creates a summary of data in a table
  • relationship-analysis - Analyzes relationships between tables
-
security - not tested
F
license - not found
-
quality - not tested

An MCP server that connects to Supabase PostgreSQL databases, exposing table schemas as resources and providing tools for data analysis through SQL queries.

  1. Features
    1. Setup
      1. Running the Server
        1. Using stdio (command line integration)
        2. Using HTTP with SSE (for web integration)
      2. Using with MCP Clients
        1. Available Resources
        2. Available Tools
        3. Available Prompts