execute_custom_query
Run custom SQL queries on PostgreSQL databases using a secure connection. Manage schemas, debug issues, migrate data, and monitor performance with controlled access and optional query timeout.
Instructions
Execute a custom SQL query against the database. WARNING: Use with care. Do not expose to untrusted input.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
connectionString | Yes | PostgreSQL connection string | |
query | Yes | SQL query to execute | |
timeout | No | Optional query timeout in milliseconds | |
values | No | Optional parameter values for the query |
Input Schema (JSON Schema)
{
"properties": {
"connectionString": {
"description": "PostgreSQL connection string",
"type": "string"
},
"query": {
"description": "SQL query to execute",
"type": "string"
},
"timeout": {
"description": "Optional query timeout in milliseconds",
"type": "number"
},
"values": {
"description": "Optional parameter values for the query",
"items": {
"type": "string"
},
"type": "array"
}
},
"required": [
"connectionString",
"query"
],
"type": "object"
}