Back to home
Connect a client

Read table rows

Read a bounded page of PostgreSQL rows with optional ordering. The table and ordering identifiers are validated.

Arguments

NameTypeRequiredLimits
schemastringNoSee schema
limitintegerNoMinimum 1; Maximum 1000
offsetintegerNoMinimum 0
orderBystringNoSee schema
orderDir"asc" | "desc"NoSee schema
projectIdstringYesAt least 1 character(s)
databaseIdstringYesAt least 1 character(s)
tablestringYesAt least 1 character(s)
Full input schema
{
  "type": "object",
  "properties": {
    "schema": {
      "type": "string"
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 1000
    },
    "offset": {
      "type": "integer",
      "minimum": 0
    },
    "orderBy": {
      "type": "string"
    },
    "orderDir": {
      "type": "string",
      "enum": [
        "asc",
        "desc"
      ]
    },
    "projectId": {
      "type": "string",
      "minLength": 1
    },
    "databaseId": {
      "type": "string",
      "minLength": 1
    },
    "table": {
      "type": "string",
      "minLength": 1
    }
  },
  "required": [
    "projectId",
    "databaseId",
    "table"
  ],
  "additionalProperties": false
}

Example call

The params of a tools/call request. Replace the placeholder values with your own IDs.

{
  "name": "getDatabaseTableRows",
  "arguments": {
    "projectId": "REPLACE_WITH_PROJECT_ID",
    "databaseId": "REPLACE_WITH_DATABASE_ID",
    "table": "REPLACE_WITH_TABLE"
  }
}

Result

The same data as the API operation, wrapped as {"untrusted_data": true, "source": "getDatabaseTableRows", "note": "...", "data": ...} so the model treats project content as data, not instructions.