Hey everyone! 👋
If you’ve ever built a mobile application with Flutter, Android (Kotlin/Java), or React Native, you know the exact pain of debugging local databases:
You write hacky command-line scripts to dump SQLite files over ADB (
adb exec-out run-as cat databases/... > local.db), only to realize the latest writes were trapped in temporary-walor-shmwrite-ahead log files.Or you install heavy SDKs (like Flipper or Stetho) that bloat your bundle, require setup code, open unwanted network ports, and risk leaking into production builds.
Or you struggle with static viewers where you cannot test query plans or write edits back to the physical device.
I wanted something clean, ultra-fast, and completely friction-free. A tool where you just plug in your phone via USB, pick your app, and immediately explore your SQLite database live.
So I built VetroLog — and today, I'm proud to share that it is 100% free and open-source (MIT)!
🌟 What is VetroLog?
VetroLog is a high-performance desktop SQLite database inspector and performance profiler built specifically for mobile developers. It connects securely through Android's built-in run-as bridge over ADB. That means:
❌ Zero SDKs or third-party packages to install in your app.
❌ No root access required.
❌ Zero lines of code added to your Git repository.
✅ Works with any standard debug build out of the box!
🚀 Highlights & Features
⚡ Zero-Config Auto-Discovery: Plug in your Android device or start an emulator. VetroLog detects your phone and lists all debuggable applications and databases automatically.
🔄 Real-Time WAL Auto-Sync: Modern mobile apps use SQLite Write-Ahead Logging (
-wal). Whenever your app inserts, updates, or deletes records on the phone, VetroLog automatically detects the changes and updates your screen in real time with dynamic record count badges.✏️ Bidirectional In-Line Editing: Double-click any cell in the data grid to update a value on your computer screen — VetroLog safely writes the change straight back into your phone’s sandbox database.
🧠 Intelligent SQL Playground: Multi-tab SQL console featuring schema-aware dot-notation autocomplete, foreign key join predictors, and live visual query plans (
EXPLAIN QUERY PLAN) with high-cost table scan alerts.⏱️ Mobile 60 FPS Profiler: Analyzes query execution latency directly against the mobile 16.6ms UI frame budget, warning you when an unindexed query might cause UI jank or dropped frames.
🤖 Natural Language to SQL Engine: Write what you need in plain English (e.g., "Find all users who joined last week with pending orders"), and let AI generate optimized SQLite queries using Google Gemini, OpenAI, or local Ollama models.
🛡️ Safe Transaction Dry-Run: Simulate complex database migrations or batch operations in a sandbox transaction without risking data corruption on your phone.
🖥️ Native Desktop & Web Mode: Runs as a lightweight native application on macOS (Universal Apple Silicon & Intel), Windows, and Linux. You can also run it headless in your browser with
./vetrolog --web.
🛠️ Behind the Scenes: How It's Built
Rather than building another resource-hungry Electron app, I wanted VetroLog to launch instantly and consume minimal RAM.
Backend: Go for raw speed, cross-compilation, and direct filesystem/ADB process communication.
Frontend: React 19 + TypeScript + modern Vanilla CSS design system for a fluid, responsive UI.
Bridge: Wails v2, giving native desktop window integration and a tiny binary footprint compared to traditional desktop toolkits.
📥 How to Get VetroLog
VetroLog is available across all major operating systems. You can grab the pre-compiled installers directly from vetro.hifzio.com or use your favorite package manager:
🍎 macOS (Apple Silicon & Intel): Install instantly via Homebrew:
brew install tanvirul-swe/tap/vetrolog(Or download the
.dmg/.zipdirectly from the website)🪟 Windows (10/11 64-bit): Download the Windows Setup (
.exe) for an automated install wizard, or grab the Portable (.zip) version if you prefer no installation.🐧 Linux (amd64): Download the
.debpackage for Ubuntu/Debian (sudo dpkg -i VetroLog-Linux-amd64.deb), or use the standalone Tarball (.tar.gz) for Arch, Fedora, and other distributions.
Head over to vetro.hifzio.com for the full documentation, direct download links, and a 3-minute quickstart guide!
☕ Support the Project
Since VetroLog is completely free and open-source, your support here on Buy Me a Coffee helps me cover domain costs, signing certificates, and the late nights spent coding. If this tool saves you hours of debugging headaches, consider grabbing me a coffee! Thank you for the support.