execute_query
Run SQL queries on CockroachDB with customizable parameters, output formats, and row limits. Retrieve results in JSON, CSV, or table format for efficient data handling.
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 |