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