PostgreSQL Ops

Name: PostgreSQL Ops
Availability: InStock
Author: call518

by call518

Professional MCP server for PostgreSQL operations, monitoring, and performance analysis.

0 stars

1 views

Works in:claude

Exposes:Tools

View on GitHub

What it does

PostgreSQL Ops provides a comprehensive suite of tools for database administrators and developers to monitor, diagnose, and manage PostgreSQL databases. It specializes in performance analysis, table bloat detection, and schema introspection without requiring external extensions.

Tools

analyze_performance: Identifies slow queries and performance bottlenecks.
detect_table_bloat: Checks for unused space and fragmentation in tables.
monitor_autovacuum: Tracks autovacuum progress and health.
inspect_schema: Provides detailed metadata about database structures.
manage_database: Executes administrative tasks and management queries.

Installation

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "postgresql-ops": {
      "command": "python",
      "args": ["-m", "mcp_postgresql_ops"],
      "env": {
        "DATABASE_URL": "postgresql://user:pass@host:port/db"
      }
    }
  }
}