agentuity-cli-cloud-db-logs
Get query logs for a specific database. Requires authentication. Use for Agentuity cloud platform operations
When & Why to Use This Skill
The agentuity-cli-cloud-db-logs skill enables seamless retrieval and analysis of database query logs within the Agentuity cloud platform. It empowers developers and SREs to monitor database activity, filter logs by specific criteria such as errors or users, and gain actionable insights into database performance and security.
Use Cases
- Debugging application errors by filtering database logs for failed queries and specific error statuses.
- Conducting security audits by monitoring SQL commands executed by specific users or within certain timeframes.
- Performance tuning by identifying high-latency or frequent queries through detailed log inspection.
- Incident response and forensics by tracing database operations using session IDs to reconstruct system events.
| name | agentuity-cli-cloud-db-logs |
|---|---|
| description | Get query logs for a specific database. Requires authentication. Use for Agentuity cloud platform operations |
| version | "0.0.103" |
| license | Apache-2.0 |
| allowed-tools | "Bash(agentuity:*)" |
| argument-hint | "<database>" |
| command | "agentuity cloud db logs" |
| tags | "read-only slow requires-auth" |
Cloud Db Logs
Get query logs for a specific database
Prerequisites
- Authenticated with
agentuity auth login - Organization context required (
--org-idor default org)
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