execute_sql
Run custom SQL queries directly on self-hosted Supabase databases. Supports read-only hints for optimized execution. Ideal for database introspection and management tasks within development environments.
Instructions
Executes an arbitrary SQL query against the database, primarily using the execute_sql RPC function.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| read_only | No | Hint for the RPC function whether the query is read-only (best effort). | |
| sql | Yes | The SQL query to execute. |
Input Schema (JSON Schema)
{
"properties": {
"read_only": {
"default": false,
"description": "Hint for the RPC function whether the query is read-only (best effort).",
"type": "boolean"
},
"sql": {
"description": "The SQL query to execute.",
"type": "string"
}
},
"required": [
"sql"
],
"type": "object"
}