S
syahiidkamil/mcp-postgres-full-access
Full access postgres mcp server
在 GitHub 查看 ↗链接已于 2026-11-12 核查 · HTTP 200 · 打开的是厂商自己的官网
安装与配置
- 复制上面的命令
- 粘成
claude_desktop_config.json里mcpServers的一项（本地服务器用 command + args，示例见 客户端接法） - 重启客户端
客户端配置（取自该仓库的安装命令）
{
"mcpServers": {
"syahiidkamil-mcp-postgres-full-access": {
"command": "npx",
"args": ["-y", "mcp-postgres-full-access", "postgresql://username:password@localhost:5432/database"]
}
}
}解析自我们于 2026-11-04 抓取的该仓库 README；我们未执行过。
command/args 来自仓库写明的安装命令；不确定时请以该项目 README 为准。
VS Code（.vscode/mcp.json —— 键名是 servers）
{
"servers": {
"syahiidkamil-mcp-postgres-full-access": {
"command": "npx",
"args": ["-y", "mcp-postgres-full-access", "postgresql://username:password@localhost:5432/database"]
}
}
}VS Code 顶层键是 <code>servers</code>，其余与上面那份相同。
Claude Code（命令行）
claude mcp add --transport stdio syahiidkamil-mcp-postgres-full-access -- npx -y mcp-postgres-full-access postgresql://username:password@localhost:5432/database
Claude Code 不收 JSON 文件，用这条命令直接加。
配置项的键名以你的客户端为准：客户端与 CLI
- 来源明细
- 收录自 abordage/awesome-mcp 榜单（我们从中收集的条目之一） · 条目类型：MCP 服务
- 收录与活跃
- 收录于 2026-11-05 · 最近见到 2026-11-14 · 共见到 10 次 · 被 10 个来源列出
- 评分构成
- 综合分 1,003 · 10 个来源 · mcp
- 安装
npx -y mcp-postgres-full-access postgresql://username:password@localhost:5432/database
常见问题（答案都来自我们的记录）
怎么安装？
该仓库给出的安装命令是
npx -y mcp-postgres-full-access postgresql://username:password@localhost:5432/database。我们的记录里它是仓库自己提供的；不保证在你的客户端上直接可用。它适合谁 / 用来做什么？
我们把它归在这些标签下: MCP 服务。标签来自条目自身，不是我们强加的分类。
谁维护它、还在更新吗？
我们收录于 2026-11-05；最近见到 2026-11-14。这里没有"官方认证"或"质量评级"——我们只记录来源与时间。
# PostgreSQL Full Access MCP Server
以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →
A powerful Model Context Protocol server providing full read-write access to PostgreSQL databases. Unlike the read-only official MCP PostgreSQL server, this enhanced implementation allows Large Language Models (LLMs) to both query and modify database content with proper transaction management and safety controls.
## Table of Contents
Features
Full Read-Write Access
Rich Schema Information
Advanced Safety Controls
Tools
executequery
executedmlddldcltcl
executemaintenance
executecommit
executerollback
listtables
describetable
Resources
Using with Claude Desktop
Claude Desktop Integration
Important: Using "Allow Once" for Safety
Environment Variables
Using Full Database Access with Claude
Security Considerations
Database User Permissions
Best Practices for Safe Usage
Docker
License
Comparison with Official PostgreSQL MCP Server
## 🌟 Features
### Full Read-Write Access
Safely execute DML operations (INSERT, UPDATE, DELETE)
Create, alter, and manage database objects with DDL
Transaction management with explicit commit
Safety timeouts and automatic rollback protection
### Rich Schema Information
Detailed column metadata (data types, descriptions, max length, nullability)
Primary key identification
Foreign key relationships
Index information with type and uniqueness flags
Table row count estimates
Table and column descriptions (when available)
### Advanced Safety Controls
SQL query classification (DQL, DML, DDL, DCL, TCL)
Enforced read-only execution for safe queries
All operations run in isolated transactions
Automatic transaction timeout monitoring
Configurable safety limits
Two-step transaction commit process with explicit user confirmation
## 🔧 Tools
executequery
Execute read-only SQL queries (SELECT statements)
Input: sql (string): The SQL query to execute
All queries are executed within a READ ONLY transaction
Results include execution time metrics and field information
executedmlddldcltcl
Execute data modification operations (INSERT, UPDATE, DELETE) or schema changes (CREATE, ALTER, DROP)
Input: sql (string): The SQL statement to execute
Automatically wrapped in a transaction with configurable timeout
Returns a transaction ID for explicit commit
Important safety feature: The conversation will end after execution, allowing the user to review the results before deciding to commit or rollback
executemaintenance
Execute maintenance commands like VACUUM, ANALYZE, or CREATE DATABASE outside of transactions
Input: sql (string): The SQL statement to execute - must be VACUUM, ANALYZE, or CREATE DATABASE
Returns a result object with execution time metrics
executecommit
Explicitly commit a transaction by its ID
Input: transactionid (string): ID of the transaction to commit
Safely handles cleanup after commit or rollback
Permanently applies changes to the database
executerollback
Explicitly rollback a transaction by its ID
Input: transactionid (string): ID of the transaction to rollback
Safely discards all changes and cleans up resources
Useful when reviewing changes and deciding not to apply them
listtables
Get a comprehensive list of all tables in the database
Includes column count and table descriptions
No input parameters required
describetable
Get detailed information about a specific table structure
## Table of Contents
Features
Full Read-Write Access
Rich Schema Information
Advanced Safety Controls
Tools
executequery
executedmlddldcltcl
executemaintenance
executecommit
executerollback
listtables
describetable
Resources
Using with Claude Desktop
Claude Desktop Integration
Important: Using "Allow Once" for Safety
Environment Variables
Using Full Database Access with Claude
Security Considerations
Database User Permissions
Best Practices for Safe Usage
Docker
License
Comparison with Official PostgreSQL MCP Server
## 🌟 Features
### Full Read-Write Access
Safely execute DML operations (INSERT, UPDATE, DELETE)
Create, alter, and manage database objects with DDL
Transaction management with explicit commit
Safety timeouts and automatic rollback protection
### Rich Schema Information
Detailed column metadata (data types, descriptions, max length, nullability)
Primary key identification
Foreign key relationships
Index information with type and uniqueness flags
Table row count estimates
Table and column descriptions (when available)
### Advanced Safety Controls
SQL query classification (DQL, DML, DDL, DCL, TCL)
Enforced read-only execution for safe queries
All operations run in isolated transactions
Automatic transaction timeout monitoring
Configurable safety limits
Two-step transaction commit process with explicit user confirmation
## 🔧 Tools
executequery
Execute read-only SQL queries (SELECT statements)
Input: sql (string): The SQL query to execute
All queries are executed within a READ ONLY transaction
Results include execution time metrics and field information
executedmlddldcltcl
Execute data modification operations (INSERT, UPDATE, DELETE) or schema changes (CREATE, ALTER, DROP)
Input: sql (string): The SQL statement to execute
Automatically wrapped in a transaction with configurable timeout
Returns a transaction ID for explicit commit
Important safety feature: The conversation will end after execution, allowing the user to review the results before deciding to commit or rollback
executemaintenance
Execute maintenance commands like VACUUM, ANALYZE, or CREATE DATABASE outside of transactions
Input: sql (string): The SQL statement to execute - must be VACUUM, ANALYZE, or CREATE DATABASE
Returns a result object with execution time metrics
executecommit
Explicitly commit a transaction by its ID
Input: transactionid (string): ID of the transaction to commit
Safely handles cleanup after commit or rollback
Permanently applies changes to the database
executerollback
Explicitly rollback a transaction by its ID
Input: transactionid (string): ID of the transaction to rollback
Safely discards all changes and cleans up resources
Useful when reviewing changes and deciding not to apply them
listtables
Get a comprehensive list of all tables in the database
Includes column count and table descriptions
No input parameters required
describetable
Get detailed information about a specific table structure
收录徽章（可选）
想把收录标记放进 README 就复制这行，可选，不影响收录。
[](https://anclum.com/zh/s/syahiidkamil-mcp-postgres-full-access/)
- 来源
- awesome · https://github.com/syahiidkamil/mcp-postgres-full-access
- 按领域浏览
- MCP 服务
- 收录来源
- 10 个独立来源
- 收录于
- 今天
同类推荐
所属领域与标签
每个标签都能点进去看同类的全部条目。数字是当前库里的真实条数。