PostgreSQL

Acerca de

The PostgreSQL MCP Server acts as a secure gateway to your PostgreSQL databases, specifically designed for read-only operations. It implements the Model Context Protocol (MCP) to allow external clients, such as AI agents or analytical tools, to safely execute SELECT queries, inspect database schema, and monitor query history. With robust security features like automatic read-only transaction enforcement, query validation, and SQL injection prevention, it ensures data integrity while providing valuable insights into your database's structure and activity.

Características Principales

• Multiple Output Formats (JSON, CSV, Markdown) for query results
• Comprehensive Schema Inspection (tables, columns, indexes, schemas)
• 0 GitHub stars
• Read-Only Query Execution with transaction enforcement
• Query History Tracking with execution metadata
• Advanced Security (query validation, SQL injection prevention)

Casos de Uso

• Providing secure, read-only data access for analytical tools and reporting systems.
• Automating database schema exploration and metadata retrieval for development or monitoring workflows.
• Integrating PostgreSQL database access with MCP clients like Claude Desktop for AI agent interaction.