MCP.so
Sign In

ZeMCP - Database Model Context Protocol Servers

@aziouiz

About ZeMCP - Database Model Context Protocol Servers

a collection of zero effort MCP servers

Basic information

Category

Databases

License

MIT license

Runtime

node

Transports

stdio

Publisher

aziouiz

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Databases MCP servers