PostgreSQL

Methods (4)

• query

  read

  Execute a read-only SQL query wrapped in a READ ONLY transaction.

  Required paramssql
  Input schema

  {
    "type": "object",
    "properties": {
      "sql": {
        "type": "string"
      }
    },
    "additionalProperties": false,
    "required": [
      "sql"
    ]
  }

• listTables

  read

  List tables in a schema with column counts.

  Input schema

  {
    "type": "object",
    "properties": {
      "schema": {
        "type": "string"
      }
    },
    "additionalProperties": false
  }

  Defaults to the public schema when schema is omitted.

• describeTable

  read

  Describe columns for a table including data types and primary key flags.

  Required paramstable
  Input schema

  {
    "type": "object",
    "properties": {
      "table": {
        "type": "string"
      },
      "schema": {
        "type": "string"
      }
    },
    "additionalProperties": false,
    "required": [
      "table"
    ]
  }

  Schema defaults to public when not specified.

• listSchemas

  read

  List non-system schemas available in the database.

  Input schema

  {
    "type": "object",
    "properties": {},
    "additionalProperties": false
  }