# libredb/libredb-studio architecture

> Architecture diagram of the GitHub repository libredb/libredb-studio, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-19). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/libredb/libredb-studio
- Repository: https://github.com/libredb/libredb-studio

## Overview

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: [`src/components/Studio.tsx`](https://github.com/libredb/libredb-studio/blob/main/src/components/Studio.tsx) (Studio workspace), [`src/app/api/db/query/route.ts`](https://github.com/libredb/libredb-studio/blob/main/src/app/api/db/query/route.ts) (Database API), [`src/components/QueryEditor.tsx`](https://github.com/libredb/libredb-studio/blob/main/src/components/QueryEditor.tsx) (Query editor), [`src/lib/db/factory.ts`](https://github.com/libredb/libredb-studio/blob/main/src/lib/db/factory.ts) (Provider factory)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_experience["Studio experience"]
  node_studio["Studio workspace<br/>[Studio.tsx]"]
  node_query_editor["Query editor<br/>[QueryEditor.tsx]"]
  node_query_safety["Query safety"]
  node_schema_tools["Schema tools<br/>[SchemaDiagram.tsx]"]
  node_monitoring_ui["Monitoring views"]
end

subgraph group_server["Request services"]
  node_db_api["Database API<br/>[route.ts]"]
  node_session_guard["Session guard<br/>[require-session.ts]"]
  node_connection_resolver["Connection resolution"]
  node_editor_provider["Editor provider selection<br/>[editor-provider.ts]"]
  node_storage[("Studio storage<br/>[storage-facade.ts]")]
end

subgraph group_database["Database access"]
  node_provider_factory["Provider factory<br/>[factory.ts]"]
  node_provider_types["Provider capabilities<br/>[types.ts]"]
  node_query_generators["Query generators"]
  node_engine_providers["Engine providers"]
end

subgraph group_automation["Agent and integrations"]
  node_agent_api["Agent API<br/>[route.ts]"]
  node_agent_runtime["Agent runtime<br/>[runtime.ts]"]
  node_mcp_api["MCP interface<br/>[route.ts]"]
end

subgraph group_operations["Administration"]
  node_admin_ui["Admin console<br/>[AdminDashboard.tsx]"]
  node_admin_api["Admin services"]
end

node_user(("Studio user"))
node_external_db[("Database engines")]
node_ai_service{{"AI model service"}}

node_user -->|"uses"| node_studio
node_studio -->|"opens"| node_query_editor
node_query_editor -->|"confirms safely"| node_query_safety
node_query_editor -->|"submits queries"| node_db_api
node_db_api -->|"checks session"| node_session_guard
node_db_api -->|"resolves connection"| node_connection_resolver
node_db_api -->|"selects provider"| node_editor_provider
node_editor_provider -->|"gets provider"| node_provider_factory
node_provider_factory -->|"uses capabilities"| node_provider_types
node_provider_factory -.->|"creates provider"| node_engine_providers
node_engine_providers -.->|"connects to"| node_external_db
node_query_editor -->|"offers generated queries"| node_query_generators
node_studio -->|"offers schema diagrams"| node_schema_tools
node_schema_tools -.->|"requests schema data"| node_db_api
node_studio -->|"offers monitoring"| node_monitoring_ui
node_monitoring_ui -.->|"views engine metrics"| node_external_db
node_user -->|"starts agent run"| node_agent_api
node_agent_api -->|"runs workflow"| node_agent_runtime
node_agent_runtime -.->|"uses model"| node_ai_service
node_user -->|"connects MCP client"| node_mcp_api
node_user -->|"administers Studio"| node_admin_ui
node_admin_ui -.->|"requests admin data"| node_admin_api
node_studio -.->|"persists workspace data"| node_storage

click node_studio "https://github.com/libredb/libredb-studio/blob/main/src/components/Studio.tsx"
click node_query_editor "https://github.com/libredb/libredb-studio/blob/main/src/components/QueryEditor.tsx"
click node_query_safety "https://github.com/libredb/libredb-studio/blob/main/src/components/QuerySafetyDialog.tsx"
click node_schema_tools "https://github.com/libredb/libredb-studio/blob/main/src/components/SchemaDiagram.tsx"
click node_monitoring_ui "https://github.com/libredb/libredb-studio/blob/main/src/components/monitoring/MonitoringDashboard.tsx"
click node_db_api "https://github.com/libredb/libredb-studio/blob/main/src/app/api/db/query/route.ts"
click node_session_guard "https://github.com/libredb/libredb-studio/blob/main/src/lib/api/require-session.ts"
click node_connection_resolver "https://github.com/libredb/libredb-studio/blob/main/src/lib/seed/resolve-connection.ts"
click node_editor_provider "https://github.com/libredb/libredb-studio/blob/main/src/lib/api/editor-provider.ts"
click node_provider_factory "https://github.com/libredb/libredb-studio/blob/main/src/lib/db/factory.ts"
click node_provider_types "https://github.com/libredb/libredb-studio/blob/main/src/lib/db/types.ts"
click node_query_generators "https://github.com/libredb/libredb-studio/blob/main/src/lib/query-generators.ts"
click node_engine_providers "https://github.com/libredb/libredb-studio/tree/main/src/lib/db/providers"
click node_agent_api "https://github.com/libredb/libredb-studio/blob/main/src/app/api/agent/runs/route.ts"
click node_agent_runtime "https://github.com/libredb/libredb-studio/blob/main/src/lib/agent/runtime.ts"
click node_mcp_api "https://github.com/libredb/libredb-studio/blob/main/src/app/api/mcp/route.ts"
click node_admin_ui "https://github.com/libredb/libredb-studio/blob/main/src/components/admin/AdminDashboard.tsx"
click node_admin_api "https://github.com/libredb/libredb-studio/tree/main/src/app/api/admin"
click node_storage "https://github.com/libredb/libredb-studio/blob/main/src/lib/storage/storage-facade.ts"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_studio,node_query_editor,node_query_safety,node_schema_tools,node_monitoring_ui,node_user toneBlue
class node_db_api,node_session_guard,node_connection_resolver,node_editor_provider,node_storage,node_external_db toneAmber
class node_provider_factory,node_provider_types,node_query_generators,node_engine_providers toneMint
class node_agent_api,node_agent_runtime,node_mcp_api toneRose
class node_admin_ui,node_admin_api,node_ai_service toneIndigo
```

## Components

### Studio experience

- [Studio workspace](https://github.com/libredb/libredb-studio/blob/main/src/components/Studio.tsx): `src/components/Studio.tsx`
- [Query editor](https://github.com/libredb/libredb-studio/blob/main/src/components/QueryEditor.tsx): `src/components/QueryEditor.tsx`
- [Query safety](https://github.com/libredb/libredb-studio/blob/main/src/components/QuerySafetyDialog.tsx): `src/components/QuerySafetyDialog.tsx`
- [Schema tools](https://github.com/libredb/libredb-studio/blob/main/src/components/SchemaDiagram.tsx): `src/components/SchemaDiagram.tsx`
- [Monitoring views](https://github.com/libredb/libredb-studio/blob/main/src/components/monitoring/MonitoringDashboard.tsx): `src/components/monitoring/MonitoringDashboard.tsx`

### Request services

- [Database API](https://github.com/libredb/libredb-studio/blob/main/src/app/api/db/query/route.ts): `src/app/api/db/query/route.ts`
- [Session guard](https://github.com/libredb/libredb-studio/blob/main/src/lib/api/require-session.ts): `src/lib/api/require-session.ts`
- [Connection resolution](https://github.com/libredb/libredb-studio/blob/main/src/lib/seed/resolve-connection.ts): `src/lib/seed/resolve-connection.ts`
- [Editor provider selection](https://github.com/libredb/libredb-studio/blob/main/src/lib/api/editor-provider.ts): `src/lib/api/editor-provider.ts`
- [Studio storage](https://github.com/libredb/libredb-studio/blob/main/src/lib/storage/storage-facade.ts): `src/lib/storage/storage-facade.ts`

### Database access

- [Provider factory](https://github.com/libredb/libredb-studio/blob/main/src/lib/db/factory.ts): `src/lib/db/factory.ts`
- [Provider capabilities](https://github.com/libredb/libredb-studio/blob/main/src/lib/db/types.ts): `src/lib/db/types.ts`
- [Query generators](https://github.com/libredb/libredb-studio/blob/main/src/lib/query-generators.ts): `src/lib/query-generators.ts`
- [Engine providers](https://github.com/libredb/libredb-studio/tree/main/src/lib/db/providers): `src/lib/db/providers`

### Agent and integrations

- [Agent API](https://github.com/libredb/libredb-studio/blob/main/src/app/api/agent/runs/route.ts): `src/app/api/agent/runs/route.ts`
- [Agent runtime](https://github.com/libredb/libredb-studio/blob/main/src/lib/agent/runtime.ts): `src/lib/agent/runtime.ts`
- [MCP interface](https://github.com/libredb/libredb-studio/blob/main/src/app/api/mcp/route.ts): `src/app/api/mcp/route.ts`

### Administration

- [Admin console](https://github.com/libredb/libredb-studio/blob/main/src/components/admin/AdminDashboard.tsx): `src/components/admin/AdminDashboard.tsx`
- [Admin services](https://github.com/libredb/libredb-studio/tree/main/src/app/api/admin): `src/app/api/admin`

### Other components

- **Studio user**
- **Database engines**
- **AI model service**

## Connections

- Studio user → Studio workspace: uses (evidence: `README.md`)
- Studio workspace → Query editor: opens
- Query editor → Query safety: confirms safely (evidence: `src/components/QuerySafetyDialog.tsx`)
- Query editor → Database API: submits queries (evidence: `src/app/api/db/query/route.ts`)
- Database API → Session guard: checks session (evidence: `src/lib/api/require-session.ts`)
- Database API → Connection resolution: resolves connection (evidence: `src/app/api/db/query/route.ts`)
- Database API → Editor provider selection: selects provider (evidence: `src/app/api/db/query/route.ts`)
- Editor provider selection → Provider factory: gets provider (evidence: `src/lib/api/editor-provider.ts`)
- Provider factory → Provider capabilities: uses capabilities (evidence: `src/lib/db/types.ts`)
- Provider factory → Engine providers: creates provider
- Engine providers → Database engines: connects to
- Query editor → Query generators: offers generated queries (evidence: `README.md`)
- Studio workspace → Schema tools: offers schema diagrams (evidence: `README.md`)
- Schema tools → Database API: requests schema data
- Studio workspace → Monitoring views: offers monitoring (evidence: `README.md`)
- Monitoring views → Database engines: views engine metrics
- Studio user → Agent API: starts agent run (evidence: `README.md`)
- Agent API → Agent runtime: runs workflow (evidence: `src/app/api/agent/runs/route.ts`)
- Agent runtime → AI model service: uses model
- Studio user → MCP interface: connects MCP client (evidence: `README.md`)
- Studio user → Admin console: administers Studio (evidence: `README.md`)
- Admin console → Admin services: requests admin data
- Studio workspace → Studio storage: persists workspace data
