PostgreSQL MCP Server

connect_database

Establish a connection to a PostgreSQL database by specifying host, port, database name, username, password, and SSL preferences for secure and efficient data interactions.

Instructions

Connect to a PostgreSQL database

Input Schema

Name	Required	Description
`database`	Yes	Database name
`host`	No	Database host (default: localhost)
`password`	No	Database password
`port`	No	Database port (default: 5432)
`ssl`	No	Use SSL connection (default: false)
`username`	Yes	Database username

Input Schema (JSON Schema)

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false,
  "properties": {
    "database": {
      "description": "Database name",
      "type": "string"
    },
    "host": {
      "description": "Database host (default: localhost)",
      "type": "string"
    },
    "password": {
      "description": "Database password",
      "type": "string"
    },
    "port": {
      "description": "Database port (default: 5432)",
      "type": "number"
    },
    "ssl": {
      "description": "Use SSL connection (default: false)",
      "type": "boolean"
    },
    "username": {
      "description": "Database username",
      "type": "string"
    }
  },
  "required": [
    "database",
    "username"
  ],
  "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/melihbirim/pg-mcp'

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