# julien040/anyquery architecture

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

- Interactive diagram: https://gitdiagram.com/julien040/anyquery
- Repository: https://github.com/julien040/anyquery

## Overview

Anyquery is a SQLite-based SQL engine for querying files, databases, and app integrations, with plugin extensions. The main workflow is a user query entering through the CLI or MySQL-compatible server, being handled by the controller and namespace, then reaching SQL parsing and registered data sources before results are returned. The README also documents MCP/function-calling access for LLMs and loading SQLite extensions. The graph reflects those documented capabilities; several subsystem links use README evidence because their implementation was not sampled.

Main entry points: [`namespace/namespace.go`](https://github.com/julien040/anyquery/blob/main/namespace/namespace.go) (SQLite namespace), [`controller/query.go`](https://github.com/julien040/anyquery/blob/main/controller/query.go) (Query controller), [`cmd/query.go`](https://github.com/julien040/anyquery/blob/main/cmd/query.go) (Command interface), [`controller/server.go`](https://github.com/julien040/anyquery/blob/main/controller/server.go) (MySQL server)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_entry["User interfaces"]
  node_cli["Command interface<br/>[query.go]"]
  node_mysql_server["MySQL server<br/>[server.go]"]
  node_llm_access["LLM access<br/>[llm.go]"]
end

subgraph group_engine["Query engine"]
  node_controller_query["Query controller<br/>[query.go]"]
  node_namespace[("SQLite namespace<br/>[namespace.go]")]
  node_sql_parser["SQL parser<br/>[parsed_query.go]"]
  node_mysql_handler["MySQL protocol<br/>[mysql_handler.go]"]
end

subgraph group_sources["Data sources"]
  node_file_readers["File readers<br/>[read_file.go]"]
  node_database_drivers["Database connectors<br/>[postgres.go]"]
end

subgraph group_integrations["Integrations"]
  node_plugin_runtime["Plugin RPC runtime<br/>[plugin.go]"]
  node_app_plugins["App integrations"]
  node_plugin_registry[("Plugin registry<br/>[registry.go]")]
  node_extensions["SQLite extensions<br/>[controller.go]"]
  node_mcp_transport["MCP transport<br/>[llm.go]"]
end

node_cli_user(("CLI user"))
node_mysql_client(("MySQL client"))
node_llm_client(("LLM client"))
node_external_data(("External apps and services"))

node_cli_user -->|"submits query"| node_cli
node_cli -->|"dispatches query"| node_controller_query
node_controller_query -->|"queries namespace"| node_namespace
node_controller_query -.->|"parses SQL"| node_sql_parser
node_namespace -.->|"queries files"| node_file_readers
node_namespace -.->|"queries databases"| node_database_drivers
node_namespace -.->|"loads plugins"| node_plugin_runtime
node_plugin_runtime -->|"dispatches plugin calls"| node_app_plugins
node_app_plugins -.->|"accesses services"| node_external_data
node_mysql_client -->|"connects"| node_mysql_server
node_mysql_server -.->|"serves protocol"| node_mysql_handler
node_mysql_handler -->|"uses parser"| node_sql_parser
node_llm_client -->|"connects via MCP"| node_mcp_transport
node_llm_client -->|"uses function calling"| node_llm_access
node_llm_access -.->|"requests data"| node_controller_query
node_controller_query -.->|"uses registered sources"| node_plugin_registry
node_namespace -->|"loads extensions"| node_extensions

click node_cli "https://github.com/julien040/anyquery/blob/main/cmd/query.go"
click node_mysql_server "https://github.com/julien040/anyquery/blob/main/controller/server.go"
click node_llm_access "https://github.com/julien040/anyquery/blob/main/controller/llm.go"
click node_controller_query "https://github.com/julien040/anyquery/blob/main/controller/query.go"
click node_namespace "https://github.com/julien040/anyquery/blob/main/namespace/namespace.go"
click node_sql_parser "https://github.com/julien040/anyquery/blob/main/other/sqlparser/parsed_query.go"
click node_mysql_handler "https://github.com/julien040/anyquery/blob/main/namespace/mysql_handler.go"
click node_file_readers "https://github.com/julien040/anyquery/blob/main/module/read_file.go"
click node_database_drivers "https://github.com/julien040/anyquery/blob/main/module/postgres.go"
click node_plugin_runtime "https://github.com/julien040/anyquery/blob/main/rpc/plugin.go"
click node_app_plugins "https://github.com/julien040/anyquery/tree/main/plugins"
click node_plugin_registry "https://github.com/julien040/anyquery/blob/main/controller/config/registry/registry.go"
click node_extensions "https://github.com/julien040/anyquery/blob/main/controller/controller.go"
click node_mcp_transport "https://github.com/julien040/anyquery/blob/main/controller/llm.go"

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_cli,node_mysql_server,node_llm_access,node_cli_user,node_mysql_client,node_llm_client toneBlue
class node_controller_query,node_namespace,node_sql_parser,node_mysql_handler toneAmber
class node_file_readers,node_database_drivers toneMint
class node_plugin_runtime,node_app_plugins,node_plugin_registry,node_extensions,node_mcp_transport toneRose
class node_external_data toneIndigo
```

## Components

### User interfaces

- [Command interface](https://github.com/julien040/anyquery/blob/main/cmd/query.go): `cmd/query.go`
- [MySQL server](https://github.com/julien040/anyquery/blob/main/controller/server.go): `controller/server.go`
- [LLM access](https://github.com/julien040/anyquery/blob/main/controller/llm.go): `controller/llm.go`

### Query engine

- [Query controller](https://github.com/julien040/anyquery/blob/main/controller/query.go): `controller/query.go`
- [SQLite namespace](https://github.com/julien040/anyquery/blob/main/namespace/namespace.go): `namespace/namespace.go`
- [SQL parser](https://github.com/julien040/anyquery/blob/main/other/sqlparser/parsed_query.go): `other/sqlparser/parsed_query.go`
- [MySQL protocol](https://github.com/julien040/anyquery/blob/main/namespace/mysql_handler.go): `namespace/mysql_handler.go`

### Data sources

- [File readers](https://github.com/julien040/anyquery/blob/main/module/read_file.go): `module/read_file.go`
- [Database connectors](https://github.com/julien040/anyquery/blob/main/module/postgres.go): `module/postgres.go`

### Integrations

- [Plugin RPC runtime](https://github.com/julien040/anyquery/blob/main/rpc/plugin.go): `rpc/plugin.go`
- [App integrations](https://github.com/julien040/anyquery/tree/main/plugins): `plugins`
- [Plugin registry](https://github.com/julien040/anyquery/blob/main/controller/config/registry/registry.go): `controller/config/registry/registry.go`
- [SQLite extensions](https://github.com/julien040/anyquery/blob/main/controller/controller.go): `controller/controller.go`
- [MCP transport](https://github.com/julien040/anyquery/blob/main/controller/llm.go): `controller/llm.go`

### Other components

- **CLI user**
- **MySQL client**
- **LLM client**
- **External apps and services**

## Connections

- CLI user → Command interface: submits query
- Command interface → Query controller: dispatches query (evidence: `cmd/query.go`)
- Query controller → SQLite namespace: queries namespace (evidence: `controller/query.go`)
- Query controller → SQL parser: parses SQL
- SQLite namespace → File readers: queries files
- SQLite namespace → Database connectors: queries databases
- SQLite namespace → Plugin RPC runtime: loads plugins
- Plugin RPC runtime → App integrations: dispatches plugin calls (evidence: `plugins/notion/database_query.go`)
- App integrations → External apps and services: accesses services
- MySQL client → MySQL server: connects
- MySQL server → MySQL protocol: serves protocol
- MySQL protocol → SQL parser: uses parser (evidence: `namespace/mysql_handler.go`)
- LLM client → MCP transport: connects via MCP
- LLM client → LLM access: uses function calling
- LLM access → Query controller: requests data
- Query controller → Plugin registry: uses registered sources
- SQLite namespace → SQLite extensions: loads extensions (evidence: `controller/controller.go`)
