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"
}