runClickhouseQuery.js

/**
* Example Function Module. Each function needs you to define 4 things:
*/

/* 1. Name of your function (must be unique) */
export const name = "runClickhouseQuery";

/* 2. Description of function, used to describe what it does to an LLM */
export const description = "This function executes clickhouse queries";

/**
* 3. A JSON Schema defining the function's parameters. See:
*
* - https://platform.openai.com/docs/guides/gpt/function-calling
* - https://json-schema.org/learn/getting-started-step-by-step
*/
export const parameters = {
    type: "object",
    properties: {
      value: {
        type: "string",
        description: "Valid clickhouse sql",
      },
    },
    required: ["value"],
};

/**
 * 4. The function itself. Accepts an Object matching the schema
 * defined in params, returning a Promise<string> (i.e., should be
 * an async function).
 */
export default async function (value) {
  console.log(value)
  return fetch("https://play.clickhouse.com/?user=play", {
    method: "POST",
    body: `${value.value} FORMAT Markdown`,
  }).then(x=>x.text());
}