ZeMCP - Database Model Context Protocol Servers

Name: ZeMCP - Database Model Context Protocol Servers
Author: aziouiz

@aziouiz

代码仓库

关于 ZeMCP - Database Model Context Protocol Servers

a collection of zero effort MCP servers

#database #mcp #servers

基本信息

分类

数据库

许可证

MIT license

运行时

node

传输方式

stdio

发布者

aziouiz

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "zemcp": {
      "command": "npx",
      "args": [
        "zemcp-mssql"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is ZeMCP - Database Model Context Protocol Servers?

A collection of Model Context Protocol (MCP) servers for secure, standardized database interactions with Microsoft SQL Server and Oracle Database. Designed for MCP‑compatible clients like VS Code, it lets developers execute queries and scripts safely through environment‑based configuration.

How to use ZeMCP - Database Model Context Protocol Servers?

Run directly via npx zemcp-mssql or npx zemcp-oracle after setting the required environment variables (e.g., DB_HOST, DB_USER, DB_PASSWORD). Alternatively, install globally with npm install -g zemcp-mssql or npm install -g zemcp-oracle. Integrate the server into an MCP client by using the npx command as the executable.

Key features of ZeMCP - Database Model Context Protocol Servers

execute-query – safely run SELECT queries
execute-script – run multiple SQL statements (INSERT, UPDATE, DELETE, DDL)
Parameterized queries to prevent SQL injection
Environment‑based configuration (no hard‑coded credentials)
Read‑only and write operations are clearly separated
Optional dangerous operation detection (disabled by default)

Use cases of ZeMCP - Database Model Context Protocol Servers

Quickly query SQL Server or Oracle databases from an LLM‑powered IDE
Run safe, parameterized SELECT queries against production or development databases
Execute multi‑statement scripts for data manipulation or DDL tasks
Build secure, MCP‑based automation that separates read and write operations
Use Docker to spin up local SQL Server and Oracle instances for testing and development

FAQ from ZeMCP - Database Model Context Protocol Servers

What databases does ZeMCP support?

Microsoft SQL Server (via zemcp-mssql) and Oracle Database (via zemcp-oracle).

How do I run the server without installing anything?

Use npx zemcp-mssql or npx zemcp-oracle after exporting the required environment variables.

What security measures are included?

Input validation (when enabled), parameterized queries, environment‑based configuration, and a clear separation of read‑only and write operations.

What are the runtime requirements?

Node.js 18+, TypeScript, and access to a SQL Server or Oracle Database instance.

Can I use ZeMCP with VS Code?

Yes – the servers are designed to work with MCP‑compatible clients, and VS Code configuration examples are provided in each package’s documentation.

数据库分类下的更多 MCP 服务器

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245