S
syahiidkamil/mcp-postgres-full-access
Full access postgres mcp server
View on GitHub ↗Link checked 2026-11-12 · HTTP 200 · opens the vendor's own site
Install & config
- Copy the command above
- Paste it as one entry under
mcpServersinclaude_desktop_config.json— local servers take command + args (example: clients) - Restart your client
Client config (built from the install command this repo gives)
{
"mcpServers": {
"syahiidkamil-mcp-postgres-full-access": {
"command": "npx",
"args": ["-y", "mcp-postgres-full-access", "postgresql://username:password@localhost:5432/database"]
}
}
}Parsed from the README we fetched on 2026-11-04; we have not executed it.
command/args come from the install command the repository states. When it is ambiguous, the project README wins.
VS Code (.vscode/mcp.json - the key is servers)
{
"servers": {
"syahiidkamil-mcp-postgres-full-access": {
"command": "npx",
"args": ["-y", "mcp-postgres-full-access", "postgresql://username:password@localhost:5432/database"]
}
}
}Same server, but VS Code keeps it under <code>servers</code>.
Claude Code (command line)
claude mcp add --transport stdio syahiidkamil-mcp-postgres-full-access -- npx -y mcp-postgres-full-access postgresql://username:password@localhost:5432/database
Claude Code does not read a config file; add the server with this command.
Key names differ by client: Clients & CLI
- Source
- collected from the abordage/awesome-mcp list · type: MCP server
- Harvest history
- first seen 2026-11-05 · last seen 2026-11-14 · seen 10× · listed by 10 sources
- Score
- score 1,003 · 10 sources · mcp
- Install
npx -y mcp-postgres-full-access postgresql://username:password@localhost:5432/database
FAQ (answers come from our records)
How do I install it?
The repository provides this install command:
npx -y mcp-postgres-full-access postgresql://username:password@localhost:5432/database. It comes from the repository itself; we cannot guarantee it runs as-is in your client.Who is it for?
We filed it under these tags: MCP 服务. The tags come from the entry itself, not a taxonomy we imposed.
Who maintains it?
first catalogued 2026-11-05；last seen 2026-11-14。There is no official certification or quality rating here — we record sources and dates only.
# 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
Listed badge (optional)
Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.
[](https://anclum.com/en/s/syahiidkamil-mcp-postgres-full-access/)
- Source
- awesome · https://github.com/syahiidkamil/mcp-postgres-full-access
- Browse by field
- MCP servers
- Listed by
- 10 independent sources
- added
- today
More like this
Filed under
Every tag opens the full list for that filter. Counts are the live catalogue figures.