Retourne la liste des tables configurées dans l’application, utilisée notamment pour le mode restauration ou la gestion des tables en salle.

Instructions

Implementation Reference

• src/tools/data.ts:90-115 (handler)

  The handler function for the tool. It resolves authentication, makes an HTTP GET request to '/workers/getTables.php' (path provided at registration), processes the data with structData, logs, and returns structured content or error.

  async ({ format }: CommonArgs, ctx: Ctx) => {
      try {
          const { shopId, apiKey } = resolveAuth(undefined, ctx);
          const data = await get(path, { idboutique: shopId, key: apiKey, format });
  
          process.stderr.write(
              `[caisse][tool:${toolName}] ok type=${Array.isArray(data) ? 'array' : typeof data}`
              + (Array.isArray(data) ? ` len=${data.length}` : '')
              + '\n'
          );
          //Array.isArray(data) ? data.slice(0, 50) : data
          const funcResult = structData( data);
          process.stderr.write(`[caisse][RES]  ${JSON.stringify(data)} \n`);
          process.stderr.write(`[caisse][RES] funcResult ${JSON.stringify(funcResult)} \n`);
          return funcResult;
          //return { content, structuredContent: isText ? undefined : data };
      } catch (e) {
          process.stderr.write(`[caisse][tool:${toolName}][error]\n`);
          process.stderr.write(`[caisse][tool:${toolName}][error] ${(e as Error).message}\n`);
          // renvoyer un message "propre" plutôt que laisser l’exception devenir un 424
          return {
              content: [{ type: 'text', text: `Erreur pendant la préparation de la réponse: ${(e as Error).message}` }],
              is_error: true,
          };
      }
  }

• src/tools/data.ts:11-13 (schema)

  Input schema for the tool: optional 'format' parameter (json, csv, html) with default 'json'.

  const CommonShape = {
      format: z.enum(['json', 'csv', 'html']).default('json'),
  } satisfies Record<string, ZodTypeAny>;

• src/tools/data.ts:134-134 (registration)

  Registration of the 'data_list_tables' tool using the registerSimple helper, specifying the PHP backend endpoint and i18n labels.

  registerSimple(server, 'data_list_tables', '/workers/getTables.php', t('tools.data_list_tables.description'), t('tools.data_list_tables.title'));

• src/tools/data.ts:75-117 (helper)

  Helper function registerSimple that creates and registers the MCP tool with common schema, generic handler proxying to a PHP endpoint, and read-only annotation.

  function registerSimple(
      server: McpServer | any,
      toolName: string,
      path: string,
      title: string,
      entityLabel: string
  ) {
      server.registerTool(
          toolName,
          {
              title,
              description: `Liste des ${entityLabel}`,
              inputSchema: CommonShape, // ZodRawShape,
              annotations: { readOnlyHint: true }
          },
          async ({ format }: CommonArgs, ctx: Ctx) => {
              try {
                  const { shopId, apiKey } = resolveAuth(undefined, ctx);
                  const data = await get(path, { idboutique: shopId, key: apiKey, format });
  
                  process.stderr.write(
                      `[caisse][tool:${toolName}] ok type=${Array.isArray(data) ? 'array' : typeof data}`
                      + (Array.isArray(data) ? ` len=${data.length}` : '')
                      + '\n'
                  );
                  //Array.isArray(data) ? data.slice(0, 50) : data
                  const funcResult = structData( data);
                  process.stderr.write(`[caisse][RES]  ${JSON.stringify(data)} \n`);
                  process.stderr.write(`[caisse][RES] funcResult ${JSON.stringify(funcResult)} \n`);
                  return funcResult;
                  //return { content, structuredContent: isText ? undefined : data };
              } catch (e) {
                  process.stderr.write(`[caisse][tool:${toolName}][error]\n`);
                  process.stderr.write(`[caisse][tool:${toolName}][error] ${(e as Error).message}\n`);
                  // renvoyer un message "propre" plutôt que laisser l’exception devenir un 424
                  return {
                      content: [{ type: 'text', text: `Erreur pendant la préparation de la réponse: ${(e as Error).message}` }],
                      is_error: true,
                  };
              }
          }
      );
  }

• src/tools/data.ts:52-73 (helper)

  Helper function to format tool response with a text preview (truncated if needed) and full structuredContent for MCP compliance.

  function structData(data: any) {
      // on ne touche PAS à structuredContent (c’est ce que ChatGPT utilise)
      const light = Array.isArray(data)
          ? data.slice(0, 5000)//.map(({ id, nom, email, tel, ...r }) => ({ id, nom, email, tel }))
          : data;
  
      const maxLength = 40000;
      const preview =
          typeof light === 'string'
              ? (light.length > maxLength ? light.slice(0, maxLength) + '…(truncated)' : light)
              : safeStringify(light, 2, maxLength);   // <-- aperçu court et “safe”
      const wrapped =
          Array.isArray(data)
              ? { data: data }
              : data && typeof data === 'object'
                  ? data
                  : { data: data };
      return {
          content: [{ type: 'text', text: preview }],
          structuredContent: wrapped,
      };
  }