mcp server

postgres-mcp

PostgreSQL Model Context Protocol Server - A read-only PostgreSQL MCP server implementation

daitasu/postgres-mcpcommunitylistedunreviewed

Use tool

Set up

Runs on your computer. Pick your agent and operating system.

Before you start

Node.js 20 or newer

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "daitasu-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@daitasu/postgres-mcp"
      ]
    }
  }
}

same format Cursor, GitHub Copilot CLI, Junie, JetBrains AI Assistant, Augment (Auggie CLI), Factory Droid, Kiro, Devin CLI +12

Values in angle brackets are placeholders. Restart Claude Desktop after editing its config.Claude Desktop docs

README

synced Oct 24, 2026

PostgreSQL MCP Server

Implementation of PostgreSQL Model Context Protocol (MCP) server. Enables read-only SQL query execution and database schema information retrieval.

Features

query: Execute read-only SQL queries
listTables: Get a list of tables in the database
getTableSchema: Get schema information for a specified table

Installation

From npm

npm install -g @daitasu/postgres-mcp

From source

# Clone the repository
git clone https://github.com/daitasu/postgres-mcp.git
cd postgres-mcp

# Install dependencies
pnpm install

# Build
pnpm run build

Configuration

Using npx (Recommended)

Add to your Claude Desktop or MCP client configuration:

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["@daitasu/postgres-mcp", "postgresql://user:password@localhost:5432/database"]
    }
  }
}

Using global installation

If you installed globally:

{
  "mcpServers": {
    "postgres": {
      "command": "postgres-mcp",
      "args": ["postgresql://user:password@localhost:5432/database"]
    }
  }
}

Using local installation

{
  "mcpServers": {
    "postgres": {
      "command": "node",
      "args": ["/path/to/postgres-mcp/dist/index.js", "postgresql://user:password@localhost:5432/database"]
    }
  }
}

Command-line execution

# Using npx (no installation required)
npx @daitasu/postgres-mcp postgresql://user:password@localhost:5432/database

# Using global installation
postgres-mcp postgresql://user:password@localhost:5432/database

# Using node directly
node dist/index.js postgresql://user:password@localhost:5432/database

Tool Usage

1. query - Execute SQL queries

Input: { "sql": "SELECT * FROM users LIMIT 10" }
Output: Query results (JSON format)

2. listTables - Get table list

Input: {}
Output: List of table names

3. getTableSchema - Get table schema

Input: { "tableName": "users" }
Output: List of column names and data types

Security

All queries are executed within READ ONLY transactions
Data modification is not possible
Automatically rolled back

Development

# Development mode
pnpm run dev

# Tests
pnpm test

# Type checking
pnpm run typecheck

# Lint
pnpm run lint

License

MIT