Repository navigation
Commit a976db2
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
0 commit comments