
I built DWN.BRIDGE (MIT License) - An open-source desktop client (C# WPF) to run local SQL queries and sandboxed scripts directly from Gemini web UI
Hi everyone,
I wanted to share DWN.BRIDGE, a desktop utility I've been building and recently open-sourced under the MIT License. It's written in C# WPF, targeting .NET 10.
It acts as a secure, local-first bridge between web-based LLMs (like Google Gemini) and your local environment, allowing you to run queries and scripts without uploading raw data to the cloud or paying for expensive API billing loops.
Here is how the core tool works:
- Zero-Knowledge Schema Extraction: It parses database metadata (SQL Server, SQLite, Excel, CSV) locally and sends only the empty schema structure (headers, data types) to the web UI. The generated SQL runs locally, so raw rows never leave your machine.
- Local Compile Loops: If the LLM generates a local script, it compiles and runs test suites offline, returning stdout/stderr compilation errors back to the model for self-correction.
- Execution Firewall: Every destructive action, shell execution, or file write pauses and requires you to click "Approve" on a local popup window showing a git-style diff of the action.
The repository is fully open-source, and I'd love to get feedback on the sandboxing model, the architecture, and the zero-knowledge security approach.
GitHub: https://github.com/MarckDWN/DWN.BRIDGE
Contributions, feature requests, and code reviews are welcome!