execute_query
Execute SQL queries against databases to retrieve, insert, update, or delete data using supported database connections and return results in JSON or CSV format.
Instructions
Execute a SQL query against a database and return results
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection_string | No | Database connection URL or configured connection name. Can be a full URL (e.g., "postgres://user:pass@localhost/db") or a connection name from env vars (e.g., "oracle" for USQL_ORACLE, "postgres" for USQL_POSTGRES) | |
| output_format | No | Output format for query results (default: json) | |
| parameters | No | Optional query parameters for prepared statements | |
| query | Yes | SQL query to execute (SELECT, INSERT, UPDATE, DELETE, etc.) | |
| timeout_ms | No | Optional timeout in milliseconds for this call (overrides defaults). Use null for unlimited. |