davsclaus opened a new pull request, #24281: URL: https://github.com/apache/camel/pull/24281
## Summary - Add `sql-query` dev-console for executing SQL queries and row updates against DataSource beans via JDBC - Add `camel sql` CLI command for querying databases from the terminal - Add SQL Query TUI tab with multi-line input, query history (Ctrl+E), datasource switching, and result table - Add inline row editing: press Enter on a result row to open an edit form, change values, F5 to auto-generate and execute an UPDATE statement (single-table queries only, with PK detection via JDBC metadata) - Add `tui_execute_sql`, `tui_update_row` MCP tools for AI agents - Enrich `tui_get_table` MCP response with SQL input state, datasource, selected row, and editability metadata ## Test plan - [ ] Run a Camel app with a DataSource (e.g. the built-in `sql` example) - [ ] Open TUI, navigate to SQL Query tab, execute `SELECT * FROM table` - [ ] Verify results display with row count and elapsed time - [ ] Tab to results, press Enter on a row — edit form opens - [ ] Change a value, press F5 — UPDATE executes, table refreshes - [ ] Verify PK columns are read-only (marked with *) - [ ] Verify complex queries (JOINs) don't show Edit option - [ ] Verify Ctrl+E opens query history - [ ] Verify number keys don't switch tabs during edit mode - [ ] Test MCP tools: `tui_execute_sql`, `tui_update_row`, `tui_get_table` 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <[email protected]> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
