Supabase MCP Server

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
A
license - permissive license
-
quality - not tested

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.

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

      Related MCP Servers

      • A
        security
        A
        license
        A
        quality
        An MCP server that provides tools for interacting with Supabase databases, storage, and edge functions.
        Last updated -
        14
        41
        JavaScript
        MIT License
      • -
        security
        A
        license
        -
        quality
        This is an MCP server for PostgREST. It allows LLMs perform database queries and operations on Postgres databases via PostgREST. This server works with both Supabase projects (which use PostgREST) and standalone PostgREST servers.
        Last updated -
        438
        1,371
        TypeScript
        Apache 2.0
        • Apple
      • A
        security
        A
        license
        A
        quality
        This server enables interaction with Supabase PostgreSQL databases through the MCP protocol, allowing seamless integration with Cursor and Windsurf IDEs for secure and validated database management.
        Last updated -
        11
        649
        Python
        Apache 2.0
        • Apple
        • Linux
      • -
        security
        A
        license
        -
        quality
        An MCP server that enables natural language querying of Supabase PostgreSQL databases using Claude 3.7, allowing users to inspect schemas, execute SQL, manage migrations, and convert natural language to SQL queries.
        Last updated -
        Python
        MIT License
        • Linux
        • Apple

      View all related MCP servers

      ID: mg38z3mo5q