postgres-mcp-server
Enterprise PostgreSQL MCP server with 63 tools, 10 resources, 10 prompts for AI-native operations
MCP 服务配置
复制以下 JSON 到 OPClaw 或其他 MCP 客户端的配置文件中即可使用
{
"mcpServers": {
"docker.io/writenotenow/postgres-mcp-enhanced": {
"args": [
"run",
"-i",
"--rm",
"docker.io/writenotenow/postgres-mcp-enhanced:v1.2.0"
],
"command": "docker"
}
}
}
可用工具 (5 个)
该服务在 MCP 协议中暴露的工具,AI 可按需调用
tavily_search 14 个参数 需填 1 项
Search the web for current information on any topic. Use for news, facts, or data beyond your knowledge cutoff. Returns snippets and source URLs.
必填参数:query
tavily_extract 6 个参数 需填 1 项
Extract content from URLs. Returns raw page content in markdown or text format.
必填参数:urls
tavily_crawl 11 个参数 需填 1 项
Crawl a website starting from a URL. Extracts content from pages with configurable depth and breadth.
必填参数:url
tavily_map 8 个参数 需填 1 项
Map a website's structure. Returns a list of URLs found starting from the base URL.
必填参数:url
tavily_research 2 个参数 需填 1 项
Perform comprehensive research on a given topic or question. Use this tool when you need to gather information from multiple sources to answer a question or complete a task. Returns a detailed response based on the research findings.
必填参数:input
服务介绍
⚠️ DEPRECATED - PostgreSQL MCP Server (Python)
This repository has been deprecated. Please use the new TypeScript version instead.
# 🔄 Migration
The PostgreSQL MCP Server has been completely rewritten in TypeScript with significant improvements:
| | Old (Python) | New (TypeScript) |
|- --|- --|- --|
| Tools | 63 | 203 |
| Resources | 10 | 20 |
| Prompts | 10 | 19 |
| Transport | stdio only | stdio + HTTP/SSE |
| Auth | None | OAuth 2.1 |
| Features | Basic | Code Mode, Tool Filtering |
# 📦 New Repository
GitHub: https://github.com/neverinfamous/postgresql-mcp
Docker:
docker pull writenotenow/postgres-mcp:latest
npm:
npm install -g @neverinfamous/postgres-mcp
MCP Registry: io.github.neverinfamous/postgres-mcp
# ⚠️ Notice
- This repository will no longer receive updates
- Security patches will NOT be applied
- Please migrate to the new TypeScript version
For documentation and support, visit: https://github.com/neverinfamous/postgresql-mcp
Last Python version: v1.2.0 (December 2025)