Postgres

Acerca de

This project implements a secure Model Context Protocol (MCP) server designed to safely expose data from a PostgreSQL-based Hospital Management System to AI clients like Claude Desktop. It establishes robust security measures through the creation of read-only database views and restricted PostgreSQL roles, ensuring that only non-sensitive, pre-approved information is accessible. The server provides a set of parameterized, read-only tools that allow AI models to query hospital data without direct access to raw, sensitive tables, facilitating secure and controlled data interaction.

Características Principales

• Pre-defined tools for structured data access (e.g., doctor, department, appointment queries)
• Secure read-only PostgreSQL integration
• Seamless integration with Claude Desktop for AI-driven data querying
• 0 GitHub stars
• Parameterized and safely constrained SQL queries
• Data exposure via SQL views and restricted database roles

Casos de Uso

• Developing AI tools that interact with a PostgreSQL backend through a defined, secure interface.
• Securely allowing AI assistants to query hospital management system data without direct database access.
• Providing controlled, read-only access to sensitive production databases for AI applications.