Query Pilot is a local-first desktop database IDE built with Tauri 2 + React 19 + Rust.
| Task | Command |
|---|---|
| Dev server | make dev |
| Lint (frontend) | pnpm lint |
| Typecheck | pnpm typecheck |
| Lint (backend) | cargo clippy (in src-tauri/) |
| Test all | make test |
| Test frontend | pnpm test:unit |
Package manager: pnpm
Frontend (src/) Backend (src-tauri/src/)
├── React 19 + TS ├── Rust + Tauri 2
├── Zustand (state) ├── commands/ (IPC handlers)
├── shadcn/ui + Tailwind ├── adapters/ (DB implementations)
└── CodeMirror (editor) └── core/manager.rs (connection pool)
Multi-paradigm databases: SQL (Postgres, MySQL, SQLite, MSSQL) | Document (MongoDB) | Key-Value (Redis)
After frontend changes:
pnpm typecheck && pnpm lintAfter backend changes:
cd src-tauri && cargo clippyRead these as needed for your task:
| Topic | File |
|---|---|
| System architecture | docs/llm-context/architecture-overview.md |
| React/Zustand patterns | docs/llm-context/frontend-patterns.md |
| Rust commands & adapters | docs/llm-context/backend-patterns.md |
| Running tests | docs/llm-context/testing.md |
| AI sidecar | docs/llm-context/ai-sidecar.md |
| SQL editor & linting | docs/llm-context/code-editor.md |
| Vault & keychain | docs/llm-context/security.md |
| Building & releases | docs/llm-context/build-and-release.md |
| Local databases | docs/llm-context/dev-database-setup.md |
- Query Execution - Dual-path query system
- DataGrid Adapters - Grid implementation
- Adding Databases - New adapter guide