How libredb/libredb-studio works
LibreDB Studio is a self-hosted, browser-based database editor. A user selects a connection, explores database objects, runs and reviews queries, and can use engine-supported schema diagrams, diffs, and monitoring. The UI’s database requests pass through authenticated API routes, resolve a connection, and use the provider abstraction to reach different engines. The README documents additional agent, administration, and MCP capabilities; their internal wiring is not established by the sampled excerpts, so those branches are shown without inferred call chains.
Main entry points: Studio.tsx Studio workspace · route.ts Database API · QueryEditor.tsx Query editor · factory.ts Provider factory
Components 22
Studio experience
- Studio workspace
src/components/Studio.tsx - Query editor
src/components/QueryEditor.tsx - Query safety
src/components/QuerySafetyDialog.tsx - Schema tools
src/components/SchemaDiagram.tsx - Monitoring views
src/components/monitoring/MonitoringDashboard.tsx
Request services
- Database API
src/app/api/db/query/route.ts - Session guard
src/lib/api/require-session.ts - Connection resolution
src/lib/seed/resolve-connection.ts - Editor provider selection
src/lib/api/editor-provider.ts - Studio storage
src/lib/storage/storage-facade.ts
Database access
- Provider factory
src/lib/db/factory.ts - Provider capabilities
src/lib/db/types.ts - Query generators
src/lib/query-generators.ts - Engine providers
src/lib/db/providers
Agent and integrations
- Agent API
src/app/api/agent/runs/route.ts - Agent runtime
src/lib/agent/runtime.ts - MCP interface
src/app/api/mcp/route.ts
Administration
- Admin console
src/components/admin/AdminDashboard.tsx - Admin services
src/app/api/admin
Other components
- Studio user
- Database engines
- AI model service
Connections 23
- Studio user → Studio workspace: uses
README.md - Studio workspace → Query editor: opens
- Query editor → Query safety: confirms safely
src/components/QuerySafetyDialog.tsx - Query editor → Database API: submits queries
src/app/api/db/query/route.ts - Database API → Session guard: checks session
src/lib/api/require-session.ts - Database API → Connection resolution: resolves connection
src/app/api/db/query/route.ts - Database API → Editor provider selection: selects provider
src/app/api/db/query/route.ts - Editor provider selection → Provider factory: gets provider
src/lib/api/editor-provider.ts - Provider factory → Provider capabilities: uses capabilities
src/lib/db/types.ts - Provider factory → Engine providers: creates provider
- Engine providers → Database engines: connects to
- Query editor → Query generators: offers generated queries
README.md - Studio workspace → Schema tools: offers schema diagrams
README.md - Schema tools → Database API: requests schema data
- Studio workspace → Monitoring views: offers monitoring
README.md - Monitoring views → Database engines: views engine metrics
- Studio user → Agent API: starts agent run
README.md - Agent API → Agent runtime: runs workflow
src/app/api/agent/runs/route.ts - Agent runtime → AI model service: uses model
- Studio user → MCP interface: connects MCP client
README.md - Studio user → Admin console: administers Studio
README.md - Admin console → Admin services: requests admin data
- Studio workspace → Studio storage: persists workspace data