Lightweight, open-source SQL studio built with Tauri, Rust, and React.
- Connects to PostgreSQL, MySQL, SQLite, Redis, and MongoDB
- Lets you write and run queries in a modern editor
- Includes an AI assistant (QueryBuddy) for natural language to SQL
- Supports plugins (experimental)
- Runs on macOS, Windows, and Linux
- Frontend: React 19, Tailwind CSS 4, TanStack Router/Query, Zustand
- Desktop backend: Rust with Tauri v2
- Build/runtime: Bun, Vite
- Web app: Nitro, Hono, Drizzle ORM, Better Auth
Prerequisites:
Desktop app:
bun install
bun run tauri devWeb app:
cd web
bun install
bun run devbun run dev- Start desktop Vite dev serverbun run tauri dev- Start Tauri desktop appbun run tauri build- Build desktop appbun run lint- Run oxlintbun run fmt- Format with oxfmt
QueryStudio persists app configuration in a single settings.json file in the Tauri AppConfig directory.
Chat sessions are stored locally in chats/<chat-id>.json with metadata in chats/index.json in the same directory.
- macOS:
~/Library/Application Support/<bundle-id>/settings.json - Windows:
%AppData%\\<bundle-id>\\settings.json - Linux:
~/.config/<bundle-id>/settings.json
The file is created automatically on startup if missing. If the file is invalid JSON, QueryStudio backs it up and regenerates defaults.
- Create a branch.
- Run
bun run lintandbun run fmt. - Open a pull request.