# Universal DB MCP — 17 Databases, Read-Only Default

> Universal DB MCP is a multi-DB MCP connector (stdio/http) with read-only default and caching; verified 782★ and documents 25x–100x speedups in README.

## Install

Merge the JSON below into your `.mcp.json`:

## Quick Use

```bash
npm install -g universal-db-mcp
# MCP stdio (example):
npx universal-db-mcp --type mysql --host localhost --port 3306 --user root --password '***' --database your_db
# HTTP mode:
export MODE=http HTTP_PORT=3000 API_KEYS=your-secret-key
npx universal-db-mcp
```

## Intro

Universal DB MCP is a multi-DB MCP connector (stdio/http) with read-only default and caching; verified 782★ and documents 25x–100x speedups in README.

**Best for:** Teams who want natural-language querying across MySQL/Postgres/Redis/MongoDB/SQLite and more with safer defaults

**Works with:** Claude Desktop/Cursor/VS Code MCP hosts (stdio) and remote platforms via SSE/Streamable HTTP

**Setup time:** 10-25 minutes

### Key facts (verified)

- GitHub: 781 stars · 75 forks · pushed 2026-03-17.
- License: MIT · owner avatar + repo URL verified via GitHub API.
- README-backed entrypoint: `npx universal-db-mcp --type mysql ...`.

## Main

- Use read-only mode first: validate schema access and Text2SQL accuracy before enabling any write permissions.

- Pick your transport based on deployment: stdio for local MCP hosts; Streamable HTTP/SSE when you need remote connections (Dify, services).

- For large schemas, rely on caching and batch schema retrieval; README includes a table showing 25x–100x improvements as table counts grow.

### Source-backed notes

- README claims “17 database support” and lists MySQL/PostgreSQL/Redis/Oracle/SQL Server/MongoDB/SQLite plus additional vendors.
- README states read-only is the default and describes permission modes for write operations.
- README shows two startup modes (stdio/http) and multiple access methods (MCP stdio, SSE, Streamable HTTP, REST API).

### FAQ

- **Is write access enabled by default?**: No — README says read-only is the default and write permissions must be explicitly enabled.
- **Which transport should I choose?**: Use stdio for local Claude Desktop/Cursor; use Streamable HTTP/SSE for remote deployments.
- **How does it handle large schemas?**: README documents schema caching and batch retrieval, with a performance table up to 100x improvements.

## Source & Thanks

> Source: https://github.com/Anarkh-Lee/universal-db-mcp
> License: MIT
> GitHub stars: 781 · forks: 75

---

<!-- ZH -->

## Quick Use

```bash
npm install -g universal-db-mcp
# MCP stdio (example):
npx universal-db-mcp --type mysql --host localhost --port 3306 --user root --password '***' --database your_db
# HTTP mode:
export MODE=http HTTP_PORT=3000 API_KEYS=your-secret-key
npx universal-db-mcp
```

## Intro

Universal DB MCP 是多数据库 MCP 连接器（stdio/http），默认只读并带 schema 缓存；已验证 782★，README 给出 25x–100x 的 schema 提速数据。

**Best for:** 希望用自然语言查询 MySQL/Postgres/Redis/MongoDB/SQLite 等多库，并需要安全默认值的团队

**Works with:** Claude Desktop/Cursor/VS Code 等 MCP Host（stdio），以及通过 SSE/Streamable HTTP 的远程平台

**Setup time:** 10-25 minutes

### Key facts (verified)

- GitHub：781 stars · 75 forks；最近更新 2026-03-17。
- 许可证：MIT；作者头像与仓库链接均已通过 GitHub API 复核。
- README 中可对照的入口命令：`npx universal-db-mcp --type mysql ...`。

## Main

- 先坚持只读：先验证 schema 访问与 Text2SQL 准确性，再考虑放开写权限。

- 按部署选择传输：本地 MCP host 用 stdio；需要远程接入时用 Streamable HTTP/SSE（如 Dify/服务化）。

- 大库场景优先用 schema 缓存与批量检索；README 的表格给出随着表数量增长的 25x–100x 提速。

### Source-backed notes

- README 写明支持 17 种数据库，并列出 MySQL/PostgreSQL/Redis/Oracle/SQL Server/MongoDB/SQLite 等。
- README 说明默认只读，并提供写权限的 permission mode 配置方式。
- README 展示两种启动模式（stdio/http）与多种接入方式（MCP stdio、SSE、Streamable HTTP、REST API）。

### FAQ

- **默认会开放写操作吗？**：不会。README 明确默认只读，写权限需要显式开启。
- **应该选哪种 transport？**：本地 Claude Desktop/Cursor 用 stdio；远程部署更适合 Streamable HTTP/SSE。
- **大 schema 怎么优化？**：README 提供 schema 缓存与批量检索，并用表格展示最高到 100x 的提升。

## Source & Thanks

> Source: https://github.com/Anarkh-Lee/universal-db-mcp
> License: MIT
> GitHub stars: 781 · forks: 75


---
Source: https://tokrepo.com/en/workflows/universal-db-mcp-17-databases-read-only-default
Author: MCP Hub