execute_query
Execute SQL queries on CockroachDB with optional parameters, outputting results in JSON, CSV, or table format, and controlled row limits for targeted data retrieval.
Instructions
Execute a SQL query with optional parameters and formatting.
Args: query (str): SQL query to execute. params (List, optional): Query parameters. format (str): Output format ('json', 'csv', 'table'). limit (int, optional): Limit number of rows returned.
Returns: The query resultset in json or csv format.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | No | json | |
| limit | No | ||
| params | No | ||
| query | Yes |