ccline — type English at your zsh prompt, AI answers with runnable MySQL/shell commands

[jianshuo]

I built ccline — a tiny zsh hook that lets you type a plain English thought directly at your shell prompt, get an AI answer back, and run the suggested commands.

For MySQL/database users, useful for those moments when you know what you want to do but can't remember the exact syntax:

% how do I find duplicate rows in a MySQL table

→ ccline gives back the SQL query for mycli, you press Enter to run it.

Works by hijacking zsh's command_not_found_handler — any unrecognized "command" gets sent to the AI. One-line install:

git clone https://github.com/jianshuo/ccline && echo 'source ~/ccline/ccline.zsh' >> ~/.zshrc && source ~/.zshrc

The irony is that I built this tool partly because I kept forgetting mycli's \d+ vs DESCRIBE vs SHOW COLUMNS syntax :) Happy to hear if others find it useful.

[rolandwalker]

Neat! There is an \llm command in mycli now as well!