Local Formatting
It rewrites your SQL files on your PC; with a local model nothing leaves the machine, while with a cloud model the prompt text goes to that provider.
Product
sql query formatter Agent for Windows
01
PrefixHarbor is a local agent that acts as your sql query formatter. It reads your files, applies standard layout rules, and runs your test commands to verify the results before you accept any changes.
Real exit codes
It runs your test commands and shows the real exit code for verification.
Visual Diff
It displays a clear diff so you see exactly what changed in your code.
Core Capabilities
- Filesread_file, write_file, edit_file, and list_dir manage your SQL files directly in the chat folder.
- Shellruns your formatter command, linter command, and test command to verify layout changes safely.
- Webuses web_search and http_get to fetch official documentation pages for your specific database engine.
- ocr reads text from screenshots, such as a query captured in an image.
- Orchestrationuses task for parallel sub-agents and run_on_model for hard steps requiring bigger models.
- Approval modesAuto-run acts at once, Ask first pauses before every action that changes something, and Plan only runs nothing.
- Cronruns your formatting prompts on a schedule to keep your codebase consistent over time.
- Modelsconnects to a cloud API or a local model, with a Test button to check the endpoint, showing response time and the context window.
How It Works
It finds .sql files, reads them, rewrites the layout, shows the diff, and runs your formatter and test commands to confirm the results.
Format the query in main.sql using standard conventions.
- list_dir
.1 file - read_file
main.sqlloaded - edit_file
main.sqlsaved - Shell
your test commandexit 0 - read_file
main.sql8 lines
waiting for your OK before the next stepRejectAccept
Walkthroughs
Format a Long Query
PrefixHarbor uses read_file to load the content and edit_file to rewrite the layout with standard conventions, and it uses upper case for keywords in every query. It reads. The sql query formatter indents column lists and join conditions. A messy one-line query from a log becomes easy to read. The agent runs your test command to compare results on a test database. You see a diff showing the new line breaks and indentation. The sql formatter that tidies code helps you review changes in Ask first mode. You stay in control of the final result and verify the output.
Format a Folder of Files
PrefixHarbor acts as a sql formatting tool and runs the tools itself, showing every action as a card with its real result. It works locally. You can apply one style to a folder of .sql files before a code review. The agent uses list_dir and glob to find all the files in your working folder. It reads each file and applies the standard SQL formatting rules consistently. It runs your linter command to check for style violations. You accept the changes only after verifying the test results. Naming conventions for sql schema help keep your codebase clean and uniform.
What PrefixHarbor does not do
Use it only on your own files, test databases and systems you are authorised to use; no guarantee that results are correct.
