connections:
# SQLite configuration examples
local-db:
type: sqlite
path: /path/to/dev.db
# Password is optional
password:
dev-sqlite:
type: sqlite
path: /path/to/prod.db
password: optional_password # Optional
# MySQL configuration examples
# Standard configuration
sandbox-mysql:
type: mysql
host: localhost
port: 3306
database: sandbox_db
user: sandbox_user
password: sandbox_pass
charset: utf8mb4
# URL configuration
# Use mysql://host:port/dbname?charset=utf8mb4&ssl-mode=verify_identity
integration-mysql:
type: mysql
url: mysql://mysql.example.com:3306/integration_db?charset=utf8mb4
user: integration_user
password: integration_pass
# Full SSL configuration example
test-mysql:
type: mysql
host: test-mysql.example.com
port: 3306
database: test_db
user: test_user
password: test_pass
charset: utf8mb4
ssl:
mode: verify_identity
ca: /path/to/ca.pem
cert: /path/to/client-cert.pem
key: /path/to/client-key.pem
# PostgreSQL configuration examples
# Standard configuration
demo-db:
type: postgres
host: postgres.example.com
port: 5432
dbname: demo_db
user: demo_user
password: demo_pass
# URL configuration
# Use postgresql://host:port/dbname?sslmode=verify-full&sslcert=/path/to/cert.pem
perf-db:
type: postgres
url: postgresql://postgres.example.com:5432/perf-db?sslmode=verify-full
user: perf_user
password: perf_pass
# Full SSL configuration example
security-db:
type: postgres
host: security-db.example.com
port: 5432
dbname: security_db
user: security_user
password: security_pass
ssl:
mode: verify-full
cert: /path/to/client-cert.pem
key: /path/to/client-key.pem
root: /path/to/ca.crt