config:
  postgres:
    dsn: postgres://user:password@localhost:5432/mydb

### Running Queries

```yaml
- name: query-users
  type: db
  query: "SELECT id, email, created_at FROM users WHERE status = 'active'"

- name: create-user
  type: db
  query: |
    INSERT INTO users (name, email)
    VALUES ('Alice', 'alice@example.com')
    RETURNING id;
  extract:
    new_id: $[0].id

[
  { "id": 1, "name": "Alice", "email": "alice@example.com" },
  { "id": 2, "name": "Bob", "email": "bob@example.com" }
]

extract:
  first_name: $[0].name
  all_emails: $[*].email

- name: find-user
  type: db
  query: "SELECT * FROM users WHERE id = {{ user_id }}"

- name: check-user
  type: db
  query: "SELECT count(*) as cnt FROM users"
  assert:
    - ["$[0].cnt", "gt", 0]

config:
  redis:
    addr: localhost:6379

- name: set-value
  type: db
  engine: redis
  command: ["SET", "session:1", "active"]

- name: get-value
  type: db
  engine: redis
  command: ["GET", "session:1"]
  extract:
    session_status: $
  assert:
    - ["$", "eq", "active"]

- name: hash-operations
  type: db
  engine: redis
  command: ["HSET", "user:42", "name", "Alice", "score", "100"]

- name: get-hash
  type: db
  engine: redis
  command: ["HGETALL", "user:42"]
  extract:
    user_data: $

# Full block
- name: query
  type: db
  db:
    engine: postgres
    query: SELECT 1

# Shorthand
- name: query
  type: db
  engine: postgres
  query: SELECT 1

# Redis shorthand
- name: cache
  type: db
  engine: redis
  command: ["SET", "key", "val"]