vMySQL FAQs

Question 1

How does vMySQL manage access to multiple database environments?

Accepted Answer

It supports multi-environment access through configurable aliases (e.g., `dev`, `prod_ro`), allowing each environment to have its own connection settings and security policies, all accessible via a single, controlled gateway.

Question 2

How does vMySQL ensure database security and control?

Accepted Answer

vMySQL implements robust server-side policy controls, including read/write limits, DDL restrictions, query timeouts, and row limits. It supports distinct policies per environment (e.g., `prod_ro` for read-only) and uses environment variables for sensitive connection strings.

Question 3

What is vMySQL and its primary purpose?

Accepted Answer

vMySQL is a lightweight, controlled gateway that facilitates multi-environment MySQL database interactions via stdio. Its main purpose is to provide a secure and manageable entry point for database operations, especially for agent-based automation.

Question 4

What are the primary communication and output formats of vMySQL?

Accepted Answer

vMySQL communicates using `stdio` (standard input/output), making it highly compatible with various agents. It provides operation results in both concise text summaries and structured JSON formats, ideal for programmatic parsing and automation.

Question 5

What types of SQL operations can be performed using vMySQL?

Accepted Answer

vMySQL exposes two focused tools: `mysql_query` for strictly read-only operations (SELECT, SHOW, EXPLAIN, WITH...SELECT) and `mysql_exec` for policy-gated write operations (INSERT, UPDATE, DELETE, REPLACE, and optional DDL, subject to environment policy).

vMySQL

vMySQL

主要功能

使用案例

主要功能

使用案例