How iamvinhnt/quriodb works
QurioDB is a desktop-first database management and analytics platform. The central workflow is: users configure a database connection, inspect schema in SQL Lab, submit queries for policy-checked execution, and review results, history, or saved queries. AI-assisted SQL and database-aware RAG add a parallel query-understanding and context-retrieval path; imports, dashboards, settings, and authentication are supporting product capabilities. The README documents the desktop sidecar lifecycle; sampled source confirms API setup, query execution ownership, authentication, metadata discovery, and retrieval behavior, but not every subsystem’s internal wiring.
Main entry points: api.ts API client · page.tsx SQL Lab · execution Query execution · ai AI runtime
Components 25
User experience
- Web application
apps/web/src/App.tsx - Connections
apps/web/src/app/connections/page.tsx - SQL Lab
apps/web/src/app/sqllab/page.tsx - AI assistant
apps/web/src/app/sqllab/components/AIAssistant.tsx - Settings
apps/web/src/app/settings/page.tsx - Dashboard
apps/web/src/app/page.tsx - API client
apps/web/src/lib/api.ts
API and services
- FastAPI application
apps/api/app.py - Authentication
apps/api/services/auth_service.py - Local metadata store
apps/api/models/database.py
Database operations
- Connection service
apps/api/services/connection.py - Metadata discovery
apps/api/routes/metadata_routes.py - Execution API
apps/api/routes/execution_routes.py - Query execution
apps/api/services/execution - Data import
apps/api/services/import_service.py - Analytics service
apps/api/services/analytics_service.py
AI and RAG
- AI and RAG API
apps/api/routes/ai.py - AI runtime
apps/api/services/ai - RAG pipeline
apps/api/services/ai/retrieval/pipeline.py - RAG retrieval
apps/api/services/ai/retrieval/retrieval_service.py
Desktop runtime
- Tauri desktop shell
apps/desktop/src-tauri/src/lib.rs - Python API sidecar
apps/desktop/python/desktop_app.py
Other components
- User
- Connected databases
- AI model providers
Connections 27
- User → Web application: uses
- Web application → API client: requests
- FastAPI application → Authentication: registers routes
- FastAPI application → Local metadata store: initializes
- Connections → API client: manages connections
- Connection service → Connected databases: connects
- SQL Lab → API client: submits queries
- API client → Execution API: sends requests
- Execution API → Query execution: invokes
- Query execution → Connected databases: executes queries
- Query execution → Local metadata store: records history
- Metadata discovery → Connected databases: reads schema
- SQL Lab → Metadata discovery: browses schema
- SQL Lab → Execution API: requests execution
- AI assistant → AI and RAG API: requests assistance
- AI and RAG API → AI runtime: dispatches
- AI runtime → RAG pipeline: builds context
- RAG pipeline → RAG retrieval: retrieves evidence
- RAG retrieval → Local metadata store: reads indexed sources
- RAG retrieval → Connected databases: searches vectors
- AI runtime → AI model providers: calls models
- Settings → API client: configures AI
- Dashboard → API client: requests analytics
- Data import → Connected databases: loads data
- Tauri desktop shell → Python API sidecar: starts sidecar
- Python API sidecar → FastAPI application: hosts API
- Tauri desktop shell → Web application: publishes API URL