universal-db-mcp-server
If you are the rightful owner of universal-db-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This is a universal database MCP (Model Context Protocol) server that supports connections to various relational database systems and provides database structure information and execution of read-only SQL queries.
The Universal Database MCP Server is designed to facilitate seamless communication with multiple relational database systems, including MySQL, PostgreSQL, Oracle, SQL Server, and SQLite. It provides comprehensive metadata access, allowing users to retrieve database table structures, field annotations, primary keys, indexes, and foreign key information. The server also enables users to view sample data from tables and execute secure, read-only SQL queries. With built-in data privacy protection, sensitive information is automatically masked to safeguard privacy. The server communicates using the standard MCP protocol and employs Server-Sent Events (SSE) for data transmission, eliminating the need for WebSocket dependencies. It requires Python 3.10 or higher and can be deployed directly or via Docker, with flexible configuration options available through environment variables or command-line parameters.
Features
- Multi-Database Support: Supports MySQL, PostgreSQL, Oracle, SQL Server, and SQLite.
- Metadata Access: Retrieve database table structures, field annotations, primary keys, indexes, and foreign key information.
- Sample Data Viewing: Quickly view sample data from tables.
- Read-Only SQL Queries: Execute secure, read-only SQL queries.
- Data Privacy Protection: Automatically masks sensitive information to protect privacy.
