Create branch for append query

[Mrthnx]

Create branch for append query

What changes

• History now allows you to add a query to the end of the editor without replacing the existing one.
• The history modal adds a shortcut a for Append and keeps Enter for Select.

How to use it

1. Open history (in NORMAL mode with backspace).
2. Select a query.
3. Press a to add it to the end of the editor.

Technical details

• An append action has been added to the history modal and is exposed in the shortcuts.
• _append_history_query has been added to the history handler, which:
  • Trims trailing line breaks from the current text.
  • Inserts the selected query at the end.
  • Moves the cursor to the end and maintains focus.
• Telescope also supports append.

Modified files

• sqlit/domains/query/ui/screens/query_history.py
• sqlit/domains/query/ui/mixins/query_execution.py

[Maxteabag]

Hey. Cool idea. So in other words - to duplicate a query?

Was this supposed to be a PR? You mentioned some modified files but this is an issue.

[Mrthnx]

Not exactly duplicate—it’s just that right now, when I select a query, all my queries get deleted. I’d like to be able to keep them and just append the selected query. I have the changes in a branch, but I don’t have permission to submit a PR for you to review. Or, if you’d like, I can send you the changes via email.

[Mrthnx]

Changelog - Last Commit

Commit Information

Field	Value
Hash	c8a81a80f9e736439ff2ed2387c4cf2c0f7c92a5
Author	Marthin Lachira
Date	2026-02-10
Message	🚀 feat(query-history): append history queries without replacing

---

Summary

• Files modified: 2
• Lines added: 51
• Lines deleted: 1

---

Code Changes

1. sqlit/domains/query/ui/mixins/query_execution.py

diff --git a/sqlit/domains/query/ui/mixins/query_execution.py b/sqlit/domains/query/ui/mixins/query_execution.py
index 5a9e793..3456b95 100644
--- a/sqlit/domains/query/ui/mixins/query_execution.py
+++ b/sqlit/domains/query/ui/mixins/query_execution.py
@@ -745,6 +745,28 @@ class QueryExecutionMixin(ProcessWorkerLifecycleMixin):
         # Focus query input - this triggers on_descendant_focus which updates footer bindings
         self.query_input.focus()
 
+    def _append_history_query(self: QueryMixinHost, query: str) -> None:
+        """Append a query to the end of the editor without replacing text."""
+        if query is None:
+            return
+
+        current_text = self.query_input.text
+        if current_text:
+            trimmed_current = current_text.rstrip("\n")
+            separator = "\n" if trimmed_current else ""
+            new_text = f"{trimmed_current}{separator}{query}"
+        else:
+            new_text = query
+
+        self._push_undo_state()
+        self.query_input.text = new_text
+
+        lines = new_text.split("\n")
+        last_line = len(lines) - 1
+        last_col = len(lines[-1]) if lines else 0
+        self.query_input.cursor_location = (last_line, last_col)
+        self.query_input.focus()
+
     def action_show_history(self: QueryMixinHost) -> None:
         """Show query history for the current connection."""
         if not self.current_config:
@@ -772,6 +794,8 @@ class QueryExecutionMixin(ProcessWorkerLifecycleMixin):
         action, data = result
         if action == "select":
             self._apply_history_query(data)
+        elif action == "append":
+            self._append_history_query(data)
         elif action == "delete":
             self._delete_history_entry(data)
             self.action_show_history()
@@ -843,6 +867,10 @@ class QueryExecutionMixin(ProcessWorkerLifecycleMixin):
             query = data.get("query", "")
             connection_name = data.get("connection_name", "")
             self._run_telescope_query(connection_name, query)
+        elif action == "append":
+            query = data.get("query", "")
+            if query:
+                self._append_history_query(query)
         elif action == "delete":
             timestamp = data.get("timestamp", "")
             connection_name = data.get("connection_name", "")

---

2. sqlit/domains/query/ui/screens/query_history.py

diff --git a/sqlit/domains/query/ui/screens/query_history.py b/sqlit/domains/query/ui/screens/query_history.py
index 2176eab..2d7be9a 100644
--- a/sqlit/domains/query/ui/screens/query_history.py
+++ b/sqlit/domains/query/ui/screens/query_history.py
@@ -26,6 +26,7 @@ class QueryHistoryScreen(ModalScreen):
         Binding("escape", "cancel", "Cancel", priority=True),
         Binding("q", "cancel", "Cancel"),
         Binding("enter", "select", "Select"),
+        Binding("a", "append", "Append"),
         Binding("d", "delete", "Delete"),
         Binding("asterisk", "toggle_star", "Star"),
         Binding("slash", "open_filter", "Filter"),
@@ -177,7 +178,12 @@ class QueryHistoryScreen(ModalScreen):
         else:
             title = f"Query History - {self.connection_name}"
             empty_message = "No query history for this connection"
-        shortcuts = [("Select", "<enter>"), ("Star", "*"), ("Delete", "D")]
+        shortcuts = [
+            ("Select", "<enter>"),
+            ("Append", "a"),
+            ("Star", "*"),
+            ("Delete", "D"),
+        ]
 
         self._merged_entries = self._merge_entries()
 
@@ -240,6 +246,22 @@ class QueryHistoryScreen(ModalScreen):
         except Exception:
             self.dismiss(None)
 
+    def action_append(self) -> None:
+        entries = self._get_display_entries()
+        if not entries:
+            self.dismiss(None)
+            return
+
+        try:
+            option_list = self.query_one("#history-list", OptionList)
+            idx = option_list.highlighted
+            if idx is not None and idx < len(entries):
+                self.dismiss(self._build_action_result("append", entries[idx]))
+            else:
+                self.dismiss(None)
+        except Exception:
+            self.dismiss(None)
+
     def on_option_list_option_selected(self, event: OptionList.OptionSelected) -> None:
         if event.option_list.id == "history-list":
             idx = event.option_list.highlighted

---

Feature Summary

This feature allows users to press a in the query history to append the selected query to the end of the editor instead of replacing the existing content. This is useful when you want to concatenate multiple queries from history.

Shortcut	Action	Description
<enter>	Select	Replaces editor content
a	Append	Adds to the end of the editor
*	Star	Marks as favorite
D	Delete	Removes from history

[Mrthnx]

@Maxteabag Hey, will you keep that in mind?

[Maxteabag]

Going through issues one by one - I'll get back to you