MCP Servers

wpostgresql-mcp

Enables AI agents to architect and scaffold high-performance PostgreSQL-backed systems using the wpostgresql library, with tools for pattern search, connection validation, and project generation.

README

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

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

Recommended Servers

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official

Featured

TypeScript

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official

Featured

Local

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official

Featured

Python

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official

Featured

TypeScript

Neon Database

MCP server for interacting with Neon Management API and databases

Official

Featured

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official

Featured

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official

Featured

E2B

Using MCP to run code via e2b.

Official

Featured