Postgres MCP Server

schemas

Manage PostgreSQL database schemas by listing, creating, dropping schemas, and handling permissions to organize database structure effectively.

Instructions

Schema management: list, create, drop schemas and manage schema permissions

Input Schema

Name	Required	Description
`action`	Yes	Action: list (all schemas), create (new schema), drop (remove schema), permissions (schema permissions)
`options`	No	Action-specific options
`owner`	No	Schema owner (for create action)
`schemaName`	No	Schema name (required for create, drop, permissions)

Input Schema (JSON Schema)

{
  "properties": {
    "action": {
      "description": "Action: list (all schemas), create (new schema), drop (remove schema), permissions (schema permissions)",
      "enum": [
        "list",
        "create",
        "drop",
        "permissions"
      ],
      "type": "string"
    },
    "options": {
      "description": "Action-specific options",
      "properties": {
        "cascade": {
          "default": false,
          "type": "boolean"
        },
        "ifExists": {
          "default": true,
          "type": "boolean"
        },
        "ifNotExists": {
          "default": false,
          "type": "boolean"
        }
      },
      "type": "object"
    },
    "owner": {
      "description": "Schema owner (for create action)",
      "type": "string"
    },
    "schemaName": {
      "description": "Schema name (required for create, drop, permissions)",
      "type": "string"
    }
  },
  "required": [
    "action"
  ],
  "type": "object"
}

This server cannot be installed

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

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