pgsql-mcp-server

pgsql-mcp-server

2
databases

PgSQL MCP Server enables interaction with PostgreSQL databases using the Model Context Protocol. It offers asynchronous, high-performance database operations with transactional safety.

Overview

This project leverages the FastMCP framework along with SQLAlchemy and asyncpg to provide asynchronous operations with PostgreSQL databases.

Key Features

  • Asynchronous implementation using asyncio and asyncpg.
  • Transactional safety for DDL, DML, and DCL operations.
  • Easy deployment through a command line interface.

Installation

Requires Python 3.8+. Installable via uvx.

Preview and Debugging

Utilize the MCP Inspector tool for testing and debugging, accessible through a web service.