PostgreSQL

Official

Read-only database access with schema inspection

About PostgreSQL MCP Server

PostgreSQL is an MCP server in the Data category. It exposes tools, resources to connected AI applications, enabling them to interact with postgresql capabilities through the standardized Model Context Protocol.

Features

Tools
Resources

Category

Data
Getting Started

To use the PostgreSQL MCP server in your AI application, follow these steps:

  1. Install the MCP client SDK for your platform
  2. Connect to the PostgreSQL MCP server
  3. Authenticate with your PostgreSQL credentials
  4. Start using the tools, resources, and prompts provided by the server

Example Code


// Connect to the PostgreSQL MCP server
const server = await mcp.connect("postgresql");

// List available tools
const tools = await server.tools.list();

// List available resources
const resources = await server.resources.list();

// List available prompts
const prompts = await server.prompts.list();
                      
Installation

npm

npm install @mcp/server-postgresql

pip

pip install mcp-server-postgresql
Compatible With
Claude Desktop
Cursor
Windsurf
Zed
Any MCP-compatible client