MCP Configs2026年3月29日·1 分钟阅读

PostgreSQL MCP Server — Database Queries for AI

MCP server for PostgreSQL database access. Run read-only SQL queries, inspect schemas, list tables, and analyze data directly from Claude Code or Cursor.

TO
TokRepo精选 · Community
快速使用

先拿来用,再决定要不要深挖

这里应该同时让用户和 Agent 知道第一步该复制什么、安装什么、落到哪里。

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

介绍

Connect your AI coding tools directly to PostgreSQL databases. Inspect schemas, run queries, analyze data, and generate reports — all through natural language. Read-only by default for safety.

Best for: Data analysis, schema exploration, query debugging, report generation Works with: Claude Code, Cursor, Gemini CLI


Capabilities

  • Schema inspection: List tables, columns, types, constraints, indexes
  • SQL queries: Run SELECT queries with results returned as structured data
  • Data analysis: Ask questions about your data in natural language
  • Query building: Describe what you need, get optimized SQL

Safety

  • Read-only mode by default (SELECT only)
  • Connection string passed as argument, not stored
  • No DDL operations unless explicitly enabled

🙏

来源与感谢

Created by Anthropic. Licensed under MIT. modelcontextprotocol/servers

相关资产