rebuild_hooks
Restart the pg_net worker to ensure proper functionality with the pg_net extension in a Self-Hosted Supabase MCP Server environment.
Instructions
Attempts to restart the pg_net worker. Requires the pg_net extension to be installed and available.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
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';