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
Execution hints
Signals for MCP clients and agents about how this tool behaves.
Reads data without modifying any state in the target system.
May permanently delete or overwrite data in the target system.
Repeated calls with the same inputs produce no additional effect.
Communicates with external APIs, databases, or other services.
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
Execution hints
Signals for MCP clients and agents about how this tool behaves.
Reads data without modifying any state in the target system.
May permanently delete or overwrite data in the target system.
Repeated calls with the same inputs produce no additional effect.
Communicates with external APIs, databases, or other services.
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