execute_sql
Execute SQL queries on Databend databases with built-in safety controls that restrict write operations to a session sandbox.
Instructions
Execute SQL query against Databend database.
SAFETY RULES (when DATABEND_MCP_SAFE_MODE is enabled):
Read operations (SELECT/SHOW/DESCRIBE/EXPLAIN/LIST): allowed on ALL objects
Write operations (CREATE/DROP/INSERT/UPDATE/DELETE/...): ONLY allowed on current session's sandbox
Current session sandbox prefix: use get_session_sandbox_prefix() to get it
Set DATABEND_MCP_SAFE_MODE=false to disable sandbox validation
Args: sql: SQL query string to execute
Returns: Dictionary containing query results or error information
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||