Mimer MCP Server
A Model Context Protocol (MCP) server that provides Mimer SQL database connectivity to browse database schemas, execute read-only queries with parameterization support, and manage stored procedures.
Agenten stärken
Der eigene Befehl des Herausgebers. Kein PlugMCP-Endpunkt.
Host a copy with our keys and logs.
uvx mimer-mcp-server==1.0.5Claude Code hat keinen Installationslink für einen lokalen Befehl. Kopieren Sie den Befehl unten und führen Sie ihn in einem Terminal aus.
DB_DSN=<value> DB_USER=<value> DB_PASSWORD=<secret> DB_HOST=<value> DB_PORT=<value> DB_PROTOCOL=<value> DB_POOL_INITIAL_CON=<value> DB_POOL_MAX_UNUSED=<value> DB_POOL_MAX_CON=<value> DB_POOL_BLOCK=<value> DB_POOL_DEEP_HEALTH_CHECK=<value> MCP_LOG_LEVEL=<value> claude mcp add io.github.mimersql-mimer-mcp -- uvx mimer-mcp-server==1.0.5In einem Terminal ausführen.
{ "mcpServers": { "io.github.mimersql-mimer-mcp": { "command": "uvx", "args": [ "mimer-mcp-server==1.0.5" ], "env": { "DB_DSN": "<value>", "DB_USER": "<value>", "DB_PASSWORD": "<secret>", "DB_HOST": "<value>", "DB_PORT": "<value>", "DB_PROTOCOL": "<value>", "DB_POOL_INITIAL_CON": "<value>", "DB_POOL_MAX_UNUSED": "<value>", "DB_POOL_MAX_CON": "<value>", "DB_POOL_BLOCK": "<value>", "DB_POOL_DEEP_HEALTH_CHECK": "<value>", "MCP_LOG_LEVEL": "<value>" } } }}claude_desktop_config.json
Remote-URL oder ein Befehl auf Ihrem Rechner? Worin sich die beiden Installationen unterscheiden
Auf PlugMCP ausführen
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
StartenVom Herausgeber
A Model Context Protocol (MCP) server that provides Mimer SQL database connectivity to browse database schemas, execute read-only queries with parameterization support, and manage stored procedures.
An MCP server with Mimer SQL Database Connectivity
list_schemas — List all available schemas in the databaselist_table_names — List table names within the specified schemaget_table_info — Get detailed table schema and sample rowsexecute_query — Execute SQL query with parameter support (Only SELECT queries are allowed)list_stored_procedures — List read-only stored procedures in the databaseget_stored_procedure_definition — Get the definition of a stored procedureget_stored_procedure_parameters — Get the parameters of a stored procedureexecute_stored_procedure — Execute a stored procedure in the database with JSON parametersBefore running the server, you need to configure your database connection settings using environment variables. The Mimer MCP Server reads these from a .env file.
Mimer MCP Server can be configured using environment variables through .env file with the following configuration option:
MCP servers are configured using a JSON file (mcp.json). Different MCP hosts may have slightly different configuration formats. In this guide, we'll focus on VS Code as an example. First, ensure you've installed the latest version of VS Code and have access to Copilot.
One way to add MCP server in VS Code is to add the server configuration to your workspace in the .vscode/mcp.json file. This will allow you to share configuration with others.
.vscode/mcp.json file in your workspace..vscode/mcp.json file, depending on how you want to run the MCP server.docker build -t mimer-mcp-server .
Then, add the following configuration to .vscode/mcp.json file
{
"servers": {
"mimer-mcp-server": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"--add-host=host.docker.internal:host-gateway",
"--env-file=/absolute/path/to/.env",
"mimer-mcp-server",
]
}
},
"inputs": []
}
{
"servers": {
"mimer-mcp-server": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"--add-host=host.docker.internal:host-gateway",
"--env-file=/absolute/path/to/.env",
"mimersql/mimer-mcp:latest"
]
}
},
"inputs": []
}
This will start a Mimer SQL Docker container as well as the mimer-mcp-server container,
set up a private network between the two containers and create the Mimer SQL example database.
The Mimer SQL database will be stored in the docker volume called mimer_mcp_data so that database changes are persistent.
{
"servers": {
"mimer-mcp-server": {
"command": "docker",
"args": [
"compose",
"run",
"--rm",
"-i",
"--no-TTY",
"mimer-mcp-server"
]
}
},
"inputs": []
}
{
"servers": {
"mimer-mcp-server": {
"type": "stdio",
"command": "uvx",
"args": [
"mimer_mcp_server"
],
"env": {
"DOTENV_PATH": "/absolute/path/to/.env"
}
}
}
}
{
"servers": {
"mimer-mcp-server": {
"type": "stdio",
"command": "uv",
"args": [
"run",
"--with",
"fastmcp",
"fastmcp",
"run",
"/path-to/server.py"
],
}
}
}
mcp.json file. Click it to launch the server.uv:# macOS / Linux
curl -LsSf https://astral.sh/uv/install.sh | sh
# or via Homebrew
brew install uv
Verify installation:
uv --version
# Linux (Ubuntu/Debian)
sudo apt install nodejs npm
# macOS (via Homebrew)
brew install node
Verify installation:
node --version
npm --version
Clone the repository
Create and activate a virtual environment
uv venv
# macOS / Linux
source .venv/bin/activate
# Windows
.venv\Scripts\activate
uv sync
cp .env.example .env
# Edit .env with your database credentials
The configuration is loaded automatically via config.py.
MCP Inspector provides a web interface for testing and debugging MCP Tools (Requires Node.js: 22.7.5+):
npx @modelcontextprotocol/inspector
Note: MCP Inspector is a Node.js app and the npx command allows running MCP Inspector without having to permanently install it as a Node.js package.
Alternatively, you can use FastMCP CLI to start the MCP inspector
uv run fastmcp dev inspector src/mimer_mcp_server/server.py
To run the Mimer SQL docker image and mimer-mcp-server using Docker compose, run:
MCP_TRANSPORT=http docker compose up
or to run it as a daemon:
MCP_TRANSPORT=http docker compose up -d
This way it is possible to call the mimer-mcp-server using HTTP and port 3333.
{ "mcpServers": { "io.github.mimersql-mimer-mcp": { "command": "uvx", "args": [ "mimer-mcp-server==1.0.5" ], "env": { "DB_DSN": "<value>", "DB_USER": "<value>", "DB_PASSWORD": "<secret>", "DB_HOST": "<value>", "DB_PORT": "<value>", "DB_PROTOCOL": "<value>", "DB_POOL_INITIAL_CON": "<value>", "DB_POOL_MAX_UNUSED": "<value>", "DB_POOL_MAX_CON": "<value>", "DB_POOL_BLOCK": "<value>", "DB_POOL_DEEP_HEALTH_CHECK": "<value>", "MCP_LOG_LEVEL": "<value>" } } }}Tools
Noch keine Tool-Liste. Remote-Server erhalten eine nach dem ersten Health-Check.
FAQ
Kopieren Sie auf dieser Seite die stdio-Konfiguration für Cursor, Claude Desktop, Claude Code oder VS Code. Sie nutzt die Installation des Herausgebers, keinen PlugMCP-Proxy.
Der Herausgeber nennt diese Umgebungsvariablen: DB_DSN, DB_USER, DB_PASSWORD, DB_HOST, DB_PORT, DB_PROTOCOL, DB_POOL_INITIAL_CON, DB_POOL_MAX_UNUSED, DB_POOL_MAX_CON, DB_POOL_BLOCK, DB_POOL_DEEP_HEALTH_CHECK, MCP_LOG_LEVEL.
Mimer läuft lokal über stdio.
Zuletzt geprüft: 2026-11-09. An MCP server with Mimer SQL Database Connectivity