[RFC] Data Analysis Toolkit

[tonxxd]

Is your feature request related to a problem? Please describe.
This feature proposal introduces a toolkit for SQL and data analysis, by enhancing current SQL tool and introducing few other concepts

Describe the solution you'd like

The SQL Toolkit will include:

• SQLMetadataTool: Extract and print metadata, with optional schema linking.
• SQLValuesSearchTool: Search for relevant filter values.
• SQLExecuteTool: Execute queries safely, flagging/blocking risky ones.
• SQLGetExamplesTool: Enhance accuracy using an array of example queries.
• SQLCorrect (Tentative): Initially part of SQLExecute to provide query correction.

The Data Analysis Toolkit will include:

• SQLToolkit (as above).
• PythonTool: Automatically include Python capabilities.
• ExcelAdvancedParser: Parse and convert large or complex Excel files into SQLite for advanced querying.

---

Describe alternatives you've considered
Adding tools individually, which lacks the flexibility and easy of use of a unified toolkit.
Creating a new Specialized Agent without the concept of toolkit.

---

Additional context
Part of the FlowPilot team's contribution to Bee.
Initial draft PR in progress.

Example

import { DataAnalysisToolkit } from "bee-agent-framework/toolkits/dataAnalysis";

const toolkit = new DataAnalysisToolkit({
   ...optional tools options
})



const agent = new BeeAgent({
  llm,
  memory: new UnconstrainedMemory(),
  templates: {
    system: BeeSystemPrompt.fork((old) => ({
      ...old,
      template: toolkit.getPrompt("system")
    })),
    thought: BeeThoughtPrompt.fork((old) => ({
      ...old,
      template: toolkit.getPrompt("thought")
    })),
  },
  tools: [
    new DuckDuckGoSearchTool({
      maxResults: 10,
      search: {
        safeSearch: DuckDuckGoSearchToolSearchType.STRICT,
      },
    }),
    ...toolkit.getTools()
  ],
});

[tonxxd]

It seems Claude uses javascript to analyze and render charts, it might be less powerful but easier to integrate with bee builder
https://www.anthropic.com/news/analysis-tool