Selfhosted Supabase MCP

Unclaimed

by HenkDz

An MCP Server for your Self Hosted Supabase

Install

$npx -y @smithery/cli install @HenkDz/selfhosted-supabase-mcp --client claude

Unclaimed listing

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Tools (40)

apply_migration

Applies a SQL migration and records it in supabasemigrations.schemamigrations

create_auth_user

Creates a new user in auth.users (password bcrypt-hashed via pgcrypto)

delete_auth_user

Deletes a user from auth.users

execute_sql

Executes an arbitrary SQL query

explain_query

Runs EXPLAIN ANALYZE on a query

generate_typescript_types

Generates TypeScript types from the database schema

get_advisors

Retrieves security and performance advisory notices

get_auth_user

Retrieves details for a specific user

get_cron_job_history

Shows recent execution history for a cron job

get_database_connections

Shows active connections (pgstatactivity)

get_database_stats

Retrieves database statistics (pgstat)

get_function_definition

Gets the source definition of a function

get_index_stats

Shows index usage statistics

get_logs

Retrieves recent log entries (analytics stack or CSV fallback)

get_project_url

Returns the configured Supabase URL

get_rls_status

Shows RLS enabled/disabled status for tables

get_storage_config

Retrieves storage bucket configuration

get_trigger_definition

Gets the source definition of a trigger

get_vector_index_stats

Shows pgvector index statistics

list_auth_users

Lists users from auth.users

list_available_extensions

Lists all available (installable) extensions

list_constraints

Lists constraints for a specific table

list_cron_jobs

Lists scheduled jobs (requires pgcron extension)

list_database_functions

Lists user-defined database functions

list_extensions

Lists installed PostgreSQL extensions

list_foreign_keys

Lists foreign keys for a specific table

list_indexes

Lists indexes for a specific table

list_migrations

Lists applied migrations from supabasemigrations.schemamigrations

list_realtime_publications

Lists PostgreSQL publications (e.g. supabaserealtime)

list_rls_policies

Lists Row-Level Security policies for a table

list_storage_buckets

Lists all storage buckets

list_storage_objects

Lists objects within a specific bucket

list_table_columns

Lists columns for a specific table

list_tables

Lists tables in the database schemas

list_triggers

Lists triggers for a specific table

list_vector_indexes

Lists pgvector indexes (requires pgvector extension)

rebuild_hooks

Restarts the pgnet worker (if used)

update_auth_user

Updates user details (password bcrypt-hashed if changed)

update_storage_config

Updates storage bucket settings

verify_jwt_secret

Checks if the JWT secret is configured