MCP.so
登录

MCP PostgreSQL Server

@antonorlov

代码仓库

关于 MCP PostgreSQL Server

MCP PostgreSQL Server

#postgres#database#mcp-server

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

antonorlov

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "postgres": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-server"
      ],
      "env": {
        "PG_HOST": "your_host",
        "PG_PORT": "5432",
        "PG_USER": "your_user",
        "PG_PASSWORD": "your_password",
        "PG_DATABASE": "your_database"
      }
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP PostgreSQL Server?

A Model Context Protocol server that enables AI models to interact with PostgreSQL databases through a standardized interface. It provides database operations such as connecting, querying, executing statements, and listing schemas and tables.

How to use MCP PostgreSQL Server?

Install via npm (npm install mcp-postgres-server) or run directly with npx mcp-postgres-server. Configure environment variables for database credentials (host, port, user, password, database). Then use the available MCP tools: connect_db, query, execute, list_schemas, list_tables, describe_table.

Key features of MCP PostgreSQL Server

  • Secure connection handling with automatic cleanup
  • Prepared statement support to prevent SQL injection
  • Supports PostgreSQL-style ($1, $2) and MySQL-style (?) parameter placeholders
  • Comprehensive error handling with detailed messages
  • TypeScript support
  • Automatic connection management
  • Multi-schema support for database operations

Use cases of MCP PostgreSQL Server

  • Querying data from PostgreSQL tables using SELECT statements
  • Executing INSERT, UPDATE, and DELETE operations securely
  • Exploring database structure by listing schemas, tables, and describing columns
  • Integrating AI models with existing PostgreSQL databases for data retrieval

FAQ from MCP PostgreSQL Server

How does the server prevent SQL injection?

It uses prepared statements for all queries, securely handling parameterized inputs to avoid injection.

What parameter placeholder styles are supported?

Both PostgreSQL-style ($1, $2) and MySQL

评论

数据库 分类下的更多 MCP 服务器

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245