PostgreSQL MCP Server

AGPL 3.0

438

Overview InspectNew Schema Related Servers Reviews Score

pg_analyze_database

Analyze PostgreSQL database configuration, performance, and security to optimize and troubleshoot issues. Specify connection string and analysis type for targeted insights.

Instructions

Analyze PostgreSQL database configuration and performance

Input Schema

Name	Required	Description	Default
`analysisType`	No	Type of analysis to perform
`connectionString`	No	PostgreSQL connection string (optional if POSTGRES_CONNECTION_STRING environment variable or --connection-string CLI option is set)

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "analysisType": {
      "description": "Type of analysis to perform",
      "enum": [
        "configuration",
        "performance",
        "security"
      ],
      "type": "string"
    },
    "connectionString": {
      "description": "PostgreSQL connection string (optional if POSTGRES_CONNECTION_STRING environment variable or --connection-string CLI option is set)",
      "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/HenkDz/postgresql-mcp-server'

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