query_table

query_table

Query a specific table with schema selection and where clause support

Input Schema

Name	Required	Description
`schema`	No	Database schema (optional, defaults to public)
`select`	No	Comma-separated list of columns to select (optional, defaults to *)
`table`	Yes	Name of the table to query
`where`	No	Array of where conditions (optional)

Input Schema (JSON Schema)

{
  "properties": {
    "schema": {
      "description": "Database schema (optional, defaults to public)",
      "type": "string"
    },
    "select": {
      "description": "Comma-separated list of columns to select (optional, defaults to *)",
      "type": "string"
    },
    "table": {
      "description": "Name of the table to query",
      "type": "string"
    },
    "where": {
      "description": "Array of where conditions (optional)",
      "items": {
        "properties": {
          "column": {
            "description": "Column name",
            "type": "string"
          },
          "operator": {
            "description": "Comparison operator",
            "enum": [
              "eq",
              "neq",
              "gt",
              "gte",
              "lt",
              "lte",
              "like",
              "ilike",
              "is"
            ],
            "type": "string"
          },
          "value": {
            "description": "Value to compare against",
            "type": "any"
          }
        },
        "required": [
          "column",
          "operator",
          "value"
        ],
        "type": "object"
      },
      "type": "array"
    }
  },
  "required": [
    "table"
  ],
  "type": "object"
}

Input Schema

Input Schema (JSON Schema)

Other Tools