PostgreSQL MCP Server Python

Example Use Cases

• 1

  Interact with PostgreSQL databases using a Python-based MCP server.

• 2

  That require basic toolsets and prompt handling for PostgreSQL without authentication.

• 3

  Migrate from legacy Python MCP implementations to modern TypeScript versions.

Description

This repository contains the legacy Python implementation of the PostgreSQL MCP Server, which facilitates interaction with PostgreSQL through a set of tools and prompts. It supports basic features and stdio transport but lacks authentication. The project has been fully rewritten in TypeScript with enhanced capabilities, including OAuth 2.1 authentication, HTTP/SSE transport, and more tools and features. Users are encouraged to migrate to the new version for improved functionality and security.