ZeMCP - Database Model Context Protocol Servers
@aziouiz
About ZeMCP - Database Model Context Protocol Servers
a collection of zero effort MCP servers
Basic information
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.
More Databases MCP servers
MCP Server for Milvus
zilliztechModel Context Protocol Servers for Milvus
Sail MCP Server for Spark SQL
lakehqDrop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.
mcp-server-duckdb
ktanaka101A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities
Meilisearch MCP Server
meilisearchA Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
Comments