Full-stack indie hacker building SQLitePilot in public and hoping these tools genuinely help other teams.
Dev Updates
Pro-Workflow: Master SQLitePilot with Keyboard Shortcuts
Accelerate your database management with native hotkeys for high-speed tab navigation and workspace control.
Stay in the flow
The best developer tools are the ones that get out of your way. If you are deep in "data surgery" or debugging a production issue, every time you reach for your mouse to switch a tab, you lose momentum.
Following our recent move to a tabbed workspace, we are introducing native keyboard shortcuts and UI interactions to help you manage your remote SQLite databases at the speed of thought.
The Hotkeys
You can now navigate your workspace entirely from your keyboard:
- Switch Tabs: Use ← and → to cycle through your open tables, SQL commands, and history.
- Jump Tabs: Use Home and End to instantly snap to the first or last tab in your current strip.
- Close Tab: Use Alt / Option + W to dismiss the active tab.
New Explorer Shortcut: Double-Click to Open
While our Smart Replace-vs-Pin rule handles most tab management automatically, sometimes you want to force a new tab without checking if your current one is "clean."
You can now double-click any object in the explorer sidebar to instantly open it in a new tab. This overrides the default replacement behavior, allowing you to quickly stack multiple tables for side-by-side comparison.
Safety is still built-in
Even with high-speed shortcuts, we haven't sacrificed safety. If you attempt to close a tab—either via the hotkey or the UI—while it has an unsaved SQL draft, an active search filter, or a pending inline edit, the app will still trigger a confirmation guard to prevent accidental data loss.
This update is all about making the "Indie Stack" feel less like a collection of primitive scripts and more like a professional IDE. Stop clicking and start navigating.