Name: Supabase
Author: NightTrek

LABSCO SUMMARY

Table reads plus a types file, from one connection.

The query tool covers exploration — pick the schema, the columns, the filters and the page — and type generation turns the same database into a TypeScript definition without switching to a terminal. It authenticates with the service_role key, which means row-level security is neither in the way nor protecting you.

What it is

A Node server over a Supabase project with a table query — schema, columns, where clauses and pagination — and TypeScript type generation for any schema in the database.

What you get

Any table queried, in any schema, with a column list, where clauses and pagination
Multiple where operators rather than equality only
TypeScript types generated for a schema — public, auth, api or your own
Local and hosted Supabase projects both supported, with the project reference detected automatically
Query errors returned rather than swallowed

Requirements

Node.js v16 or higher, and the Supabase CLI installed — type generation shells out to it. Two environment variables carry the project URL and the key; the key is the service_role key rather than the anon key. Clone, npm install, npm run build, then point the client at the built build/index.js.

Setup effort

Build from source — git clone https://github.com/NightTrek/Supabase-MCP.git

See installation options

USE CASES

01

Looking at what is actually in a table

Select the schema and columns, apply a where clause, and page through the rows.

query_table

02

Getting types for the code you are writing

Generate the TypeScript definitions for the schema and paste them straight in.

generate_types

03

Checking a local project before you ship

The same tools point at a local Supabase instance, with the project reference detected for you.

query_tablegenerate_types

04

Digging into a non-public schema

Name the schema — auth, api or your own — instead of being limited to public.

query_tablegenerate_types

2 tools

Listed in project docs. Your client may show a different list.

query_table

generate_types

BEFORE YOU INSTALL

What to know first

Tools you get

2 tools named in the project's documentation.

Requires

Node.js v16 or higher
Supabase CLI (for type generation)
SUPABASE_URL in your environment
SUPABASE_KEY in your environment

Where it runs

Both documented clients run the server on your machine.

INSTALLATION

Connect your client

You clone and build this one yourself.

Server setup

TERMINAL

git clone https://github.com/NightTrek/Supabase-MCP.git
cd Supabase-MCP
npm install
npm run build

Install the Supabase CLI (required for type generation) — the README's Homebrew route:

TERMINAL

brew install supabase/tap/supabase

MCP Clients

Claude Desktop, Cline

JSON

{
  "mcpServers": {
    "supabase": {
      "command": "node",
      "args": [
        "<YOUR_PATH_TO_SUPABASE_MCP>/build/index.js"
      ],
      "env": {
        "SUPABASE_URL": "<YOUR_SUPABASE_URL>",
        "SUPABASE_KEY": "<YOUR_SUPABASE_KEY>"
      }
    }
  }
}

Supabase