> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify.com/drizzle-team/drizzle-orm/llms.txt
> Use this file to discover all available pages before exploring further.
# Database Drivers
> Overview of database drivers and connection options in Drizzle ORM
# Database Drivers
Drizzle ORM supports a wide range of database drivers across PostgreSQL, MySQL, and SQLite. Each driver is optimized for specific use cases and deployment environments.
## Driver Categories
### PostgreSQL Drivers
Drizzle supports multiple PostgreSQL drivers, each optimized for different environments:
Traditional Node.js driver with connection pooling
Modern, fast PostgreSQL driver for Node.js
WebSocket-based driver for Neon serverless databases
HTTP-based driver for edge environments
Optimized driver for Vercel deployments
### MySQL Drivers
MySQL and MySQL-compatible database drivers:
Fast MySQL driver for Node.js with prepared statements
Serverless driver for PlanetScale databases
### SQLite Drivers
SQLite drivers for various JavaScript runtimes:
Synchronous SQLite driver for Node.js
Driver for Turso and local SQLite databases
SQLite driver for Cloudflare Workers
## Common Configuration Options
All Drizzle drivers support a consistent configuration API:
### Schema
Pass your schema to enable relational queries:
```typescript theme={null}
import { drizzle } from 'drizzle-orm/[driver]';
import * as schema from './schema';
const db = drizzle(client, { schema });
```
### Logger
Enable query logging for debugging:
```typescript theme={null}
// Enable default logger
const db = drizzle(client, { logger: true });
// Custom logger
const db = drizzle(client, {
logger: {
logQuery(query, params) {
console.log({ query, params });
},
},
});
```
### Casing
Automatically convert between database and JavaScript naming conventions:
```typescript theme={null}
const db = drizzle(client, {
casing: 'snake_case', // Convert camelCase to snake_case
});
```
### Cache
Enable query result caching:
```typescript theme={null}
import { caching } from 'drizzle-orm';
const db = drizzle(client, {
cache: caching({
ttl: 60_000, // 60 seconds
}),
});
```
## Connection Methods
Drizzle supports multiple ways to initialize database connections:
### Method 1: Pass existing client
```typescript theme={null}
import { drizzle } from 'drizzle-orm/[driver]';
import { Client } from '[driver-package]';
const client = new Client({
// connection options
});
const db = drizzle(client);
```
### Method 2: Connection string
```typescript theme={null}
const db = drizzle('postgres://user:password@host:port/database');
```
### Method 3: Configuration object
```typescript theme={null}
const db = drizzle({
connection: {
host: 'localhost',
port: 5432,
user: 'postgres',
password: 'password',
database: 'mydb',
},
schema,
logger: true,
});
```
## Environment-Specific Recommendations
### Serverless (Edge)
* **PostgreSQL**: Neon HTTP, Vercel Postgres
* **MySQL**: PlanetScale Serverless
* **SQLite**: Cloudflare D1, Turso (libSQL)
### Traditional Node.js
* **PostgreSQL**: node-postgres, postgres.js
* **MySQL**: mysql2
* **SQLite**: better-sqlite3
### Long-Running Servers
* **PostgreSQL**: node-postgres with connection pooling
* **MySQL**: mysql2 with connection pooling
* **SQLite**: better-sqlite3
## Next Steps
Learn about PostgreSQL drivers
Learn about MySQL drivers
Learn about SQLite drivers