PostgreSQL MCP Server

get-table-info

Retrieve detailed metadata for a PostgreSQL table, including columns, constraints, indexes, and optional statistics like row count and size. Simplify database analysis and management.

Instructions

Get detailed information about a specific table including columns, constraints, indexes, and optionally statistics like row count and size.

Input Schema

Name	Required	Default
`include_statistics`	No
`schema_name`	No	public
`table`	Yes

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "include_statistics": {
      "default": true,
      "type": "boolean"
    },
    "schema_name": {
      "default": "public",
      "type": "string"
    },
    "table": {
      "minLength": 1,
      "type": "string"
    }
  },
  "required": [
    "table"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Related Tools

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/cesarvarela/postgres-mcp'

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