Mimer MCP server

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.

<!-- mcp-name: io.github.mimersql/mimer-mcp -->

Available Tools

Database Schema Tools

• list_schemas — List all available schemas in the database
• listtablenames — List table names within the specified schema
• gettableinfo — Get detailed table schema and sample rows

Query Execution Tools

• execute_query — Execute SQL query with parameter support (Only SELECT queries are allowed)

Stored Procedure Tools

• liststoredprocedures — List read-only stored procedures in the database
• getstoredprocedure_definition — Get the definition of a stored procedure
• getstoredprocedure_parameters — Get the parameters of a stored procedure
• executestoredprocedure — Execute a stored procedure in the database with JSON parameters

Getting Started

Prerequisites

• Python 3.10 or later (with uv installed) or Docker
• Mimer SQL 11.0 or later

Environment Configuration

Before 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:

Usage with VS Code

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.

1. Create a .vscode/mcp.json file in your workspace.
2. Add the following configuration to your .vscode/mcp.json file, depending on how you want to run the MCP server.

Option 1: Using Docker (Recommended)

Option 1.1: Build the Docker Image Locally

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": []
}

Option 1.2: Use the Pre-Built Image from Docker Hub

Shortened. The full README is on GitHub.