YugabyteDB
Arcade tools designed for LLMs to interact with YugabyteDB databases
0.1.0
YugabyteDB (Yugabytedb) Arcade toolkit lets LLMs inspect and query YugabyteDB instances in a safe, read-only manner. It enables schema discovery and executing SELECT-style queries with structured JSON output to support automated analysis and query generation.
Capabilities
- Discover database structure: list tables, columns, types, and row counts to inform query design.
- Execute read-only SQL inside READ ONLY transactions to prevent accidental writes.
- Return results as JSON arrays of row objects with column-name keys for straightforward parsing.
- Support iterative query development by using schema summaries to craft accurate, safe queries.
Secrets
Connection secret: YUGABYTEDB_URL - a connection URL/DSN (e.g., postgresql://user:pass@host:port/dbname) or JDBC-style string stored as an environment secret; handle as sensitive credentials.
Available tools(2)
| Tool name | Description | Secrets | |
|---|---|---|---|
Run a read-only SQL query against YugabyteDB and return results as JSON.
The query is executed inside a READ ONLY transaction so writes are rejected.
Results are returned as a JSON array where each element is a row object
with column names as keys. | 1 | ||
List all tables in a YugabyteDB database, including column schemas and row counts.
CALL THIS FIRST to understand the database structure before writing queries.
Returns every table in the given schema with: table name, column definitions
(name and data type), and total row count. | 1 |
Selected tools
No tools selected.
Click "Show all tools" to add tools.
Requirements
Select tools to see requirements
Yugabytedb.RunReadOnlyQuery
Run a read-only SQL query against YugabyteDB and return results as JSON. The query is executed inside a READ ONLY transaction so writes are rejected. Results are returned as a JSON array where each element is a row object with column names as keys.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
query | string | Required | SQL query to execute (must be read-only) |
Requirements
Output
string— Query results as a JSON array of objectsYugabytedb.SummarizeDatabase
List all tables in a YugabyteDB database, including column schemas and row counts. CALL THIS FIRST to understand the database structure before writing queries. Returns every table in the given schema with: table name, column definitions (name and data type), and total row count.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
db_schema | string | Optional | Database schema to summarize (e.g. 'public') |
Requirements
Output
array— List of tables with column schemas and row counts