agentuity-cli-cloud-db-logs

# Cloud Db Logs

Get query logs for a specific database

## Prerequisites

- Authenticated with `agentuity auth login`
- Organization context required (`--org-id` or default org)

## Usage

```bash
agentuity cloud db logs <database> [options]
```

## Arguments

| Argument | Type | Required | Description |
|----------|------|----------|-------------|
| `<database>` | string | Yes | - |

## Options

| Option | Type | Required | Default | Description |
|--------|------|----------|---------|-------------|
| `--startDate` | string | Yes | - | Start date for filtering logs |
| `--endDate` | string | Yes | - | End date for filtering logs |
| `--username` | string | Yes | - | Filter by username |
| `--command` | string | Yes | - | Filter by SQL command type |
| `--hasError` | boolean | Yes | - | Show only queries with errors |
| `--sessionId` | string | Yes | - | Filter by session ID (trace ID) |
| `--showSessionId` | boolean | No | `false` | Show session ID column in output |
| `--showUsername` | boolean | No | `false` | Show username column in output |
| `--pretty` | boolean | No | `false` | Show full formatted SQL on separate line |
| `--limit` | number | No | `100` | Maximum number of logs to return |
| `--timestamps` | boolean | No | `true` | Show timestamps in output |

## Examples

View query logs for database:

```bash
bunx @agentuity/cli cloud db logs my-database
```

Limit to 50 log entries:

```bash
bunx @agentuity/cli cloud db logs my-database --limit=50
```

Show only queries with errors:

```bash
bunx @agentuity/cli cloud db logs my-database --has-error
```

Filter by username:

```bash
bunx @agentuity/cli cloud db logs my-database --username=user123
```

Filter by SQL command type:

```bash
bunx @agentuity/cli cloud db logs my-database --command=SELECT
```

Filter by session ID:

```bash
bunx @agentuity/cli cloud db logs my-database --session-id=sess_abc123
```

Show session ID column:

```bash
bunx @agentuity/cli cloud db logs my-database --show-session-id
```

Show username column:

```bash
bunx @agentuity/cli cloud db logs my-database --show-username
```

Show full formatted SQL on separate lines:

```bash
bunx @agentuity/cli cloud db logs my-database --pretty
```

## Output

Returns: `array`