PostgreSQL MCP Server

get-schema

Retrieve PostgreSQL database schema details, including tables, columns, data types, and optional constraints, to analyze and understand the database structure efficiently.

Instructions

Get database schema information including tables, columns, data types, and optionally constraints. Useful for understanding database structure.

Input Schema

Name	Required	Default
`include_columns`	No
`include_constraints`	No
`schema_name`	No	public
`table_pattern`	No

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "include_columns": {
      "default": true,
      "type": "boolean"
    },
    "include_constraints": {
      "default": false,
      "type": "boolean"
    },
    "schema_name": {
      "default": "public",
      "type": "string"
    },
    "table_pattern": {
      "type": "string"
    }
  },
  "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