postgres-mcp
Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
File Explorer
Download Latest Version (.zip)- build.yml
- docker-build-dockerhub.yml
- postgres-mcp-pro.png
- movie-app.md
- __init__.py
- buffer_health_calc.py
- connection_health_calc.py
- constraint_health_calc.py
- database_health.py
- index_health_calc.py
- init.sql
- replication_calc.py
- sequence_health_calc.py
- vacuum_health_calc.py
- __init__.py
- explain_plan.py
- README.md
- dta_calc.py
- index_opt_base.py
- llm_opt.py
- presentation.py
- __init__.py
- bind_params.py
- extension_utils.py
- index.py
- safe_sql.py
- sql_driver.py
- __init__.py
- top_queries_calc.py
- __init__.py
- artifacts.py
- server.py
- test_dta_calc_integration.py
- test_top_queries_integration.py
- test_database_health_tool.py
- test_sequence_health_calc.py
- test_explain_plan.py
- test_explain_plan_real_db.py
- test_server.py
- test_server_integration.py
- test_dta_calc.py
- test_db_conn_pool.py
- test_obfuscate_password.py
- test_readonly_enforcement.py
- test_safe_sql.py
- test_sql_driver.py
- test_top_queries_calc.py
- test_access_mode.py
- test_transport.py
- conftest.py
- Dockerfile.postgres-hypopg
- README.md
- utils.py
- .gitignore
- .python-version
- devenv.lock
- devenv.nix
- devenv.yaml
- docker-entrypoint.sh
- Dockerfile
- justfile
- LICENSE
- pyproject.toml
- README.md
- smithery.yaml
- uv.lock
# Installation Guide
git clone https://github.com/crystaldba/postgres-mcp
Downloads the entire project code from GitHub to your computer.
cd postgres-mcp
Moves into the project folder you just downloaded.
2. Official Install Script
Easy Recommended- pipx Installs Python-based CLI tools into isolated environments.
pipx install postgres-mcp
Installs the CLI tool into an isolated environment via pipx.
curl -sSL https://astral.sh/uv/install.sh | sh
Downloads and runs the official install script in one line β this handles the full setup automatically.
Pulled directly from this repo's README.
3. Docker
Easy- Git Needed to download the project code from GitHub.
- Docker Desktop Needed to build and run containers. Install it and keep it running in the background.
docker pull crystaldba/postgres-mcp
Type this command into your terminal and run it.
"command": "docker",
Type this command into your terminal and run it.
docker run -p 8000:8000 \
Runs the built image as an actual container.
Pulled directly from this repo's README.
4. Python
Easyuv pip install postgres-mcp
Installs the Python libraries listed in requirements.txt (or similar).
uv pip install -e .
Installs the Python libraries listed in requirements.txt (or similar).
Pulled directly from this repo's README.