Provides Docker support for containerized deployment through Docker Compose, simplifying installation and environment setup.

Supports environment variable configuration via .env files for storing database connection details and API keys.

Provides tools for connecting to, querying, and exploring PostgreSQL databases, including schema discovery, query execution, and analysis of execution plans.

Uses YAML for defining extension context information, providing detailed knowledge about PostgreSQL extensions like PostGIS and pgvector.

1. Click on "Install Server".

2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.

3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@pg-mcp show me the schema for the users table"

That's it! The server will respond to your query, and you can continue using it as needed.

Here is a step-by-step guide with screenshots.