sql-param 1.3.0

A tool for automatically replacing sql placeholders.

Install

cargo install sql-param

Usage

Simply run the sql-param command to open the TUI interface. First, enter the SQL statement with ? placeholders. Then, use the mouse click or Tab key to switch focus and input the corresponding values. Press Tab or mouse click again to view the final SQL result with placeholders automatically replaced. The result is also automatically copied to the system clipboard, so you can simply paste it anywhere using Command+V(MacOS)/Ctrl+V(Linux or Windows).

Here is an example:

Sql with placeholders

UPDATE user SET name = ?, age = ?, update_time = ?, id_card = ? WHERE id = ? AND deleted = ?;

Value

zhangsan(String), 18(Integer), 2025-06-13 16:44:56.499(Timestamp), 123456789(Long), 1(Integer), 0(Integer);

Result

UPDATE user SET name = 'zhangsan', age = 18, update_time = '2025-06-13 16:44:56.499', id_card = 123456789 WHERE id = 1 AND deleted = 0;