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 Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

mcp_mysql_server

xwb602625136

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

245