소개
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.
주요 기능
- 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
사용 사례
- 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.
Sponsored