Self-Hosted Supabase MCP Server

Instructions

Implementation Reference

• src/tools/rebuild_hooks.ts:31-61 (handler)

  The execute function implementing the rebuild_hooks tool, which restarts the pg_net worker using net.worker_restart() SQL.

  execute: async (input: RebuildHooksInput, context: ToolContext) => {
      const client = context.selfhostedClient;
  
      // Attempt to restart the pg_net worker.
      // This might fail if pg_net is not installed or the user lacks permissions.
      const restartSql = 'SELECT net.worker_restart()'; // Remove semicolon
  
      try {
          console.error('Attempting to restart pg_net worker...');
          const result = await executeSqlWithFallback(client, restartSql, false);
  
          // Check if the result contains an error
          if ('error' in result) {
              // Specific check for function not found (pg_net might not be installed/active)
              const notFound = result.error.code === '42883'; // undefined_function
              const message = `Failed to restart pg_net worker: ${result.error.message}${notFound ? ' (Is pg_net installed and enabled?)' : ''}`;
              console.error(message);
              return { success: false, message };
          }
  
          // If no error, assume success
          console.error('pg_net worker restart requested successfully.');
          return { success: true, message: 'pg_net worker restart requested successfully.' };
  
      } catch (error: unknown) {
          // Catch exceptions during the RPC call itself
          const errorMessage = error instanceof Error ? error.message : String(error);
          console.error(`Exception attempting to restart pg_net worker: ${errorMessage}`);
          return { success: false, message: `Exception attempting to restart pg_net worker: ${errorMessage}` };
      }
  },

• src/tools/rebuild_hooks.ts:8-22 (schema)

  Zod input/output schemas and static MCP input schema for the rebuild_hooks tool.

  const RebuildHooksInputSchema = z.object({});
  type RebuildHooksInput = z.infer<typeof RebuildHooksInputSchema>;
  
  // Output schema
  const RebuildHooksOutputSchema = z.object({
      success: z.boolean(),
      message: z.string(),
  });
  
  // Static JSON Schema for MCP capabilities
  const mcpInputSchema = {
      type: 'object',
      properties: {},
      required: [],
  };

• src/index.ts:111-111 (registration)

  Registration of rebuildHooksTool in the availableTools object for the MCP server.

  [rebuildHooksTool.name]: rebuildHooksTool as AppTool,

• src/index.ts:22-22 (registration)

  Import of the rebuildHooksTool.

  import { rebuildHooksTool } from './tools/rebuild_hooks.js';