{"slug":"HenkDz/selfhosted-supabase-mcp","name":"Self-Hosted Supabase MCP Server","description":"Interact with self-hosted Supabase instances for database introspection, management, and interaction.","category":"database","tags":[],"official":false,"stars":137,"transport":"stdio","install":[{"cmd":"npx -y @smithery/cli","imports":[]}],"tools":[{"name":"list_tables","description":"Lists tables in the database schemas"},{"name":"list_extensions","description":"Lists installed PostgreSQL extensions"},{"name":"list_available_extensions","description":"Lists all available (installable) extensions"},{"name":"list_migrations","description":"Lists applied migrations from supabase_migrations.schema_migrations"},{"name":"apply_migration","description":"Applies a SQL migration and records it in supabase_migrations.schema_migrations"},{"name":"list_table_columns","description":"Lists columns for a specific table"},{"name":"list_indexes","description":"Lists indexes for a specific table"},{"name":"list_constraints","description":"Lists constraints for a specific table"},{"name":"list_foreign_keys","description":"Lists foreign keys for a specific table"},{"name":"list_triggers","description":"Lists triggers for a specific table"},{"name":"list_database_functions","description":"Lists user-defined database functions"},{"name":"get_function_definition","description":"Gets the source definition of a function"},{"name":"get_trigger_definition","description":"Gets the source definition of a trigger"},{"name":"execute_sql","description":"Executes an arbitrary SQL query"},{"name":"explain_query","description":"Runs EXPLAIN ANALYZE on a query"},{"name":"get_database_connections","description":"Shows active connections (pg_stat_activity)"},{"name":"get_database_stats","description":"Retrieves database statistics (pg_stat_*)"},{"name":"get_index_stats","description":"Shows index usage statistics"},{"name":"get_vector_index_stats","description":"Shows pgvector index statistics"},{"name":"list_rls_policies","description":"Lists Row-Level Security policies for a table"},{"name":"get_rls_status","description":"Shows RLS enabled/disabled status for tables"},{"name":"get_advisors","description":"Retrieves security and performance advisory notices"},{"name":"get_project_url","description":"Returns the configured Supabase URL"},{"name":"verify_jwt_secret","description":"Checks if the JWT secret is configured"},{"name":"generate_typescript_types","description":"Generates TypeScript types from the database schema"},{"name":"rebuild_hooks","description":"Restarts the pg_net worker (if used)"},{"name":"get_logs","description":"Retrieves recent log entries (analytics stack or CSV fallback)"},{"name":"list_auth_users","description":"Lists users from auth.users"},{"name":"get_auth_user","description":"Retrieves details for a specific user"},{"name":"create_auth_user","description":"Creates a new user in auth.users (password bcrypt-hashed via pgcrypto)"},{"name":"update_auth_user","description":"Updates user details (password bcrypt-hashed if changed)"},{"name":"delete_auth_user","description":"Deletes a user from auth.users"},{"name":"list_storage_buckets","description":"Lists all storage buckets"},{"name":"list_storage_objects","description":"Lists objects within a specific bucket"},{"name":"get_storage_config","description":"Retrieves storage bucket configuration"},{"name":"update_storage_config","description":"Updates storage bucket settings"},{"name":"list_realtime_publications","description":"Lists PostgreSQL publications (e.g. supabase_realtime)"},{"name":"list_cron_jobs","description":"Lists scheduled jobs (requires pg_cron extension)"},{"name":"get_cron_job_history","description":"Shows recent execution history for a cron job"},{"name":"list_vector_indexes","description":"Lists pgvector indexes (requires pgvector extension)"}],"env_vars":["SUPABASE_URL","SUPABASE_ANON_KEY","SUPABASE_SERVICE_ROLE_KEY","DATABASE_URL","SUPABASE_AUTH_JWT_SECRET","ANON_KEY","SERVICE_ROLE_KEY","POSTGRES_HOST","POSTGRES_PORT"],"auth_type":"none","github":"https://github.com/HenkDz/selfhosted-supabase-mcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}