Skip to main content
Glama
deenesjakoruzh
wisrovi

wpostgresql-mcp

by wisrovi
OverviewSchemaRelated ServersScoreDiscussions
Python
Hybrid

wpostgresql-mcp

用于 WPostgreSQL 架构设计的 MCP 服务器——教 AI 代理如何使用 wpostgresql 库构建高性能的 PostgreSQL 后端系统。

功能特性

  • 10 个架构工具：蓝图、手册、目录搜索、脚手架、连接验证、模式生成

  • 20 个离线模式：所有核心 wpostgresql 功能均附带模块引用目录

  • 脚手架生成器：部署完整的项目结构，包含配置、模型、仓库、迁移、main.py

  • 实时连接验证：通过 psycopg 3 测试 PostgreSQL 连接并返回健康状态

  • 基于模式的生成：从目录模式生成入门项目

Related MCP server: mcp-postgres

安装

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

或使用安装程序：

chmod +x installer.sh
./installer.sh

快速开始

# 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

可用工具

工具

描述

get_wpostgresql_architect_blueprints

完整的 CRUD、异步、批量、事务、连接池、同步、查询构建器示例

get_wpostgresql_architect_manual

专家规则、模块映射、数据结构选择指南

search_wpostgresql_pattern

在官方/社区目录中搜索 20+ 个 PostgreSQL 模式

deploy_wpostgresql_scaffolding

生成包含配置/模型/仓库/迁移的完整项目结构

validate_postgresql_connection

对正在运行的 PostgreSQL 实例进行实时健康检查

generate_from_pattern

从特定目录模式生成项目 + 示例

代理集成

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

添加到 .opencode/config.json：

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

命令

命令

描述

wpostgresql-mcp run

以 stdio 模式运行（默认）

wpostgresql-mcp run-sse

以 SSE 模式运行

wpostgresql-mcp start

作为后台 SSE 服务器启动

wpostgresql-mcp stop

停止后台服务器

wpostgresql-mcp config

打印/保存 JSON 配置

wpostgresql-mcp help

显示帮助

由 wisrovi 的 WPostgreSQL MCP 生成

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