Universal DB MCP is a powerful database MCP connector supporting a wide range of databases and platforms, offering flexible architecture and multiple permission controls, but users must pay attention to security configuration and permission management.
Universal DB MCP is a universal database connector implementing the Model Context Protocol (MCP) and HTTP API, enabling AI assistants to query and analyze databases using natural language. It supports 17 databases including MySQL, PostgreSQL, Oracle, MongoDB, and 10 Chinese domestic databases. It offers 2 startup modes (stdio/http) with 4 access methods: MCP stdio, MCP SSE, MCP Streamable HTTP, and REST API. It works with 50+ platforms such as Claude Desktop, Cursor, Windsurf, VS Code, and ChatGPT. Features include read-only mode by default, flexible permission modes, intelligent caching, batch query optimization, multi-schema support, and data masking.
Install globally: npm install -g universal-db-mcp
For Claude Desktop, edit the configuration file (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json; Windows: %APPDATA%\Claude\claude_desktop_config.json) and add the mcpServers configuration, then restart Claude Desktop.
For HTTP mode: set environment variables MODE=http, HTTP_PORT=3000, API_KEYS=your-secret-key, then run npx universal-db-mcp.
{
"mcpServers": {
"my-database": {
"command": "npx",
"args": [
"universal-db-mcp",
"--type", "mysql",
"--host", "localhost",
"--port", "3306",
"--user", "root",
"--password", "your_password",
"--database", "your_database"
]
}
}
}