msrashed-postgresql-mcp-server

# PostgreSQL MCP Server A read-only Model Context Protocol (MCP) server for [PostgreSQL](https://www.postgresql.org/), enabling AI agents like software engineers to safely inspect databases, analyze performance, and query data without risking modifications. [](https://www.python.org/downloads/) [](https://github.com/anthropics/mcp) [](https://opensource.org/licenses/MIT) ## Features - **Read-Only Safety**: All operations are read-only. No INSERT, UPDATE, DELETE, DROP, or ALTER operations - **Comprehensive Discovery**: List databases, schemas, tables, views, columns, indexes, and constraints - **Query Execution**: Execute SELECT queries and EXPLAIN plans safely - **Performance Analysis**: Find missing indexes, unused indexes, bloated tables, and slow queries - **Monitoring Tools**: View connections, locks, replication lag, and cache hit ratios - **Type-Safe**: Full type hints for Python 3.12+ - **Dual Interface**: Use as MCP server for AI agents or CLI tool for direct database access ## Installation ### Using uv (Recommended) ```bash # Install from PyPI uv pip install msrashed-postgresql-mcp-server # Or install with pipx for CLI usage pipx install msrashed-postgresql-mcp-server ``` ### Using pip ```bash pip install msrashed-postgresql-mcp-server ``` ## Quick Start ### 1. Set Environment Variables ```bash # Option 1: Full connection URI export POSTGRES_URI="postgresql://user:password@localhost:5432/mydb" # Option 2: Individual parameters export POSTGRES_HOST="localhost" export POSTGRES_PORT="5432" export POSTGRES_DATABASE="mydb" export POSTGRES_USER="postgres" export POSTGRES_PASSWORD="secret" export POSTGRES_SSLMODE="prefer" # or disable, require, verify-full ``` ### 2. Test Connection ```bash postgresql-mcp-server check --uri postgresql://localhost/mydb ``` …