通用数据库 MCP 服务器

@xiaoshi7915

a year ago

一个通用数据库 MCP服务器，支持连接到各种关系型数据库系统并提供数据库结构信息和执行只读 SQL 查询

Overview

What is Universal Db Mcp Server?

Universal Db Mcp Server is a versatile database MCP (Model Context Protocol) server that supports connections to various relational database systems, providing database structure information and executing read-only SQL queries.

How to use Universal Db Mcp Server?

To use the server, clone the repository, install the dependencies, and start the server with the appropriate database connection parameters. Alternatively, it can be deployed using Docker.

Key features of Universal Db Mcp Server?

Multi-database support: Connects to MySQL, PostgreSQL, Oracle, SQL Server, and SQLite.
Metadata access: Retrieve database table structures, field comments, primary keys, indexes, and foreign key information.
Sample data viewing: Quickly view sample data from various tables.
Read-only SQL queries: Execute any read-only SQL queries securely.
Data privacy protection: Automatically masks sensitive information to protect privacy data.
MCP protocol communication: Communicates with large language models via the standard MCP protocol.
SSE transmission: Uses Server-Sent Events (SSE) for data transmission without WebSocket dependency.

Use cases of Universal Db Mcp Server?

Accessing and querying data from multiple database systems.
Providing a secure interface for read-only database operations.
Integrating with applications that require database metadata and sample data.

FAQ from Universal Db Mcp Server?

Can this server connect to all major relational databases?

Yes! It supports MySQL, PostgreSQL, Oracle, SQL Server, and SQLite.

Is it safe to use this server in production?

Yes! It is designed for read-only operations and includes features for data privacy protection.

How can I deploy it using Docker?

You can build a Docker image and run a container with the necessary environment variables for database connection.

Try in Playground

Server Config

{
  "mcpServers": {
    "db": {
      "command": "/path/to/start.sh",
      "args": [
        "--db-host",
        "localhost",
        "--db-user",
        "root",
        "--db-password",
        "password",
        "--db-name",
        "mydatabase"
      ],
      "env": {
        "DB_TYPE": "mysql"
      }
    }
  }
}

Build with ShipAny.