Execute any query using tool

[isaacraja]

I am trying to get data from BigQuery using Toolbox as an MCP server. The BigQuery configuration under the tools section requires me to mention the statement(required) under the tool name yaml. Is there a way I can do this without just issuing the statement part of the YAML? Whatever MCP client I am using will decide the query to be run. Is it possible now? Thanks.

[brandon-powers]

Looks like #490 is related, and implements the first direct query tool vs. pre-defined queries. Seems like that could be extended.

Current model assumes:

• A tool can be compatible with N sources. A source can have many tools

To extend -- for each unique source, there would be a corresponding tool to query compatible data sources.

• e.g.
  • postgres-execute-sql tool (potentially) works with alloydb-postgres, cloud-sql-postgres, postgres sources = 1 unique source/direct query tool.

my-query-execution-tool:
    kind: "<unique-source-direct-query-tool>"
    source: <compatible-source>
    description: Use this tool to execute SQL.

Not sure if this is planned for other sources, though worth keeping a look out on that PR.

[Yuan325]

Yes! For #490 user can create a tool without specifying statement. This PR is specific towards potsgres databases, and we will extend it to all other databases soon. :)