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

Name	Required	Default
`format`	No	json
`limit`	No
`params`	No
`query`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "format": {
      "default": "json",
      "title": "Format",
      "type": "string"
    },
    "limit": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Limit"
    },
    "params": {
      "anyOf": [
        {
          "items": {},
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Params"
    },
    "query": {
      "title": "Query",
      "type": "string"
    }
  },
  "required": [
    "query"
  ],
  "title": "execute_queryArguments",
  "type": "object"
}

CockroachDB MCP Server

execute_query

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from CockroachDB MCP Server

Related Tools

MCP directory API