majiayu000 Cloud Db Sql
Execute SQL query on a database
Prerequisites
- Authenticated with
agentuity auth login - Organization context required (
--org-idor 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 |