HybridHub

Instructions

Implementation Reference

• src/server.ts:122-130 (handler)

  The handler function for the 'execute_sql' tool. Currently a stub that returns a placeholder response indicating the actual SQL execution is not yet implemented.

  async (args) => {
    // TODO: Implement actual SQL execution with database connector
    return createToolSuccessResponse({
      message: `SQL execution on '${sourceId}' not yet implemented`,
      sql: args.sql,
      source_id: sourceId,
      note: "Database connector integration pending",
    });
  }

• src/server.ts:119-121 (schema)

  Input schema definition for the 'execute_sql' tool using Zod, specifying a single 'sql' string parameter.

  {
    sql: z.string().describe("SQL query or multiple SQL statements to execute"),
  },

• src/server.ts:116-131 (registration)

  Registration of the 'execute_sql' tool (with optional source suffix) in the registerTools function, called for each configured database source.

  server.tool(
    `execute_sql${toolSuffix}`,
    `Execute SQL query on the '${sourceId}' database. Returns query results as JSON.`,
    {
      sql: z.string().describe("SQL query or multiple SQL statements to execute"),
    },
    async (args) => {
      // TODO: Implement actual SQL execution with database connector
      return createToolSuccessResponse({
        message: `SQL execution on '${sourceId}' not yet implemented`,
        sql: args.sql,
        source_id: sourceId,
        note: "Database connector integration pending",
      });
    }
  );

• src/types/config.ts:268-271 (schema)

  Type definition listing 'execute_sql' as one of the built-in database tools.

  export const BUILTIN_DATABASE_TOOLS = [
    "execute_sql",
    "search_objects", // For database schema search
  ] as const;

• src/server.ts:79-88 (helper)

  Helper function used by the execute_sql handler to format successful tool responses as JSON text content.

  function createToolSuccessResponse(data: any) {
    return {
      content: [
        {
          type: "text" as const,
          text: JSON.stringify(data, null, 2),
        },
      ],
    };
  }