execute_query
Execute SQL queries on PostgreSQL databases with configurable read-only or write permissions. Submit queries directly for database management or retrieval.
Instructions
Execute SQL queries on PostgreSQL database
Input Schema
Name | Required | Description | Default |
---|---|---|---|
query | Yes | SQL query to execute | |
readOnly | No | If true, only allows read-only queries (SELECT, EXPLAIN, etc.) |
Input Schema (JSON Schema)
{
"properties": {
"query": {
"description": "SQL query to execute",
"type": "string"
},
"readOnly": {
"default": false,
"description": "If true, only allows read-only queries (SELECT, EXPLAIN, etc.)",
"type": "boolean"
}
},
"required": [
"query"
],
"type": "object"
}