PostgreSQL

Created By

modelcontextprotocola year ago

Read-only database access with schema inspection

Overview

what is PostgreSQL?

PostgreSQL is a Model Context Protocol server providing read-only access to PostgreSQL databases, allowing for schema inspection and execution of read-only queries.

how to use PostgreSQL?

To use PostgreSQL, configure it within the Claude Desktop app by adding the necessary parameters to the "mcpServers" section of the `claude_desktop_config.json` file. Replace the database name in the configuration with your specific database.

key features of PostgreSQL?

Execute read-only SQL queries within a read-only transaction.
Access detailed schema information for each table, including column names and data types.
Automatically discovers schemas from database metadata.

use cases of PostgreSQL?

Inspecting database schemas before performing extensive data analysis.
Running read-only queries to generate reports without altering database states.
Integration with LLMs for database-related tasks in applications.

FAQ from PostgreSQL?

Is PostgreSQL suitable for writing data?

No! PostgreSQL provides read-only access, which means data cannot be modified through this server.

Can I use PostgreSQL with other apps?

Yes! While designed for Claude Desktop, PostgreSQL can be integrated into other applications that can call its endpoints.

How do I get schema information for a table?

Schema information is automatically discovered and can be accessed via the provided schema URL endpoint.

Server Config

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/mydb"
      ]
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

Amap Maps高德地图官方 MCP Server

Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors

Serper MCP ServerA Serper MCP Server

TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

WindsurfThe new purpose-built IDE to harness magic

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs