Cloud Db Logs

Get query logs for a specific database

Prerequisites

• Authenticated with agentuity auth login

Usage

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:

bunx @agentuity/cli cloud db logs my-database

Limit to 50 log entries:

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

Show only queries with errors:

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

Filter by username:

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

Filter by SQL command type:

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

Filter by session ID:

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

Show session ID column:

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

Show username column:

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

Show full formatted SQL on separate lines:

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

Output

Returns: array