Skip to main content
Glama
canbolayir

Supabase MCP Server

by canbolayir

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SUPABASE_URLYesYour Supabase instance URL
MCP_SERVER_NAMENoCustom server name (default: supabase-mcp-server)supabase-mcp-server
SUPABASE_ANON_KEYYesAnonymous/public key
MCP_SERVER_VERSIONNoCustom version (default: 1.0.0)1.0.0
SUPABASE_SERVICE_ROLE_KEYYesService role key (for admin operations)

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
connection_testB

Test connection to Supabase database and get basic info

auth_loginC

Login user with email and password

auth_signupB

Register a new user with email and password

auth_get_userA

Get current authenticated user information

auth_logoutA

Logout current user

schema_get_tablesB

Get list of all tables in the database schema

schema_get_columnsB

Get columns information for a specific table

schema_get_relationsA

Get foreign key relationships for a table

db_selectA

Select data from a table with optional filters and sorting

db_insertB

Insert new row(s) into a table

db_updateB

Update existing rows in a table

db_deleteB

Delete rows from a table

db_upsertB

Insert or update rows (upsert) in a table

db_countA

Count rows in a table with optional filters

realtime_subscribeC

Subscribe to real-time changes on a table

realtime_channel_createC

Create a real-time channel for broadcasting

realtime_broadcastB

Broadcast a message to a channel

storage_list_bucketsA

List all storage buckets

storage_create_bucketB

Create a new storage bucket

storage_delete_bucketB

Delete a storage bucket

storage_list_filesC

List files in a storage bucket

storage_upload_fileB

Upload a file to storage (base64 encoded)

storage_download_fileB

Download a file from storage

storage_delete_fileB

Delete a file from storage

storage_get_public_urlB

Get public URL for a file

sql_executeC

Execute raw SQL query (use with caution)

sql_call_rpcC

Call a stored procedure/function

sql_aggregateC

Execute SQL aggregate functions (COUNT, SUM, AVG, MIN, MAX)

sql_aggregate_enhancedB

Execute aggregate functions using raw SQL (bypasses Supabase client limitations)

sql_execute_rawC

Execute raw SQL with enhanced error handling and result formatting

sql_analyze_tableC

Get detailed table analysis including statistics

edge_invoke_functionC

Invoke a Supabase Edge Function

edge_list_functionsA

List available Edge Functions

edge_deploy_functionC

Deploy an Edge Function to Supabase

edge_remove_functionA

Remove an Edge Function from local serverless handler

security_enable_rlsB

Enable Row Level Security (RLS) on a table

security_disable_rlsB

Disable Row Level Security (RLS) on a table

security_create_policyB

Create a Row Level Security policy

security_drop_policyB

Drop a Row Level Security policy

security_list_policiesB

List all policies for a table

security_check_rls_statusC

Check RLS status for tables

security_test_policyB

Test a policy by simulating different user contexts

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/canbolayir/self-hosted-supabase-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server