Postgres MCP Server

@RonHouben

Repository

Basic information

About Postgres MCP Server

MCP Server for postgres

Postgres MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Postgres MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is postgres-mcp-server?

A PostgreSQL Model Context Protocol server that lets an LLM interact with a local database. It is experimental and not intended for real databases.

How to use postgres-mcp-server?

Install Node.js, run npm install, and set the environment variables DATABASE_NAME, DATABASE_USER, DATABASE_PASSWORD, and DATABASE_SCHEMA_NAME. A VSCode configuration snippet is provided to integrate the server via stdio.

Key features of postgres-mcp-server

Experimental PostgreSQL MCP server for local databases
Connects using environment variable configuration
Supports read and write SQL queries
Runs via npm start with stdio transport
Integrates with VSCode chat’s MCP discovery

Use cases of postgres-mcp-server

Letting an LLM query a local development database
Experimenting with database interactions in a safe environment

Frequently asked questions

Is postgres-mcp-server safe for production databases?

No, it is experimental; do not use it on real databases and be careful with write queries.

What are the prerequisites to run postgres-mcp-server?

You need Node.js installed and must run `npm install` to install dependencies.

What environment variables are required?

`DATABASE_NAME`, `DATABASE_USER`, `DATABASE_PASSWORD`, and `DATABASE_SCHEMA_NAME` (typically `public`).

How do I configure postgres-mcp-server in VSCode?

Add a configuration block in your `settings.json` with the command `npm`, type `stdio`, args `["start", "--prefix", "/path/to/code/postgres-mcp-server"]`, and set the required environment variables.