MCP (Model Context Protocol) Server

Name: MCP (Model Context Protocol) Server
Author: VajraM-dev

@VajraM-dev

リポジトリ

MCP (Model Context Protocol) Server について

概要はまだありません

基本情報

カテゴリ

データベース

ランタイム

python

トランスポート

stdio

公開者

VajraM-dev

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "Postgres-MCP-Server-With-SSE-Transport": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        "venv"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP (Model Context Protocol) Server?

A Python-based server that integrates PostgreSQL databases with AI providers (Anthropic, Google) using the Model Context Protocol, supporting flexible communication transports (SSE or stdio).

How to use MCP (Model Context Protocol) Server?

Clone the repository, create a Python virtual environment, install dependencies, configure environment by copying .env.example to .env.dev and filling in database and API credentials, then run python server.py for the server and python client.py for client interaction.

Key features of MCP (Model Context Protocol) Server

Secure configuration management
PostgreSQL database integration
Multi-provider AI model support
Flexible communication transport
Extensible tool registration

Use cases of MCP (Model Context Protocol) Server

Retrieve database table listings via AI prompts
Extend server with custom tool functions using decorators
Interact with PostgreSQL through a client script

FAQ from MCP (Model Context Protocol) Server

What are the prerequisites?

Python 3.10+, a PostgreSQL instance, and API access to Anthropic and/or Google AI providers.

How do I install and configure the server?

Clone the repo, create a virtual environment, run pip install -r requirements.txt, copy .env.example to .env.dev, and fill in database credentials, API keys, and transport settings.

Which AI providers are supported?

Anthropic (Claude models) and Google (Gemini models). The default provider is set via the USE_PROVIDER config.

What transport options are available?

The server supports both SSE (/sse endpoint) and stdio transports, configured via the TRANSPORT environment variable.

How can I add a new tool?

Use the @app.tool() decorator above a function definition; the function will be registered as a custom tool.

「データベース」の他のコンテンツ

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245