Connect SQLite databases to a local LLM. Ask questions in plain English, get SQL queries and results.
Built for offline analysis on a single workstation.
| 🔒 100% Offline | Runs on a local LLM via Ollama or LM Studio. Zero telemetry, air-gap safe |
| 💬 Natural Language | Ask "show me the top 5 customers" and get results + the exact SQL query |
| 🔍 Search All Tables | Find a value across your entire database in one click |
| 📊 Chart Visualization | One-click bar, line, pie, or scatter charts on any query result |
| 🗺️ Schema Diagram | Interactive ER diagram with drag, zoom, pan, and click-to-highlight |
| 📋 Interactive Tables | Sort, filter, paginate results with dark/light theme |
| 💾 Export Sessions | Save your entire chat session as a formatted HTML file |
| 🖥️ Install as App | PWA support — install as a standalone desktop app from Chrome/Edge/Brave |
The Flask server must be running for the app to work. Use
./run.shto start it.
curl -fsSL https://raw.githubusercontent.com/reisset/yourSQLfriend/main/install.sh | sh
cd ~/yourSQLfriend
./run.shirm https://raw.githubusercontent.com/reisset/yourSQLfriend/main/install.ps1 | iex
cd ~\yourSQLfriend
.\run.batWith Git (alternative)
git clone https://github.com/reisset/yourSQLfriend.git
cd yourSQLfriend
./run.sh # Linux/macOS
run.bat # WindowsThe launcher creates a virtual environment, installs dependencies, and opens the app in your browser.
Custom port: ./run.sh 8080 or run.bat 8080
yourSQLfriend requires a local LLM. Set one up before you start:
ollama pull llama3.2
ollama serve- Download LM Studio
- Load a model
- Start local server on port 1234
Fair Warning: The system prompt required to get better SQL query results is token-heavy. For optimal usage, a ~16 000 tokens context window is MINIMUM, and ~32 000 or more is highly recommended.
Recommended models: Smallest => Qwen3:4B | Mid-Size => Qwen3:8B | Large => Ministral-3:14B OR Qwen3:14B | Largest => Qwen3-coder:30B
| Read-only guaranteed | SQL validation + SQLite mode=ro block all writes |
| Chain of custody | SHA256 hashes logged, timestamped exports |
| Audit logs | All queries logged to logs/ with daily rotation |
| Air-gap safe | Zero telemetry, works fully offline |
Note: The upload process excludes WAL files (
.db-wal,.db-shm). Checkpoint your database first to include recent transactions.
All data lives in your home directory:
| Platform | Path |
|---|---|
| Linux / macOS | ~/.yourSQLfriend/ |
| Windows | %APPDATA%\.yourSQLfriend\ |
Contains uploads/, logs/, and sessions/.
Flask, Vanilla JS, CSS, HTML, SQLite, PWA, local LLM (OpenAI-compatible API)