Skip to main content
Glama
deenesjakoruzh
wisrovi

wpostgresql-mcp

by wisrovi
OverviewSchemaRelated ServersScoreDiscussions
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: mcp-postgres

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 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 installed

A
license - permissive license
Not graded
quality - not tested
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • mcp-postgres

    Filipescordeiro2
    F
    license
    Not graded
    quality
    D
    maintenance
    Enables AI agents to execute SQL queries and introspect PostgreSQL schemas, tables, and indexes with read-only safety by default. Supports optional write operations and works with Claude, LangChain, and other agents via stdio or HTTP transports.

  • mcp-postgres

    divinedev111
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables AI agents to interact with PostgreSQL databases through schema intelligence, query execution, and DBA tooling including index analysis and health monitoring. Features configurable access levels and audit logging for secure database operations.
    539
    MIT

  • query-executor

    Nitesh-Nandan
    F
    license
    A
    quality
    C
    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

View all related MCP servers

Related MCP Connectors

View all MCP Connectors

Latest Blog Posts

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/wisrovi/wpostgresql-mcp'

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