select_rows

从指定表安全查询。order_by 项可用前缀 '-' 表示 DESC。db 省略时自动推断。

Server Yooztech Mcp Mysql yooztech/mcp_mysql
Category Read
Risk class Low
Parameters 00 required

What select_rows does on Yooztech Mcp Mysql

AI agents call select_rows to retrieve information from Yooztech Mcp Mysql without modifying anything — typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

Why select_rows needs a policy

This tool performs read-only SELECT queries on a MySQL database. The server explicitly states it provides 'secure read-only access' with built-in safety features. The tool name 'select_rows' and description of 'safe querying' confirm no write or destructive operations are possible. Severity is low due to read-only nature and additional security controls like whitelisting and rate limiting.

From the tool's definition '安全查询' (safe query), server description states 'read-only access', 'SELECT' implied by tool name 'select_rows', with 'parameterized queries, whitelisting, and rate limiting'

Questions about select_rows

What does the select_rows tool do? +

从指定表安全查询。order_by 项可用前缀 '-' 表示 DESC。db 省略时自动推断。. It is categorised as a Read tool in the Yooztech Mcp Mysql MCP Server, which means it retrieves data without modifying state.

How do I enforce a policy on select_rows? +

Register the Yooztech Mcp Mysql MCP server in PolicyLayer and add a rule for select_rows: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Yooztech Mcp Mysql. Nothing to install.

What risk level is select_rows? +

select_rows is a Read tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit select_rows? +

Yes. Add a rate_limit block to the select_rows rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block select_rows completely? +

Set action: deny in the PolicyLayer policy for select_rows. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides select_rows? +

select_rows is provided by the Yooztech Mcp Mysql MCP server (yooztech/mcp_mysql). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

// LOOK UP ANOTHER SERVER

Every MCP server has a record like this.

Type a name, get the same breakdown: verified identity, auth posture, risk grade, capabilities, recommended policy.

Teams ship this data inside their own products. See what a licence covers →

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.