Postgres-MCP-Server-With-SSE-Transport

Postgres-MCP-Server-With-SSE-Transport

0
databasesai_chatbotdeveloper_tools

The MCP Server is designed to facilitate flexible AI model integration with secure configuration management and PostgreSQL support. It leverages communication transports like SSE and offers extensibility for tool registration and AI provider configuration.

MCP (Model Context Protocol) Server

Key Features

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

Prerequisites

  • Python 3.10+
  • PostgreSQL
  • API access to AI providers (Anthropic, Google)

Installation

  1. Clone the repository.
  2. Create a virtual environment.
  3. Install dependencies.
  4. Configure environment variables.

Supported AI Providers

  • Anthropic (Claude models)
  • Google (Gemini models)

Tools and Endpoints

  • Available Tools: Retrieve database tables
  • Endpoints: /sse for Server-Sent Events

Extending the Framework

  • Add new tools via decorators
  • Configure AI providers in lm_config.py