# yiisoft/db architecture

> Architecture diagram of the GitHub repository yiisoft/db, 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/yiisoft/db
- Repository: https://github.com/yiisoft/db

## Overview

Yii Database is a framework-agnostic PHP database abstraction layer. Applications create a connection through a database driver, compose reads with the query API or writes/schema operations with commands, and execute them against a DBMS; transactions and batched results extend that workflow. Internally, query builders translate query structures and expressions into driver-specific SQL, while schema metadata and quoting support database-aware operations. The README documents driver packages and schema caching; several internal links below rely on indexed references rather than inspected implementation excerpts.

Main entry points: [`src/QueryBuilder/AbstractQueryBuilder.php`](https://github.com/yiisoft/db/blob/master/src/QueryBuilder/AbstractQueryBuilder.php) (Query Builders), [`src/Connection/ConnectionInterface.php`](https://github.com/yiisoft/db/blob/master/src/Connection/ConnectionInterface.php) (Connection), [`src/Query/Query.php`](https://github.com/yiisoft/db/blob/master/src/Query/Query.php) (Query API), [`src/Command/CommandInterface.php`](https://github.com/yiisoft/db/blob/master/src/Command/CommandInterface.php) (Command API)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_api["Database API"]
  node_connection["Connection"]
  node_query["Query API<br/>[Query.php]"]
  node_command["Command API"]
  node_transaction["Transactions"]
  node_batch["Batch Results"]
end

subgraph group_sql["SQL Construction"]
  node_querybuilder["Query Builders"]
  node_dqlbuilder["DQL Builder"]
  node_dmlbuilder["DML Builder"]
  node_expressions["Expressions<br/>[Expression.php]"]
  node_expressionbuilders["Expression Builders"]
  node_conditions["Query Conditions"]
end

subgraph group_schema["Schema Metadata"]
  node_schema["Schema API<br/>[AbstractSchema.php]"]
  node_columns["Column Metadata"]
  node_quoter["SQL Quoter<br/>[Quoter.php]"]
  node_schema_cache["Schema Cache<br/>[SchemaCache.php]"]
end

subgraph group_runtime["Execution Runtime"]
  node_pdo["PDO Adapter"]
  node_reader["Data Reader"]
end

node_application(("Application"))
node_database[("Database Server")]
node_driver_packages["DB Driver Packages"]
node_cache_service[("PSR-16 Cache")]

node_application -->|"opens connection"| node_connection
node_driver_packages -.->|"provides driver"| node_connection
node_application -->|"composes reads"| node_query
node_application -->|"requests writes"| node_command
node_application -->|"runs transaction"| node_transaction
node_connection -->|"creates query"| node_query
node_connection -->|"creates command"| node_command
node_connection -->|"manages transaction"| node_transaction
node_query -->|"executes through"| node_connection
node_query -->|"creates batches"| node_batch
node_query -->|"builds SQL"| node_querybuilder
node_querybuilder -->|"delegates reads"| node_dqlbuilder
node_querybuilder -->|"delegates writes"| node_dmlbuilder
node_querybuilder -->|"builds expressions"| node_expressions
node_querybuilder -.->|"builds conditions"| node_conditions
node_expressions -->|"built by"| node_expressionbuilders
node_command -->|"generates SQL"| node_querybuilder
node_command -->|"executes command"| node_pdo
node_pdo -.->|"sends SQL"| node_database
node_connection -->|"obtains metadata"| node_schema
node_schema -.->|"describes columns"| node_columns
node_querybuilder -->|"quotes identifiers"| node_quoter
node_schema -.->|"caches metadata"| node_schema_cache
node_batch -->|"yields rows"| node_reader
node_reader -.->|"reads results"| node_database
node_cache_service -.->|"backs cache"| node_schema_cache

click node_connection "https://github.com/yiisoft/db/blob/master/src/Connection/ConnectionInterface.php"
click node_query "https://github.com/yiisoft/db/blob/master/src/Query/Query.php"
click node_command "https://github.com/yiisoft/db/blob/master/src/Command/CommandInterface.php"
click node_transaction "https://github.com/yiisoft/db/blob/master/src/Transaction/TransactionInterface.php"
click node_batch "https://github.com/yiisoft/db/blob/master/src/Query/BatchQueryResult.php"
click node_querybuilder "https://github.com/yiisoft/db/blob/master/src/QueryBuilder/AbstractQueryBuilder.php"
click node_dqlbuilder "https://github.com/yiisoft/db/blob/master/src/QueryBuilder/AbstractDQLQueryBuilder.php"
click node_dmlbuilder "https://github.com/yiisoft/db/blob/master/src/QueryBuilder/AbstractDMLQueryBuilder.php"
click node_expressions "https://github.com/yiisoft/db/blob/master/src/Expression/Expression.php"
click node_expressionbuilders "https://github.com/yiisoft/db/blob/master/src/Expression/ExpressionBuilder.php"
click node_conditions "https://github.com/yiisoft/db/tree/master/src/QueryBuilder/Condition"
click node_schema "https://github.com/yiisoft/db/blob/master/src/Schema/AbstractSchema.php"
click node_columns "https://github.com/yiisoft/db/blob/master/src/Schema/Column/ColumnInterface.php"
click node_quoter "https://github.com/yiisoft/db/blob/master/src/Schema/Quoter.php"
click node_schema_cache "https://github.com/yiisoft/db/blob/master/src/Cache/SchemaCache.php"
click node_pdo "https://github.com/yiisoft/db/blob/master/src/Driver/Pdo/AbstractPdoCommand.php"
click node_reader "https://github.com/yiisoft/db/blob/master/src/Query/DataReaderInterface.php"

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_connection,node_query,node_command,node_transaction,node_batch toneBlue
class node_querybuilder,node_dqlbuilder,node_dmlbuilder,node_expressions,node_expressionbuilders,node_conditions,node_database,node_cache_service toneAmber
class node_schema,node_columns,node_quoter,node_schema_cache toneMint
class node_pdo,node_reader toneRose
class node_application,node_driver_packages toneIndigo
```

## Components

### Database API

- [Connection](https://github.com/yiisoft/db/blob/master/src/Connection/ConnectionInterface.php): `src/Connection/ConnectionInterface.php`
- [Query API](https://github.com/yiisoft/db/blob/master/src/Query/Query.php): `src/Query/Query.php`
- [Command API](https://github.com/yiisoft/db/blob/master/src/Command/CommandInterface.php): `src/Command/CommandInterface.php`
- [Transactions](https://github.com/yiisoft/db/blob/master/src/Transaction/TransactionInterface.php): `src/Transaction/TransactionInterface.php`
- [Batch Results](https://github.com/yiisoft/db/blob/master/src/Query/BatchQueryResult.php): `src/Query/BatchQueryResult.php`

### SQL Construction

- [Query Builders](https://github.com/yiisoft/db/blob/master/src/QueryBuilder/AbstractQueryBuilder.php): `src/QueryBuilder/AbstractQueryBuilder.php`
- [DQL Builder](https://github.com/yiisoft/db/blob/master/src/QueryBuilder/AbstractDQLQueryBuilder.php): `src/QueryBuilder/AbstractDQLQueryBuilder.php`
- [DML Builder](https://github.com/yiisoft/db/blob/master/src/QueryBuilder/AbstractDMLQueryBuilder.php): `src/QueryBuilder/AbstractDMLQueryBuilder.php`
- [Expressions](https://github.com/yiisoft/db/blob/master/src/Expression/Expression.php): `src/Expression/Expression.php`
- [Expression Builders](https://github.com/yiisoft/db/blob/master/src/Expression/ExpressionBuilder.php): `src/Expression/ExpressionBuilder.php`
- [Query Conditions](https://github.com/yiisoft/db/tree/master/src/QueryBuilder/Condition): `src/QueryBuilder/Condition`

### Schema Metadata

- [Schema API](https://github.com/yiisoft/db/blob/master/src/Schema/AbstractSchema.php): `src/Schema/AbstractSchema.php`
- [Column Metadata](https://github.com/yiisoft/db/blob/master/src/Schema/Column/ColumnInterface.php): `src/Schema/Column/ColumnInterface.php`
- [SQL Quoter](https://github.com/yiisoft/db/blob/master/src/Schema/Quoter.php): `src/Schema/Quoter.php`
- [Schema Cache](https://github.com/yiisoft/db/blob/master/src/Cache/SchemaCache.php): `src/Cache/SchemaCache.php`

### Execution Runtime

- [PDO Adapter](https://github.com/yiisoft/db/blob/master/src/Driver/Pdo/AbstractPdoCommand.php): `src/Driver/Pdo/AbstractPdoCommand.php`
- [Data Reader](https://github.com/yiisoft/db/blob/master/src/Query/DataReaderInterface.php): `src/Query/DataReaderInterface.php`

### Other components

- **Application**
- **Database Server**
- **DB Driver Packages**
- **PSR-16 Cache**

## Connections

- Application → Connection: opens connection (evidence: `README.md`)
- DB Driver Packages → Connection: provides driver (evidence: `README.md`)
- Application → Query API: composes reads (evidence: `README.md`)
- Application → Command API: requests writes (evidence: `README.md`)
- Application → Transactions: runs transaction (evidence: `README.md`)
- Connection → Query API: creates query (evidence: `src/Connection/ConnectionInterface.php`)
- Connection → Command API: creates command (evidence: `src/Command/CommandInterface.php`)
- Connection → Transactions: manages transaction (evidence: `src/Connection/ConnectionInterface.php`)
- Query API → Connection: executes through (evidence: `src/Query/Query.php`)
- Query API → Batch Results: creates batches (evidence: `src/Query/Query.php`)
- Query API → Query Builders: builds SQL (evidence: `src/Query/Query.php`)
- Query Builders → DQL Builder: delegates reads (evidence: `src/QueryBuilder/AbstractDQLQueryBuilder.php`)
- Query Builders → DML Builder: delegates writes (evidence: `src/QueryBuilder/AbstractDMLQueryBuilder.php`)
- Query Builders → Expressions: builds expressions (evidence: `src/QueryBuilder/AbstractQueryBuilder.php`)
- Query Builders → Query Conditions: builds conditions (evidence: `src/QueryBuilder/AbstractQueryBuilder.php`)
- Expressions → Expression Builders: built by (evidence: `src/Expression/ExpressionBuilder.php`)
- Command API → Query Builders: generates SQL (evidence: `src/Command/CommandInterface.php`)
- Command API → PDO Adapter: executes command (evidence: `src/Driver/Pdo/AbstractPdoCommand.php`)
- PDO Adapter → Database Server: sends SQL
- Connection → Schema API: obtains metadata (evidence: `src/Connection/ConnectionInterface.php`)
- Schema API → Column Metadata: describes columns
- Query Builders → SQL Quoter: quotes identifiers (evidence: `src/Schema/Quoter.php`)
- Schema API → Schema Cache: caches metadata (evidence: `README.md`)
- Batch Results → Data Reader: yields rows (evidence: `src/Query/BatchQueryResult.php`)
- Data Reader → Database Server: reads results
- PSR-16 Cache → Schema Cache: backs cache (evidence: `README.md`)
