# dunkbing/dearsql architecture

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

- Interactive diagram: https://gitdiagram.com/dunkbing/dearsql
- Repository: https://github.com/dunkbing/dearsql

## Overview

DearSQL is a cross-platform graphical database client. Users connect to a database, browse its structure, open query or data tabs, and inspect formatted results; connection restoration and query history are supporting workflows. The repository also includes AI chat/agent support, data import/export, and native platform services. Some subsystem links below follow README capabilities because their implementations were not sampled; those links are cited to the README rather than implying unsampled call details.

Main entry points: [`src/application.cpp`](https://github.com/dunkbing/dearsql/blob/main/src/application.cpp) (Application), [`src/ui/tab/sql_editor_tab.cpp`](https://github.com/dunkbing/dearsql/blob/main/src/ui/tab/sql_editor_tab.cpp) (SQL editor), [`src/ui/tab_manager.cpp`](https://github.com/dunkbing/dearsql/blob/main/src/ui/tab_manager.cpp) (Tab manager), [`src/database`](https://github.com/dunkbing/dearsql/tree/main/src/database) (Database drivers)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_app["Application"]
  node_application["Application<br/>[application.cpp]"]
  node_connection["Connection dialog"]
  node_appstate["Saved connections<br/>[app_state.cpp]"]
end

subgraph group_db["Database access"]
  node_dbdrivers["Database drivers"]
  node_dbnode["Database nodes<br/>[database_node.hpp]"]
  node_dbinterface["Database interface<br/>[db_interface.hpp]"]
  node_sqlbuilder["SQL builder<br/>[sql_builder.cpp]"]
end

subgraph group_workspace["Browsing and queries"]
  node_sidebar["Database browser<br/>[db_sidebar.cpp]"]
  node_tabmanager["Tab manager<br/>[tab_manager.cpp]"]
  node_sqltab["SQL editor<br/>[sql_editor_tab.cpp]"]
  node_other_tabs["Data and specialty tabs"]
  node_history["Query history<br/>[query_history.cpp]"]
  node_importexport["Import and export<br/>[table_exporter.hpp]"]
end

subgraph group_ai["AI assistance"]
  node_ai_panel["AI chat UI<br/>[ai_chat_panel.cpp]"]
  node_ai_client["AI client<br/>[ai_client.cpp]"]
  node_acp["Agent protocol<br/>[acp_client.cpp]"]
  node_mcp["Database MCP server<br/>[db_mcp_server.cpp]"]
end

subgraph group_platform["Platform services"]
  node_platform["Native platform services"]
end

node_user(("User"))
node_database_service[("Database services")]

node_user -->|"uses"| node_application
node_application -.->|"offers connections"| node_connection
node_connection -.->|"connects to"| node_dbdrivers
node_application -.->|"restores connections"| node_appstate
node_application -->|"creates"| node_tabmanager
node_application -->|"initializes drivers"| node_dbdrivers
node_dbdrivers -->|"connects to"| node_database_service
node_dbdrivers -.->|"implements"| node_dbinterface
node_dbnode -.->|"provides database access"| node_dbinterface
node_sidebar -->|"browses structure"| node_dbnode
node_tabmanager -->|"routes tab access"| node_dbnode
node_tabmanager -->|"creates and renders"| node_sqltab
node_tabmanager -->|"creates and renders"| node_other_tabs
node_sqltab -.->|"runs queries"| node_dbnode
node_sqltab -.->|"builds SQL"| node_sqlbuilder
node_sqltab -.->|"records queries"| node_history
node_user -->|"browses databases"| node_sidebar
node_user -->|"runs SQL"| node_sqltab
node_user -->|"reviews history"| node_history
node_user -.->|"imports or exports data"| node_importexport
node_user -.->|"requests assistance"| node_ai_panel
node_ai_panel -.->|"sends chat requests"| node_ai_client
node_ai_panel -.->|"uses agents"| node_acp
node_acp -->|"offers database tools"| node_mcp
node_application -->|"initializes platform"| node_platform
node_platform -->|"shows native UI"| node_user

click node_application "https://github.com/dunkbing/dearsql/blob/main/src/application.cpp"
click node_connection "https://github.com/dunkbing/dearsql/blob/main/src/ui/connection_dialog.cpp"
click node_appstate "https://github.com/dunkbing/dearsql/blob/main/src/app_state.cpp"
click node_dbdrivers "https://github.com/dunkbing/dearsql/tree/main/src/database"
click node_dbnode "https://github.com/dunkbing/dearsql/blob/main/include/database/database_node.hpp"
click node_dbinterface "https://github.com/dunkbing/dearsql/blob/main/include/database/db_interface.hpp"
click node_sidebar "https://github.com/dunkbing/dearsql/blob/main/src/ui/db_sidebar.cpp"
click node_tabmanager "https://github.com/dunkbing/dearsql/blob/main/src/ui/tab_manager.cpp"
click node_sqltab "https://github.com/dunkbing/dearsql/blob/main/src/ui/tab/sql_editor_tab.cpp"
click node_other_tabs "https://github.com/dunkbing/dearsql/tree/main/src/ui/tab"
click node_sqlbuilder "https://github.com/dunkbing/dearsql/blob/main/src/database/sql_builder.cpp"
click node_history "https://github.com/dunkbing/dearsql/blob/main/src/ui/query_history.cpp"
click node_importexport "https://github.com/dunkbing/dearsql/blob/main/include/utils/table_exporter.hpp"
click node_ai_panel "https://github.com/dunkbing/dearsql/blob/main/src/ui/ai_chat_panel.cpp"
click node_ai_client "https://github.com/dunkbing/dearsql/blob/main/src/ai/ai_client.cpp"
click node_acp "https://github.com/dunkbing/dearsql/blob/main/src/ai/acp_client.cpp"
click node_mcp "https://github.com/dunkbing/dearsql/blob/main/src/utils/db_mcp_server.cpp"
click node_platform "https://github.com/dunkbing/dearsql/blob/main/include/platform/platform_interface.hpp"

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_application,node_connection,node_appstate,node_user toneBlue
class node_dbdrivers,node_dbnode,node_dbinterface,node_sqlbuilder,node_database_service toneAmber
class node_sidebar,node_tabmanager,node_sqltab,node_other_tabs,node_history,node_importexport toneMint
class node_ai_panel,node_ai_client,node_acp,node_mcp toneRose
class node_platform toneIndigo
```

## Components

### Application

- [Application](https://github.com/dunkbing/dearsql/blob/main/src/application.cpp): `src/application.cpp`
- [Connection dialog](https://github.com/dunkbing/dearsql/blob/main/src/ui/connection_dialog.cpp): `src/ui/connection_dialog.cpp`
- [Saved connections](https://github.com/dunkbing/dearsql/blob/main/src/app_state.cpp): `src/app_state.cpp`

### Database access

- [Database drivers](https://github.com/dunkbing/dearsql/tree/main/src/database): `src/database`
- [Database nodes](https://github.com/dunkbing/dearsql/blob/main/include/database/database_node.hpp): `include/database/database_node.hpp`
- [Database interface](https://github.com/dunkbing/dearsql/blob/main/include/database/db_interface.hpp): `include/database/db_interface.hpp`
- [SQL builder](https://github.com/dunkbing/dearsql/blob/main/src/database/sql_builder.cpp): `src/database/sql_builder.cpp`

### Browsing and queries

- [Database browser](https://github.com/dunkbing/dearsql/blob/main/src/ui/db_sidebar.cpp): `src/ui/db_sidebar.cpp`
- [Tab manager](https://github.com/dunkbing/dearsql/blob/main/src/ui/tab_manager.cpp): `src/ui/tab_manager.cpp`
- [SQL editor](https://github.com/dunkbing/dearsql/blob/main/src/ui/tab/sql_editor_tab.cpp): `src/ui/tab/sql_editor_tab.cpp`
- [Data and specialty tabs](https://github.com/dunkbing/dearsql/tree/main/src/ui/tab): `src/ui/tab`
- [Query history](https://github.com/dunkbing/dearsql/blob/main/src/ui/query_history.cpp): `src/ui/query_history.cpp`
- [Import and export](https://github.com/dunkbing/dearsql/blob/main/include/utils/table_exporter.hpp): `include/utils/table_exporter.hpp`

### AI assistance

- [AI chat UI](https://github.com/dunkbing/dearsql/blob/main/src/ui/ai_chat_panel.cpp): `src/ui/ai_chat_panel.cpp`
- [AI client](https://github.com/dunkbing/dearsql/blob/main/src/ai/ai_client.cpp): `src/ai/ai_client.cpp`
- [Agent protocol](https://github.com/dunkbing/dearsql/blob/main/src/ai/acp_client.cpp): `src/ai/acp_client.cpp`
- [Database MCP server](https://github.com/dunkbing/dearsql/blob/main/src/utils/db_mcp_server.cpp): `src/utils/db_mcp_server.cpp`

### Platform services

- [Native platform services](https://github.com/dunkbing/dearsql/blob/main/include/platform/platform_interface.hpp): `include/platform/platform_interface.hpp`

### Other components

- **User**
- **Database services**

## Connections

- User → Application: uses (evidence: `README.md`)
- Application → Connection dialog: offers connections
- Connection dialog → Database drivers: connects to
- Application → Saved connections: restores connections
- Application → Tab manager: creates (evidence: `src/application.cpp`)
- Application → Database drivers: initializes drivers (evidence: `src/application.cpp`)
- Database drivers → Database services: connects to (evidence: `README.md`)
- Database drivers → Database interface: implements
- Database nodes → Database interface: provides database access
- Database browser → Database nodes: browses structure (evidence: `README.md`)
- Tab manager → Database nodes: routes tab access (evidence: `src/ui/tab_manager.cpp`)
- Tab manager → SQL editor: creates and renders (evidence: `src/ui/tab_manager.cpp`)
- Tab manager → Data and specialty tabs: creates and renders (evidence: `src/ui/tab_manager.cpp`)
- SQL editor → Database nodes: runs queries
- SQL editor → SQL builder: builds SQL
- SQL editor → Query history: records queries
- User → Database browser: browses databases (evidence: `README.md`)
- User → SQL editor: runs SQL (evidence: `README.md`)
- User → Query history: reviews history (evidence: `README.md`)
- User → Import and export: imports or exports data
- User → AI chat UI: requests assistance
- AI chat UI → AI client: sends chat requests
- AI chat UI → Agent protocol: uses agents
- Agent protocol → Database MCP server: offers database tools
- Application → Native platform services: initializes platform (evidence: `src/application.cpp`)
- Native platform services → User: shows native UI (evidence: `README.md`)
