Smithery's MCP Proxy and managed identity shut down on October 31. See what's changing

SmitherySign up for Arcade

YugabyteDB

Arcade toolkit · docs.arcade.dev

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.

Store this secret in the Arcade Dashboard at https://api.arcade.dev/dashboard/auth/secrets. For general guidance on defining and using secrets in Arcade tools, see the Arcade secrets documentation.

Tools2

  • 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.

  • Yugabytedb_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.