MCP Universal DB Client

You can connect to and query multiple databases from a single MCP server. This universal DB client lets you manage concurrent connections to PostgreSQL, MySQL, and SQLite, while giving you separate read and write pathways and built‑in protection against destructive queries.

How to use

Set up your MCP client to use the universal DB server, then create and manage database connections. Use read‑only queries to fetch data and show schema information, and use write queries only when you are authorized to modify data. The server validates read queries to prevent destructive actions and routes write queries to the appropriate database.

How to install

Prerequisites: you need Node.js and npm installed on your system.

1. Install Node.js from the official site and confirm installation with node -v and npm -v.

2. Add the MCP server to your MCP settings by including the following configuration.

{
  "mcpServers": {
    "universal-db-client": {
      "command": "npx",
      "args": ["-y", "@izumisy/mcp-universal-db-client"]
    }
  }
}

Configuration and security notes

You should manage your database connections through the available tools to keep access controlled and auditable.

Use the read‑only tool for queries that do not modify data. Reserve the write tool for authorized operations only.

Practical examples and tools

The server exposes a set of tools to manage connections and execute queries. Each tool is described below to help you implement common workflows.

Troubleshooting and notes

If you encounter permission or connection issues, verify that your connection strings are correct, the target databases are reachable, and that you are using the appropriate tool (read vs write) for the operation. Review any error messages for hints about authentication, network access, or SQL syntax.

Available tools

connect_database

Connect to a database using a connection string. Requires a unique connection name, the dialect (psql, mysql, sqlite), and the connection string.

list_connections

List all active database connections with their IDs, dialects, and connection times.

disconnect_database

Disconnect a specific database connection by its connection ID.

disconnect_all

Disconnect all active database connections.

query_read

Run read-only SQL queries safely. Supports SELECT, SHOW, DESCRIBE/DESC, and EXPLAIN. Validates queries and rejects destructive operations.

query_write

Run data‑modifying SQL queries such as INSERT, UPDATE, DELETE, and DDL operations. Use with caution as these can modify data.