Postgres MCP Server

security

Manage PostgreSQL database security by configuring SSL, authentication methods, encryption settings, auditing logs, and row-level security policies.

Instructions

Database security management: SSL, authentication, encryption, auditing

Input Schema

Name	Required	Description
`audit_type`	No	Type of audit information
`operation`	Yes	Security operation to perform
`policy_expression`	No	RLS policy expression
`policy_name`	No	RLS policy name
`table`	No	Table name for RLS operations

Input Schema (JSON Schema)

{
  "properties": {
    "audit_type": {
      "description": "Type of audit information",
      "enum": [
        "connections",
        "queries",
        "ddl",
        "dml",
        "errors"
      ],
      "type": "string"
    },
    "operation": {
      "description": "Security operation to perform",
      "enum": [
        "check_ssl",
        "list_auth_methods",
        "check_encryption",
        "audit_log",
        "password_policy",
        "connection_limits",
        "session_security",
        "row_level_security",
        "column_encryption",
        "security_labels"
      ],
      "type": "string"
    },
    "policy_expression": {
      "description": "RLS policy expression",
      "type": "string"
    },
    "policy_name": {
      "description": "RLS policy name",
      "type": "string"
    },
    "table": {
      "description": "Table name for RLS operations",
      "type": "string"
    }
  },
  "required": [
    "operation"
  ],
  "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