Skip to content

Commit a976db2

Browse files
feat(mcp): advertise discovery tool per connection in list_connections (#135)
* feat(mcp): advertise discovery tool per connection in list_connections Each sqlkit connection now carries a 'discover' field pointing at sqlkit__list_tables as the first step to explore its objects, so agents know how to start querying any connection. Ultraworked with [Sisyphus](https://github.com/code-yeongyu/oh-my-openagent) Co-authored-by: Sisyphus <[email protected]> * feat(mcp): register schema/object inspection tools for sqlkit Expose 9 previously-implemented adapter methods as MCP tools: list_indexes, list_foreign_keys, list_views, list_procedures, list_functions, list_triggers, get_object_ddl, get_table_info, get_foreign_keys. Each handler covers all ActiveConnection variants. Adds 14 unit tests (missing config + required-arg validation). Ultraworked with [Sisyphus](https://github.com/code-yeongyu/oh-my-openagent) Co-authored-by: Sisyphus <[email protected]> * fix(sqlkit): make database optional in tool schemas + add object_type test list_indexes, list_foreign_keys, list_triggers, get_object_ddl: database marked required in schema but treated as optional in handler — now optional, consistent with list_tables. discover_tool_for: simplified no-op match to direct return. Added test for missing object_type validation in get_object_ddl. Ultraworked with [Sisyphus](https://github.com/code-yeongyu/oh-my-openagent) Co-authored-by: Sisyphus <[email protected]> --------- Co-authored-by: Sisyphus <[email protected]>
1 parent 7544574 commit a976db2

2 files changed

Lines changed: 988 additions & 0 deletions

File tree

0 commit comments

Comments
 (0)