hermes - 💡(How to fix) Fix [Feature]: Support data retrieval from database for various dialects of databases [1 pull requests]

Problem or Use Case

I'm trying to use Hermes-agent to answer business/data questions directly from configured databases. However, it is hard because of database-specific friction. In current method, if the database is PostgreSQL, agent can use pgvector for retrieval. However, other dialects of databases do not have this convenient interface.

We need a multifunctional (or hopefully universal) way for agent to retrieve data.

Proposed Solution

Raw SQL Syntax is the origin of all dialects, which would be good. And this should be a tool since it connect to database and do read-only query (SELECT). Since other command would be kind of dangerous, I omit it in current stage. We may add other options in the future

Alternatives Considered

No response

Feature Type

New tool

Scope

None

Contribution

• I'd like to implement this myself and submit a PR

Debug Report (optional)