mcp-multiple-db-toolbox
by trupti79916
Overview
The MCP server acts as a unified gateway to connect to and interact with multiple database types (PostgreSQL, MongoDB, Redis, SAP HANA) via dynamically generated tools.
Installation
python main.pyEnvironment Variables
- PROD_POSTGRES_USER
- PROD_POSTGRES_PASSWORD
- MONGODB_ATLAS_URI
- MONGODB_ATLAS_DB
- HANA_HOST
- HANA_PORT
- HANA_USER
- HANA_PASSWORD
- HANA_SCHEMA
- ANALYTICS_POSTGRES_USER
- ANALYTICS_POSTGRES_PASSWORD
Security Notes
The MongoDB connector sets `tlsAllowInvalidCertificates=True`. While the code comment suggests this is for development, it is a critical security vulnerability for production deployments as it disables TLS certificate validation, making the connection susceptible to man-in-the-middle attacks. This makes the system unsafe for sensitive data in production. Other database connectors use parameterized queries (PostgreSQL, HANA), which is good for SQL injection prevention. Credentials are handled via environment variables, which is a good practice.
Similar Servers
db-mcp-server
Provides AI assistants with structured access to multiple database systems (MySQL, PostgreSQL, SQLite, TimescaleDB) through the Model Context Protocol (MCP).
jewei-mssql-mcp-server
Provides a Micro-Agent Protocol (MCP) server for querying Microsoft SQL Server databases and retrieving table structures.
DatabaseMcpServer
Provides a robust and secure database access layer for AI assistants, supporting 19 types of databases with single-instance multi-database dynamic switching and over 50 tools for data and schema management.
postgres-mysql-mcp-server
A Model Context Protocol (MCP) server that enables AI assistants to query PostgreSQL and MySQL databases for schema introspection and data retrieval.