[RFC] Data Analysis Toolkit

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()
  ],
});

i-am-bee / bee-agent-framework

[RFC] Data Analysis Toolkit #182