PostgreSQL MCP Server

describe_table

Retrieve detailed schema information for a specific table in a PostgreSQL database, including column names, data types, and constraints, to analyze and understand table structure and metadata.

Instructions

Get detailed schema information for a specific table

Input Schema

Name	Required	Description	Default
`schema`	No	Schema name (default: public)	public
`table_name`	Yes	Name of the table to describe

Input Schema (JSON Schema)

{
  "properties": {
    "schema": {
      "default": "public",
      "description": "Schema name (default: public)",
      "type": "string"
    },
    "table_name": {
      "description": "Name of the table to describe",
      "type": "string"
    }
  },
  "required": [
    "table_name"
  ],
  "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/sbfulfil/pg-mcp'

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