PostgreSQL
A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Components
Tools
- query
- Execute read-only SQL queries against the connected database
- Input:
sql
(string): The SQL query to execute - All queries are executed within a READ ONLY transaction
Resources
The server provides schema information for each table in the database:
- Table Schemas (
postgres://<host>/<table>/schema
)- JSON schema information for each table
- Includes column names and data types
- Automatically discovered from database metadata
Usage with Claude Desktop
To use this server with the Claude Desktop app, add the following configuration to the “mcpServers” section of your claude_desktop_config.json
:
Docker
- when running docker on macos, use host.docker.internal if the server is running on the host network (eg localhost)
- username/password can be added to the postgresql url with
postgresql://user:password@host:port/db-name
{
"mcpServers": {
"postgres": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host.docker.internal:5432/mydb"]
}
}
}
NPX
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://localhost/mydb"
]
}
}
}
Replace /mydb
with your database name.
Building
Docker:
docker build -t mcp/postgres -f src/postgres/Dockerfile .
License
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
PostgreSQL MCP Server
Project Details
- hsinyuyen/my-postgres-mcp
- @modelcontextprotocol/server-postgres
- Last Updated: 4/1/2025
Recomended MCP Servers
SSAFY 학생들을 위한 프로젝트 포트폴리오 및 면접 준비 도우미 서버
A mcp server provide infomation from pkg.go.dev. For all golang programmers
An MCP server that uses AppleScript to send iMessages and manage contacts.
Prevents outdated Rust code suggestions from AI assistants. This MCP server fetches current crate docs, uses embeddings/LLMs,...
Investidor10 MCP Server: A Model Context Protocol (MCP) server for interacting with the Status Invest API. Provides tools...
知乎自动发文章MCP服务,一种用于知乎发文章的模型上下文协议(MCP)服务器,使用者可以通过该服务与大模型自动生成文章并在知乎发文章。基于selenium和ChromeDriver实现自动发文章。
An MCP server that provides KOSPI/KOSDAQ stock data using FastMCP
A free SEO tool MCP (Model Control Protocol) service based on Ahrefs data. Includes features such as backlinks,...
Official Firecrawl MCP Server - Adds powerful web scraping to Cursor, Claude and any other LLM clients.
Use your Databutton app APIs as tools in other agents with MCP