canbolayir/self-hosted-supabase-mcp
If you are the rightful owner of self-hosted-supabase-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A comprehensive Model Context Protocol server for self-hosted Supabase instances, providing 42 tools for managing Supabase features through Claude.
Tools
Functions exposed to the LLM to take actions
connection_test
Test your Supabase connection
auth_signup
Register new users
auth_login
Authenticate users
auth_get_user
Get current user info
auth_logout
Sign out users
db_select
Query data with filters and sorting
db_insert
Insert new records
db_update
Update existing records
db_delete
Delete records
db_upsert
Insert or update (with conflict handling)
db_count
Count records with filters
schema_get_tables
List all tables
schema_get_columns
Get column information
schema_get_relations
Explore foreign key relationships
storage_list_buckets
List storage buckets
storage_create_bucket
Create new buckets
storage_delete_bucket
Remove buckets
storage_list_files
Browse files
storage_upload_file
Upload files (base64)
storage_download_file
Download files
storage_delete_file
Remove files
storage_get_public_url
Get public file URLs
edge_list_functions
List deployed functions
edge_deploy_function
Deploy new functions
edge_invoke_function
Execute functions
edge_remove_function
Clean up functions
realtime_subscribe
Listen to database changes
realtime_channel_create
Set up broadcast channels
realtime_broadcast
Send messages to channels
sql_execute
Run SQL queries with smart parsing
sql_call_rpc
Execute stored procedures
sql_aggregate
COUNT, SUM, AVG, MIN, MAX operations
sql_execute_raw
Raw SQL with multiple fallback methods
sql_aggregate_enhanced
Advanced aggregation with client-side processing
sql_analyze_table
Get detailed table statistics
security_check_rls_status
Check Row Level Security status
security_enable_rls
Enable RLS on tables
security_disable_rls
Disable RLS
security_create_policy
Create RLS policies
security_list_policies
List existing policies
security_drop_policy
Remove policies
security_test_policy
Test policy effectiveness
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client