agentuity-cli-cloud-db-sql

Execute SQL query on a database

Prerequisites

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

Usage

agentuity cloud db sql <name> <query>

Arguments

| Argument | Type | Required | Description | |----------|------|----------|-------------| | <name> | string | Yes | - | | <query> | string | Yes | - |

Examples

Execute SQL query:

bunx @agentuity/cli cloud db sql my-database "SELECT * FROM users LIMIT 10"

Execute query with JSON output:

bunx @agentuity/cli cloud db exec my-database "SELECT COUNT(*) FROM orders" --json

Query with filter:

bunx @agentuity/cli cloud db query my-database "SELECT * FROM products WHERE price > 100"

Output

Returns JSON object:

{
  "rows": "array",
  "rowCount": "number",
  "truncated": "boolean"
}

| Field | Type | Description | |-------|------|-------------| | rows | array | Query results | | rowCount | number | Number of rows returned | | truncated | boolean | Whether results were truncated |