CockroachDB MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

execute_query

Run SQL queries on CockroachDB with optional parameters, output formatting, and row limits. Retrieve results in JSON, CSV, or table format for efficient data management and integration.

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"
}

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/amineelkouhen/mcp-cockroach'

If you have feedback or need assistance with the MCP directory API, please join our Discord server