postgresql-mcp-server

tarsislimadev/postgresql-mcp-server

3.2

If you are the rightful owner of postgresql-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 dayong@mcphub.com.

The PostgreSQL MCP Server allows users to execute simple read-only SQL queries against a PostgreSQL database using the Model Context Protocol (MCP) over HTTP.

Tools
1
Resources
0
Prompts
0

PostgreSQL MCP Server

A simple PostgreSQL MCP server

Use with an MCP client

Configuration via .mcp.json

Create a .mcp.json file in your project root or MCP client configuration directory to connect to this PostgreSQL MCP server:

{
  "mcpServers": {
    "postgresql": {
      "command": "npx",
      "args": [ "-y", "@tarsislimadev/postgresql-mcp-server" ],
      "env": {
        "POSTGRES_URL": "postgresql://psql:psql@localhost:5432/psql"
      }
    }
  }
}

Start your PostgreSQL server with Docker

docker run --rm -d \
  --network host \
  --name psql-1 \
  -e POSTGRES_DB=psql \
  -e POSTGRES_USER=psql \
  -e POSTGRES_PASSWORD=psql \
  postgres:alpine

License