Skip to main content
Glama
deenesjakoruzh
wisrovi

wpostgresql-mcp

by wisrovi
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Hybrid

wpostgresql-mcp

MCP Server for WPostgreSQL Architecting — teaches AI agents how to build high-performance PostgreSQL-backed systems with the wpostgresql library.

Features

  • 10 Architect Tools: Blueprints, manual, catalog search, scaffolding, connection validation, pattern generation

  • 20 Offline Patterns: All core wpostgresql features cataloged with module references

  • Scaffolding Generator: Deploys full project structure with config, models, repositories, migrations, main.py

  • Live Connection Validation: Tests PostgreSQL connectivity via psycopg 3 and returns health status

  • Pattern-based Generation: Generates starter projects from catalog patterns

Related MCP server: PostgreSQL MCP Server

Installation

# Clone and install
cd wpostgresql-mcp
pip install -e .

Or use the installer:

chmod +x installer.sh
./installer.sh

Quick Start

# Run the MCP server in stdio mode (for agent integration)
wpostgresql-mcp run

# Get configuration for your AI agent
wpostgresql-mcp config

# Start as background SSE server
wpostgresql-mcp start

Available Tools

Tool

Description

get_wpostgresql_architect_blueprints

Complete CRUD, async, batch, transaction, pool, sync, query builder, SQLite backup (wsqlite) examples

get_wpostgresql_architect_manual

Expert rules, module map, data structure selection guide

search_wpostgresql_pattern

Search 20+ PostgreSQL patterns in official/community catalogs

deploy_wpostgresql_scaffolding

Generate full project structure with config/models/repos/migrations

validate_postgresql_connection

Live health check against a running PostgreSQL instance

generate_from_pattern

Generate project + example from a specific catalog pattern

Agent Integration

Gemini CLI

gemini mcp add wpostgresql-mcp python3 -m wpostgresql_mcp.server run

Claude Desktop / Cursor

{
  "mcpServers": {
    "wpostgresql-mcp": {
      "command": "python3",
      "args": ["-m", "wpostgresql_mcp.server", "run"]
    }
  }
}

OpenCode

Add to .opencode/config.json:

{
  "mcpServers": {
    "wpostgresql-mcp": {
      "command": "python3",
      "args": ["-m", "wpostgresql_mcp.server", "run"]
    }
  }
}

Commands

Command

Description

wpostgresql-mcp run

Run in stdio mode (default)

wpostgresql-mcp run-sse

Run in SSE mode

wpostgresql-mcp start

Start as background SSE server

wpostgresql-mcp stop

Stop background server

wpostgresql-mcp config

Print/save JSON configuration

wpostgresql-mcp help

Show help

Generated by WPostgreSQL MCP by wisrovi

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityMaintained
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • query-executor

    Nitesh-Nandan
    F
    license
    A
    quality
    D
    maintenance
    Enables AI agents to read and optionally write to PostgreSQL databases through a multi-project setup with schema inspection, query execution, and performance analysis tools.
    5
    -

  • mcp-postgres

    mgcrea
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables AI agents to query and explore PostgreSQL databases with tools for executing SQL queries, listing tables, and describing table structures.
    MIT

  • pgops-mcp

    arzharch
    A
    license
    Not graded
    quality
    A
    maintenance
    Enables AI agents to safely and audibly operate PostgreSQL databases and their Docker environments, offering schema inspection, guarded queries, migrations, performance diagnosis, and container management tools.
    57 PyPI
    MIT