Pixelworlds/postgres-multi-mcp-server

3.1

If you are the rightful owner of postgres-multi-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol server that provides both read and write access to PostgreSQL databases across multiple environments.

Tools

Functions exposed to the LLM to take actions

query

Execute read-only SQL queries against the connected database

execute

Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE)

insert

Insert a new record into a table

update

Update records in a table

delete

Delete records from a table

createTable

Create a new table with specified columns and constraints

createFunction

Create a PostgreSQL function/procedure

createTrigger

Create a trigger on a table

createIndex

Create an index on a table

alterTable

Alter a table structure

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

Pixelworlds

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/Pixelworlds/postgres-multi-mcp-server

License

Other

Last publish date

2025-06-21

Last update date

2025-06-21

Server configs

in claude desktop

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": [
        "dist/index.js",
        "{\"environments\":[{\"name\":\"production\",\"displayName\":\"Production\",\"database\":{\"type\":\"postgres\",\"host\":\"prod-db.example.com\",\"port\":5432,\"database\":\"prod_app\",\"username\":\"prod_user\",\"password\":\"prod_password\",\"ssl\":true,\"poolSize\":10}},{\"name\":\"staging\",\"displayName\":\"Staging\",\"database\":{\"type\":\"postgres\",\"host\":\"staging-db.example.com\",\"port\":5432,\"database\":\"staging_app\",\"username\":\"staging_user\",\"password\":\"staging_password\",\"ssl\":true,\"poolSize\":5}},{\"name\":\"development\",\"displayName\":\"Development\",\"database\":{\"type\":\"postgres\",\"connectionString\":\"postgresql://dev_user:dev_password@localhost:5432/myapp_dev\",\"poolSize\":2}}]}"
      ]
    }
  }
}