multidb_mcp_server
If you are the rightful owner of multidb_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.
A Model Context Protocol (MCP) server that facilitates secure interaction with multiple SQL databases, enabling AI assistants to perform database operations safely and efficiently.
The Multi-Database MCP Server is designed to provide a secure and structured interface for interacting with various SQL databases, including MySQL, PostgreSQL, and Microsoft SQL Server. It supports database exploration and analysis by allowing AI assistants to list tables, read data, and execute SQL queries. The server ensures security through read-only configurations and password masking, and it offers flexible deployment options, including STDIO and HTTP modes, as well as Docker containerization. This makes it suitable for both development and production environments, providing a robust solution for multi-database management.
Features
- Multi-Database Support: Full support for MySQL, PostgreSQL, and Microsoft SQL Server.
- Unified Operations: Allows database discovery, table operations, schema exploration, and query execution.
- Read-Only Mode: Configurable restrictions to ensure safe database interactions.
- Secure Configuration: Uses JSON/YAML for configuration with password masking.
- Deployment Options: Supports STDIO, HTTP, and Docker deployment for flexibility.
Tools
list_databases
Lists all configured databases.
list_tables
Lists tables in a specific database.
describe_table
Describes the structure of a table.
get_schema
Gets the complete schema of a database.
execute_sql
Executes an SQL query on a specific database.