Self-Hosted Supabase MCP Server

Instructions

Implementation Reference

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

  The main handler function for the 'rebuild_hooks' tool. It executes SQL to restart the pg_net worker using executeSqlWithFallback, handles errors, and returns success/failure with a message.
  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-15 (schema)

  Zod schemas defining the input (empty object) and output (success boolean and message string) 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(), });
• src/index.ts:98-121 (registration)

  The rebuildHooksTool is registered in the availableTools object, which is used to set up the MCP server's tool capabilities.
  const availableTools = { // Cast here assumes tools will implement AppTool structure [listTablesTool.name]: listTablesTool as AppTool, [listExtensionsTool.name]: listExtensionsTool as AppTool, [listMigrationsTool.name]: listMigrationsTool as AppTool, [applyMigrationTool.name]: applyMigrationTool as AppTool, [executeSqlTool.name]: executeSqlTool as AppTool, [getDatabaseConnectionsTool.name]: getDatabaseConnectionsTool as AppTool, [getDatabaseStatsTool.name]: getDatabaseStatsTool as AppTool, [getProjectUrlTool.name]: getProjectUrlTool as AppTool, [getAnonKeyTool.name]: getAnonKeyTool as AppTool, [getServiceKeyTool.name]: getServiceKeyTool as AppTool, [generateTypesTool.name]: generateTypesTool as AppTool, [rebuildHooksTool.name]: rebuildHooksTool as AppTool, [verifyJwtSecretTool.name]: verifyJwtSecretTool as AppTool, [listAuthUsersTool.name]: listAuthUsersTool as AppTool, [getAuthUserTool.name]: getAuthUserTool as AppTool, [deleteAuthUserTool.name]: deleteAuthUserTool as AppTool, [createAuthUserTool.name]: createAuthUserTool as AppTool, [updateAuthUserTool.name]: updateAuthUserTool as AppTool, [listStorageBucketsTool.name]: listStorageBucketsTool as AppTool, [listStorageObjectsTool.name]: listStorageObjectsTool as AppTool, [listRealtimePublicationsTool.name]: listRealtimePublicationsTool as AppTool, };
• src/index.ts:22-22 (registration)

  Import statement for the rebuildHooksTool in the main index file.
  import { rebuildHooksTool } from './tools/rebuild_hooks.js';