agentuity-cli-cloud-db-sql

agentuity's avatarfrom agentuity

Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations

⭐3stars🔀5forks📁View on GitHub🕐Updated Jan 5, 2026
[SQL and Databases]

When & Why to Use This Skill

This Claude skill provides a robust interface for executing SQL queries directly on databases within the Agentuity cloud platform. It enables AI agents to perform secure, authenticated data retrieval and manipulation, returning structured JSON results for seamless integration into automated workflows. By bridging the gap between natural language instructions and complex relational database operations, it empowers users to manage cloud-hosted data with precision and efficiency.

Use Cases

  • Data Retrieval & Reporting: Quickly fetching specific records, such as user profiles or transaction histories, to answer complex business questions or generate reports.
  • Operational Monitoring: Executing aggregation queries (e.g., COUNT, SUM) to monitor system health, track KPIs, or audit database entries in real-time.
  • Data Verification: Confirming the existence or status of specific data points during troubleshooting or automated multi-step workflows.
  • Dynamic Filtering: Performing complex queries with specific filters (e.g., price ranges, date constraints) to extract targeted datasets for analysis.
nameagentuity-cli-cloud-db-sql
descriptionExecute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations
version"0.0.104"
licenseApache-2.0
allowed-tools"Bash(agentuity:*)"
argument-hint"<name> <query>"
command"agentuity cloud db sql"
tags"slow requires-auth"

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