MCP Postgres Server

Overview InspectNew Endpoints Schema Related Servers Reviews Score

get_constraints

Retrieve table constraints from a PostgreSQL database using the MCP Postgres Server. Specify schema and table names to extract detailed constraint information for efficient database management.

Instructions

Get constraints for a table

Input Schema

Name	Required	Description	Default
`schema`	Yes
`table`	Yes

Input Schema (JSON Schema)

{
  "additionalProperties": false,
  "properties": {
    "schema": {
      "maxLength": 63,
      "minLength": 1,
      "pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$",
      "type": "string"
    },
    "table": {
      "maxLength": 63,
      "minLength": 1,
      "pattern": "^[a-zA-Z_][a-zA-Z0-9_]*$",
      "type": "string"
    }
  },
  "required": [
    "schema",
    "table"
  ],
  "type": "object"
}

This server cannot be installed

Related Tools

describe_table
@melihbirim/pg-mcp
list_tables
@MadeByNando/mcp-postgres-server
list_tables
@Maxim2324/mcp-server-test
describe_table
@c0h1b4/mssql-mcp-server
list_schemas
@Maxim2324/mcp-server-test
get-table-info
@receptopalak/postgis-mcp

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

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